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);
}
