BEL
namespace BusinessEntitierLayer { public class ResultOutPut { public string Result { get; set; } public string Output_msg { get; set; } public string Status { get; set; } }
DBFiles
string constr = System.Configuration.ConfigurationManager.ConnectionStrings["constr"].ConnectionString; DataTable dt = new DataTable();
//Add Department public DataTable AddDepartment(string DepartmentName) { SqlConnection conn = new SqlConnection(constr); SqlCommand cmd = new SqlCommand("sp_DepartmentAdd", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@DepartmentName", DepartmentName); try { conn.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); return dt; } catch (Exception) {
throw; } finally { conn.Close(); } }
Service
[WebMethod] public ResultOutPut[] ClientEDDV(string Action, int CID, int UID) { DBFile obj = new DBFile(); DataTable dt = obj.ClientEDDV(Action, CID, UID); List<ResultOutPut> ResultList = new List<ResultOutPut>(); try { foreach (DataRow item in dt.Rows) { ResultOutPut ClientEDDVList = new ResultOutPut(); ClientEDDVList.Result = item["Result"].ToString(); ClientEDDVList.Output_msg = item["Output_msg"].ToString(); ClientEDDVList.Status = item["Status"].ToString(); ResultList.Add(ClientEDDVList); } } catch (Exception) {
throw; } return ResultList.ToArray(); }
Jquery
function AddDepartmentFunc() {
var Department = $("#txtAddDepartment").val();
if (Department != "") { //swal("Good job!", "You clicked the button!", "success"); $.ajax({ type: "POST", contentType: "application/json; charset=utf-8", url: "../../services/DepartmentWebService.asmx/AddDepartment", data: "{'DepartmentName':'" + Department + "'}", dataType: "json", success: function (data) { var obj = data.d; for (var i = 0; i < obj.length; i++) { var MsgResult = obj[i].Result; var OutPutMsg = obj[i].Output_msg; var MsgStatus = obj[i].Status; swal("", OutPutMsg, MsgStatus).then(function () { location.reload(); }); //swal("", OutPutMsg, MsgStatus); } }, error: function (result) { alert("Error Occured"); } }); } else { $("#txtAddDepartment").addClass("is-invalid"); } }
