public DataBaseResultSet SaveCustomerMaster <T>(T objData) where T : class, IModel, new() { CustomerMaster obj = objData as CustomerMaster; string sQuery = "sprocCustomerMasterInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("CustomerCode", "CustomerCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.CustomerCode)); list.Add(SqlConnManager.GetConnParameters("ICode", "ICode", 13, GenericDataType.String, ParameterDirection.Input, obj.ICode)); list.Add(SqlConnManager.GetConnParameters("CustomerName", "CustomerName", 50, GenericDataType.String, ParameterDirection.Input, obj.CustomerName)); list.Add(SqlConnManager.GetConnParameters("Add1", "Add1", 50, GenericDataType.String, ParameterDirection.Input, obj.Add1)); list.Add(SqlConnManager.GetConnParameters("Phone1", "Phone1", 50, GenericDataType.String, ParameterDirection.Input, obj.Phone1)); list.Add(SqlConnManager.GetConnParameters("Email", "Email", 50, GenericDataType.String, ParameterDirection.Input, obj.Email)); list.Add(SqlConnManager.GetConnParameters("DoctorCode", "DoctorCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.DoctorCode)); list.Add(SqlConnManager.GetConnParameters("MemberCode", "MemberCode", 20, GenericDataType.String, ParameterDirection.Input, obj.MemberCode)); list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser)); list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime)); list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser)); list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime)); list.Add(SqlConnManager.GetConnParameters("LCode", "LCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.LCode)); list.Add(SqlConnManager.GetConnParameters("DLock", "DLock", 3, GenericDataType.String, ParameterDirection.Input, obj.DLock)); list.Add(SqlConnManager.GetConnParameters("CashDiscount", "CashDiscount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CashDiscount)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public IHttpActionResult PostCustomerMaster(CustomerMaster customerMaster) { db.CustomerMasters.Add(customerMaster); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = customerMaster.CustomerId }, customerMaster)); }
public async Task <IActionResult> PutCustomerMaster(string id, CustomerMaster customerMaster) { if (id != customerMaster.CustCd) { return(BadRequest()); } _context.Entry(customerMaster).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CustomerMasterExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
protected void BtnDelete_Click(object sender, EventArgs e) { try { int DeleteId = 0; if (ViewState["EditID"] != null) { DeleteId = Convert.ToInt32(ViewState["EditID"]); } if (DeleteId != 0) { Entity_SupplierMaster.CustomerId = DeleteId; Entity_SupplierMaster.UserId = Convert.ToInt32(Session["UserID"]); Entity_SupplierMaster.LoginDate = DateTime.Now; Entity_SupplierMaster.IsDeleted = true; int iDelete = Obj_SupplierMaster.DeleteRecord(ref Entity_SupplierMaster, out StrError); if (iDelete != 0) { obj_Comman.ShowPopUpMsg("Record Deleted Successfully..!", this.Page); MakeEmptyForm(); } } Entity_SupplierMaster = null; Obj_SupplierMaster = null; } catch (Exception ex) { throw new Exception(ex.Message); } }
public string updateCustomerMaster(CustomerMaster customer) { string result; result = AllRecord("U", customer); return(result); }
/// <summary> /// Add Customer Detail /// </summary> /// <param name="customerMaster"></param> /// <returns></returns> public int addCustomerDetails(CustomerMaster customerMaster, int TenantId) { MySqlCommand cmd = new MySqlCommand(); int i = 0; try { conn = Db.Connection; cmd.Connection = conn; MySqlCommand cmd1 = new MySqlCommand("SP_createCustomer", conn); cmd1.Parameters.AddWithValue("@TenantID", TenantId); cmd1.Parameters.AddWithValue("@CustomerName", customerMaster.CustomerName); cmd1.Parameters.AddWithValue("@CreatedBy", customerMaster.CreatedBy); cmd1.Parameters.AddWithValue("@CustomerPhoneNumber", customerMaster.CustomerPhoneNumber); cmd1.Parameters.AddWithValue("@CustomerEmailId", customerMaster.CustomerEmailId); cmd1.Parameters.AddWithValue("@GenderID", customerMaster.GenderID); cmd1.Parameters.AddWithValue("@AltNumber", customerMaster.AltNumber); cmd1.Parameters.AddWithValue("@AltEmailID", customerMaster.AltEmailID); cmd1.Parameters.AddWithValue("@IsActive", customerMaster.IsActive); cmd1.Parameters.AddWithValue("@DOB", customerMaster.DateOfBirth); cmd1.CommandType = CommandType.StoredProcedure; i = Convert.ToInt32(cmd1.ExecuteScalar()); } catch (MySql.Data.MySqlClient.MySqlException ex) { //Console.WriteLine("Error " + ex.Number + " has occurred: " + ex.Message); } return(i); }
private void btnNewPelanggan_Click(object sender, EventArgs e) { CustomerMaster cus = new CustomerMaster(nama_pelanggan.Text); cus.ShowDialog(this); addSourceNama(); }
/// <summary> /// Update Customer /// </summary> /// <param name="customerMaster"></param> /// <returns></returns> public int updateCustomerDetails(CustomerMaster customerMaster, int TenantId) { MySqlCommand cmd = new MySqlCommand(); int i = 0; try { conn = Db.Connection; cmd.Connection = conn; MySqlCommand cmd1 = new MySqlCommand("SP_updateCustomer", conn); cmd1.Parameters.AddWithValue("@objCustomerID", customerMaster.CustomerID); cmd1.Parameters.AddWithValue("@TenantID", TenantId); cmd1.Parameters.AddWithValue("@CustomerName", customerMaster.CustomerName); cmd1.Parameters.AddWithValue("@CustomerPhoneNumber", customerMaster.CustomerPhoneNumber); cmd1.Parameters.AddWithValue("@CustomerEmailId", customerMaster.CustomerEmailId); cmd1.Parameters.AddWithValue("@GenderID", customerMaster.GenderID); cmd1.Parameters.AddWithValue("@AltNumber", customerMaster.AltNumber); cmd1.Parameters.AddWithValue("@AltEmailID", customerMaster.AltEmailID); cmd1.Parameters.AddWithValue("@IsActive", customerMaster.IsActive); cmd1.CommandType = CommandType.StoredProcedure; i = cmd1.ExecuteNonQuery(); conn.Close(); } catch (MySql.Data.MySqlClient.MySqlException ex) { //Console.WriteLine("Error " + ex.Number + " has occurred: " + ex.Message); } return(i); }
public ActionResult UpdateProfile(CustomerMaster ProfileInfo, FormCollection frm, HttpPostedFileBase file) { try { ProfileInfo.CustId = Convert.ToInt32(frm["CustId"]); Chatpata_dabbaEntities1 cd = new Chatpata_dabbaEntities1(); var user = cd.CustomerMasters.Where(q => q.CustId == ProfileInfo.CustId).FirstOrDefault(); var newFileName = ""; if (file != null) { string pic = System.IO.Path.GetFileName(file.FileName); FileInfo fi = new FileInfo(pic); string fileextension = fi.Extension.Substring(1).ToUpper(); newFileName = Convert.ToString(Guid.NewGuid()) + "." + fileextension; var FolderPath = "~/Images/"; var Imgpath = Path.Combine(Server.MapPath(FolderPath), newFileName); file.SaveAs(Imgpath); newFileName = FolderPath + newFileName; } ProfileInfo.Image = newFileName; ProfileInfo.Birthdate = user.Birthdate; cd.Entry(user).State = System.Data.Entity.EntityState.Modified; cd.SaveChanges(); return(RedirectToAction("Customer")); } catch (Exception ex) { throw ex; } }
public ActionResult Verifychpass(FormCollection frm) { try { if (Session["UserID"] == null) { return(RedirectToAction("Index", "Home")); } Chatpata_dabbaEntities1 en = new Chatpata_dabbaEntities1(); CustomerMaster cm = new CustomerMaster(); var pass = Convert.ToString(frm["new_pass"]); var id = Convert.ToInt32(Session["UserID"]); var user = en.CustomerMasters.Where(q => q.CustId == id).FirstOrDefault(); user.Password = MD5Crypt.Encrypt(pass, "Dabba"); en.Entry(user).State = System.Data.Entity.EntityState.Modified; en.SaveChanges(); return(RedirectToAction("Admin", "Admin")); } catch (Exception ex) { return(RedirectToAction("Admin")); } }
// // GET: /CustomerMaster/Delete/5 public ActionResult DeleteConfirmed(int id) { CustomerEnquiry cenquery = db.CustomerEnquiries.Where(t => t.CustomerID == id).FirstOrDefault(); if (cenquery == null) { CustomerMaster customermaster = db.CustomerMasters.Find(id); UserRegistration a = (from c in db.UserRegistrations where c.UserName == customermaster.Email select c).FirstOrDefault(); if (customermaster == null) { return(HttpNotFound()); } else { db.CustomerMasters.Remove(customermaster); db.SaveChanges(); db.UserRegistrations.Remove(a); db.SaveChanges(); TempData["SuccessMsg"] = "You have successfully Deleted Customer."; return(RedirectToAction("Index")); } } else { TempData["SuccessMsg"] = "Customer Entry could not delete,because it has reference entries!"; return(RedirectToAction("Index")); } }
public CustomerMaster EditCustomer(CustomerMaster customerMaster) { _context.CustomerMasters.Update(customerMaster); _context.SaveChanges(); return(_context.CustomerMasters.FirstOrDefault(c => c.Id == customerMaster.Id)); }
public void CanCustomerInsert() { int isSaved = 0; using (var context = new CustomerMasterRepository(new UnitOfWork())) { var cust = new CustomerMaster { addr_city_nm = "Beerakuppam", addr_ctry_nm = "India", addr_zip_cde = "517589", addr_state = "AP", addr_ln_1_txt = "Nagalapuram (M),Chittoor(d)", mid_nm = "", frst_nm = "Kanakaiah", last_nm = "Etipakam", email_addr_txt = "*****@*****.**", rec_crt_ts = DateTime.UtcNow, rec_crt_by = "Test-Project-KK" }; context.InsertOrUpdate(cust) ; isSaved = (int)cust.cust_info_id; isSaved = context.Save(); Assert.AreEqual(1, isSaved); } }
public void GetCustomerInfo(int customSysNo, Action <CustomerMaster> action) { new CustomerFacade().GetCustomerBySysNo(customSysNo, (sender, e) => { if (e.FaultsHandle()) { return; } CustomerMaster customer = new CustomerMaster(); customer.SysNo = customSysNo; customer.Balance = e.Result.ValidPrepayAmt; customer.CellPhone = e.Result.BasicInfo.Phone + " " + e.Result.BasicInfo.CellPhone; customer.ConfirmedTotalAmt = e.Result.ConfirmedTotalAmt; customer.CustomerID = e.Result.BasicInfo.CustomerID; customer.CustomerName = e.Result.BasicInfo.CustomerName; customer.CustomersType = e.Result.CustomersType; customer.Email = e.Result.BasicInfo.Email; customer.Gender = e.Result.BasicInfo.Gender.HasValue ? (Gender)e.Result.BasicInfo.Gender : customer.Gender; customer.Phone = e.Result.BasicInfo.Phone; customer.Point = e.Result.ValidScore; customer.Rank = e.Result.Rank.HasValue ? (CustomerRank)e.Result.Rank : customer.Rank; customer.RegisterTime = e.Result.BasicInfo.RegisterTime; customer.TotalSOMoney = e.Result.ConfirmedTotalAmt; customer.IsVip = e.Result.VIPRank != null; if (action != null) { action(customer); } }); }
public string insertCustomerMaster(CustomerMaster customer) { string result; result = AllRecord("I", customer); return(result); }
public ResponseModel updateCustomer([FromBody] CustomerMaster customerMaster) { Customercaller customerCaller = new Customercaller(); ResponseModel objResponseModel = new ResponseModel(); int statusCode = 0; string statusMessage = ""; try { string token = Convert.ToString(Request.Headers["X-Authorized-Token"]); Authenticate authenticate = new Authenticate(); authenticate = SecurityService.GetAuthenticateDataFromTokenCache(Cache, SecurityService.DecryptStringAES(token)); int result = customerCaller.updateCustomer(new CustomerService(Cache, Db), customerMaster, authenticate.TenantId); statusCode = result == 0 ? (int)EnumMaster.StatusCode.RecordNotFound : (int)EnumMaster.StatusCode.Success; statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode); objResponseModel.Status = true; objResponseModel.StatusCode = statusCode; objResponseModel.Message = statusMessage; } catch (Exception) { throw; } return(objResponseModel); }
public static CustomerMaster GetCustomerDetails(string customerID) { CustomerMaster CustomerDetails = new CustomerMaster(); LoginUser currentUser; try { if (!GetUserSession(out currentUser)) { CustomerDetails.ErrorCode = -1001; CustomerDetails.ErrorMessage = ""; } CustomerManager customerObj = new CustomerManager(); if (customerObj.GetCustomerDetails(currentUser.CompanyID, string.IsNullOrEmpty(customerID) ? 0 : Convert.ToInt32(customerID), currentUser.UserId, out CustomerDetails)) { CustomerDetails.ErrorCode = 0; CustomerDetails.ErrorMessage = ""; } else { CustomerDetails.ErrorCode = customerObj.GetLastErrorCode(); CustomerDetails.ErrorMessage = customerObj.GetLastError(); } } catch (Exception ex) { Utils.Write(ex); } return(CustomerDetails); }
public async Task <IActionResult> EditCustomer(int id, [Bind("Id,CustomerName,PrimaryEmail,PrimaryContactName,PrimaryContactNumber,HOAddress1,HOAddress2,HOAddress3,City,Postcode,Zone,Region,Area,StoreCode,Type,StoreName,StoreAddress1,StoreAddress2,PostTown,StorePostcode")] CustomerMaster customerMaster) { if (id != customerMaster.Id) { return(NotFound()); } if (ModelState.IsValid) { try { var user = _userManager.GetUserId(User); //var userName = _context.Users.Where(x => x.Id == user).Select(x => x.FirstName + " " + x.LastName).FirstOrDefault(); var userName = _context.Users.Where(x => x.Id == user).Select(x => x.Id).FirstOrDefault(); customerMaster.ModifiedBy = userName; _context.Update(customerMaster); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CustomerMasterExists(customerMaster.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(CustomersList))); } return(View(customerMaster)); }
public IHttpActionResult PutCustomerMaster(int id, CustomerMaster customerMaster) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != customerMaster.CustomerId) { return(BadRequest()); } db.Entry(customerMaster).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CustomerMasterExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult UpdateProfile(CustomerMaster ProfileInfo, FormCollection frm) { try { if (Session["UserID"] == null) { return(RedirectToAction("Index", "Home")); } var id = Convert.ToInt32(Session["UserID"]); ProfileInfo.CustId = Convert.ToInt32(frm["CustId"]); Chatpata_dabbaEntities1 cd = new Chatpata_dabbaEntities1(); var user = cd.CustomerMasters.Where(q => q.CustId == ProfileInfo.CustId).FirstOrDefault(); ProfileInfo.Birthdate = user.Birthdate; ProfileInfo.FirstName = user.FirstName; user.LastName = Convert.ToString(frm["LastName"]); user.Address1 = Convert.ToString(frm["Address1"]); user.Address2 = Convert.ToString(frm["Address2"]); user.Address3 = Convert.ToString(frm["Address3"]); user.Pincode = Convert.ToString(frm["Pincode"]); user.PhoneNo = Convert.ToString(frm["PhoneNo"]); cd.Entry(user).State = System.Data.Entity.EntityState.Modified; cd.SaveChanges(); return(RedirectToAction("Customer")); } catch (Exception ex) { throw ex; } }
public IHttpActionResult UpdateCustomer(CustomerMaster customer) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { // var objGM = new GaugeTypeMaster(); var objGM = new CustomerMaster(); objGM = objEntity.CustomerMasters.Find(customer.ID); if (objGM != null) { objGM.ID = customer.ID; objGM.CustomerName = customer.CustomerName; objGM.CustomerAddress = customer.CustomerAddress; objGM.CustomerEmail = customer.CustomerEmail; objGM.CustomerContactPersonName = customer.CustomerContactPersonName; objGM.CustomerContactNumber = customer.CustomerContactNumber; } int i = this.objEntity.SaveChanges(); } catch (Exception ex) { throw ex; } return(Ok(customer)); }
// GET: api/APIPartners public HttpResponseMessage Get([FromUri] Paging objPaging, [FromUri] CustomerMaster objCustomer) { int TotalRows = 0; bool blnCreate = false, blnEdit = false, blnDelete = false, blnView = false; CommonAPI commonApi = new CommonAPI(); commonApi.getHeaderValues(Request.Headers, out connectionString, out userAccount, out roleId, out companyCode, out DBProviderName); CustomerDAL categroyDAL = new CustomerDAL(connectionString, userAccount, roleId, DBProviderName, companyCode); // var categories = categroyDAL.GetPartnersList(objPaging, out TotalRows, out blnCreate , out blnEdit, out blnDelete , out blnView, objCustomer); // Create the response var response = Request.CreateResponse(HttpStatusCode.OK, objCustomer); // Set headers for paging response.Headers.Add("TotalRows", TotalRows.ToString()); response.Headers.Add("CreatePermission", blnCreate.ToString()); response.Headers.Add("UpdatePermission", blnEdit.ToString()); response.Headers.Add("DeletePermission", blnDelete.ToString()); response.Headers.Add("ViewPermission", blnView.ToString()); //response.Headers.Add("X-Paging-PageSize", pageSize.ToString()); //response.Headers.Add("X-Paging-PageCount", pageCount.ToString()); //response.Headers.Add("X-Paging-TotalRecordCount", total.ToString()); return(response); }
public ActionResult JQAjaxAddCustomerDB(CustomerMaster cm) { try { if (ModelState.IsValid) { CustomerRepository cmRepo = new CustomerRepository(); if (cmRepo.AddCustomer(cm)) { return(Json(new { msg = "Successfully added " + cm.CompanyName })); //ViewBag.Message = "Customer details added successfully"; } return(RedirectToAction("Index")); } else { return(View("Index")); } } catch (Exception ex) { throw ex; } }
public CustomerMaster GetCustomerInfo(int CustomerID) { CustomerMaster obj = null;; try { sqlcmd.CommandText = ERP_GetCustomer; sqlcmd.Parameters.AddWithValue("@CustomerID", CustomerID); sqlcmd.CommandType = CommandType.StoredProcedure; if (conn.State == ConnectionState.Closed) { conn.Open(); } using (SqlDataReader sdr = sqlcmd.ExecuteReader()) { while (sdr.Read()) { obj = new CustomerMaster(); //obj.Address = sdr["Address"].ToString(); obj.CustomerCode = sdr["CustomerCode"].ToString(); obj.CustomerBarCode = sdr["CustomerBarCode"].ToString(); obj.CustomerName = sdr["CustomerName"].ToString(); obj.ContactName = sdr["ContactName"].ToString(); obj.ContactTitle = sdr["ContactTitle"].ToString(); obj.Phone = sdr["Phone"].ToString(); obj.Fax = sdr["Fax"].ToString(); obj.ContactEmail = sdr["ContactEmail"].ToString(); obj.WebSite = sdr["WebSite"].ToString(); obj.AutoApproveSO = Convert.ToBoolean(sdr["AutoApproveSO"]); obj.AutoApproveSOAmount = Convert.ToDecimal(sdr["AutoApproveSOAmount"]); obj.AutoSendSO = Convert.ToBoolean(sdr["AutoSendSO"]); // obj.City = sdr["City"].ToString(); //obj.Region = sdr["Region"].ToString(); //obj.Country = sdr["Country"].ToString(); //obj.PostalCode = sdr["PostalCode"].ToString(); // obj.State = sdr["State"].ToString(); } sdr.Close(); sdr.Dispose(); } } catch (SqlException sqlEx) { Logger.Error("CustomerDAL.GetCustomerInfo(" + LoggedInUser + "," + CompanyCode + "," + CustomerID + ")", sqlEx); } catch (Exception ex) { Logger.Error("CustomerDAL.GetCustomerInfo(" + LoggedInUser + "," + CompanyCode + "," + CustomerID + ")", ex); } finally { } return(obj); }
private void mnuCustomerMaster_Click(object sender, RoutedEventArgs e) { customerMaster = CustomerMaster.Instance; customerMaster.Show(); customerMaster.Focus(); }
public ActionResult DeleteConfirmed(int id) { CustomerMaster customerMaster = db.CustomerMasters.Find(id); db.CustomerMasters.Remove(customerMaster); db.SaveChanges(); return(RedirectToAction("Index")); }
public JsonResult SaveCustomerData(CustomerMaster customerMaster) { var CustData = objcustomerMasterData.AddCustMasterData(customerMaster); return(new JsonResult { Data = CustData, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public string getCustomerMaster() { string result; CustomerMaster customer = new CustomerMaster(); result = AllRecord("SA", customer); return(result); }
public string getCustChartOfAccount() { string result; CustomerMaster customer = new CustomerMaster(); result = AllRecord("COA", customer); return(result); }
/// <summary> /// Get Customer By Id /// </summary> /// <param name="CustomerID"></param> /// <param name="TenantId"></param> /// <returns></returns> public CustomerMaster getCustomerbyId(int CustomerID, int TenantId) { DataSet ds = new DataSet(); CustomerMaster customerMaster = new CustomerMaster(); MySqlCommand cmd = new MySqlCommand(); try { if (conn != null && conn.State == ConnectionState.Closed) { conn.Open(); } cmd.Connection = conn; MySqlCommand cmd1 = new MySqlCommand("SP_getCustomerDetailsById", conn); cmd1.Parameters.AddWithValue("@Customer_ID", CustomerID); cmd1.Parameters.AddWithValue("@Tenant_ID", TenantId); cmd1.CommandType = CommandType.StoredProcedure; MySqlDataAdapter da = new MySqlDataAdapter { SelectCommand = cmd1 }; da.Fill(ds); if (ds != null && ds.Tables[0] != null) { if (ds.Tables[0].Rows.Count > 0) { customerMaster.CustomerID = ds.Tables[0].Rows[0]["CustomerID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[0]["CustomerID"]); customerMaster.TenantID = ds.Tables[0].Rows[0]["TenantID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[0]["TenantID"]); customerMaster.CustomerName = ds.Tables[0].Rows[0]["CustomerName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[0]["CustomerName"]); customerMaster.CustomerPhoneNumber = ds.Tables[0].Rows[0]["CustomerPhoneNumber"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[0]["CustomerPhoneNumber"]); customerMaster.CustomerEmailId = ds.Tables[0].Rows[0]["CustomerEmailId"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[0]["CustomerEmailId"]); customerMaster.GenderID = ds.Tables[0].Rows[0]["GenderID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[0]["GenderID"]); customerMaster.AltNumber = ds.Tables[0].Rows[0]["AltNumber"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[0]["AltNumber"]); customerMaster.AltEmailID = ds.Tables[0].Rows[0]["AltEmailID"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[0]["AltEmailID"]); customerMaster.DateOfBirth = default(DateTime); customerMaster.IsActive = ds.Tables[0].Rows[0]["IsActive"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[0]["IsActive"]); customerMaster.DOB = ds.Tables[0].Rows[0]["DOB"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[0]["DOB"]); } } } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } if (ds != null) { ds.Dispose(); } } return(customerMaster); }