M_Customer ICustomer.AddNewCustomer(M_Customer customer)
{
M_Customer obj = new M_Customer();
obj = icustomer.AddNewCustomer(customer);
return(obj);
}
public ActionResult DeleteCustomer(int Customer_Id)
{
UserResultModel resultdata = new UserResultModel();
M_Customer Customer = new M_Customer
{
Customer_Id = Customer_Id,
LastModifiedBy = UserHelper.GetCurrentUserName()
};
int OperationStatus = CustomerProxy.Instance.DeleteCustomer(ConfigExtension.GetWebApiUri,
"api/Customer/DeleteCustomer/" + Customer.Customer_Id + "?LastModifiedBy=" + Customer.LastModifiedBy, Customer);
if (OperationStatus == (int)operation_status.Delete)
{
resultdata.operationstatuscode = (int)operation_status.Delete;//message when Delete record.
resultdata.messagedata = UserMessage.ResourceManager.GetString("msgDelete");
}
else if (OperationStatus == (int)operation_status.Delete_Prevent)
{
resultdata.operationstatuscode = (int)operation_status.Delete;//message when Delete record.
resultdata.messagedata = UserMessage.ResourceManager.GetString("msgDeletePrevent");
}
else
{
resultdata.operationstatuscode = (int)operation_status.Error;//message when Error record.
resultdata.messagedata = UserMessage.ResourceManager.GetString("msgError");
}
return(Json(resultdata, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> Edit([Bind("CustomerCode,CustomerName,AddressL1,AddressL2,AddressL3,AddressL4,Telephone,Fax,CustomerEmail,CustomerContact,CreditTerm,PriceLevel,CustomerTaxId,Remark,CompanyCode,Id,Is_Active,Created_Date,Created_By,Updated_Date,Updated_By")] M_Customer m_Customer)
{
try
{
if (ModelState.IsValid)
{
m_Customer.Updated_By = await base.CurrentUserId();
ResultObject resultObj;
try
{
using (var custBll = new CustomerBLL())
{
resultObj = await custBll.UpdateCustomer(m_Customer);
_cache.Remove("CACHE_MASTER_CUSTOMER");
}
return(Json(new { success = true, data = (M_Customer)resultObj.ObjectValue, message = "Customer Update." }));
}
catch (Exception ex)
{
return(Json(new { success = false, data = m_Customer, message = ex.Message }));
}
}
var err = ModelState.Values.SelectMany(x => x.Errors).Select(x => x.ErrorMessage).ToList();
return(Json(new { success = false, errors = err, data = m_Customer, message = "Update Failed" }));
}
catch (Exception ex)
{
return(BadRequest(new { success = false, message = ex.Message }));
}
}
public string SetChildCustomerRequest(M_Customer pr)
{
try
{
string PCRequesNo = string.Empty;
using (DBLinqDataContext dbContext = new DBLinqDataContext())
{
dbContext.Connection.ConnectionString = Connection_;
dbContext.Connection.Open();
try
{
dbContext.Transaction = dbContext.Connection.BeginTransaction();
B_RecordSequence CParentId = new B_RecordSequence();
Int64 RequestNo = CParentId.getNextSequence("CustomerRequestNo", dbContext);
PCRequesNo = "CCRN" + RequestNo.ToString();
dbContext._setParentChildCustomerRequest(PCRequesNo,
pr.Customer_Name,
pr.Telephone,
pr.Email,
pr.Fax,
"P",
pr.Address1,
pr.Address2,
pr.Address3,
pr.CreatedBy,// User Session Parent User ID Here
pr.IsVat,
pr.ContactPersonName,
pr.ContactPersonDesignation,
pr.ContactPersonDirectPhone,
pr.ContactPersonMobile,
pr.ContactPersonEmail,
pr.IsNCEMember,
pr.Parent_Id, // User Session Parent Customer ID Here
pr.ProductDetails,
pr.ExportSectorId);
dbContext.SubmitChanges();
dbContext.Transaction.Commit();
return(PCRequesNo);
}
catch (Exception ex)
{
ErrorLog.LogError("B_Customer", ex);
dbContext.Transaction.Rollback();
return(null);
}
finally
{
dbContext.Connection.Close();
}
}
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public List <M_Customer> getCustomerClients(string PCID)
{
try
{
List <M_Customer> lstSD = new List <M_Customer>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <getCustomerClientListResult> lst = datacontext.getCustomerClientList(PCID);
foreach (getCustomerClientListResult result in lst)
{
M_Customer SD = new M_Customer();
SD.TemplateId = result.TemplateId;
SD.Customer_Name = result.CustomerName;
SD.ClientId = result.CustomerId;
lstSD.Add(SD);
}
}
return(lstSD);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
M_Customer ICustomerDA.AddNewCustomer(M_Customer customer)
{
DataTable dt = new DataTable();
M_Customer cust = new M_Customer();
if (connString.State == ConnectionState.Closed)
{
connString.Open();
}
cmd = new SqlCommand("uspInsertCustomer", connString);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CustomerId", customer.CustomerId);
cmd.Parameters.AddWithValue("@CustomerName", customer.CustomerName);
cmd.Parameters.AddWithValue("@Password", customer.Password);
cmd.Parameters.AddWithValue("@EmailId", customer.EmailId);
cmd.Parameters.AddWithValue("@MobileNo", customer.MobileNo);
cmd.Parameters.AddWithValue("@ProfileImage", customer.ProfileImage);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
sda.Dispose();
connString.Close();
cust = ExtensionMethods.ConvertToListOf <M_Customer>(dt).FirstOrDefault();
return(cust);
}
public async Task <ResultObject> DeleteCustomer(M_Customer cust)
{
var resultObj = new ResultObject {
RowAffected = -1, ObjectValue = cust
};
using (var context = new MasterDbContext(contextOptions))
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
MySqlParameter[] sqlParams = new MySqlParameter[] {
new MySqlParameter("strId", cust.Id),
new MySqlParameter("strDelete_By", cust.Updated_By)
};
resultObj.RowAffected = await context.Database.ExecuteSqlCommandAsync("call sp_customer_delete( ?, ?)", parameters : sqlParams);
transaction.Commit();
return(resultObj);
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
M_Customer ICustomer.CustomerLogin(M_Customer customer)
{
M_Customer obj = new M_Customer();
obj = icustomer.CustomerLogin(customer);
return(obj);
}
public JsonResult CRegister(M_Customer Model)
{
string output = "Error";
string ID = "";
try
{
Model.Parent_Id = _session.Customer_ID;
Model.CreatedBy = _session.User_Id;
if (!objUser.checkUserName(Model.Admin_UserId))
{
var cid = CustomerOBj.SetChildCustomerRequest(Model);
if (ID != null)
{
ID = cid;
output = "Sucsess";
}
}
}
catch (Exception Ex)
{
ErrorLog.LogError(Ex);
}
var result = new { Msg = output, CID = ID };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public int AddUpdateCustomer(M_Customer Customer)
{
var return_Status = new ObjectParameter("return_Status", typeof(int));
using (InventoryToolDBEntities entity = new InventoryToolDBEntities())
{
entity.UpdateCustomer(Customer.Customer_Id, Customer.Customer_Code, Customer.Customer_Name, Customer.Contact_No,
Customer.Email, Customer.Address1, Customer.Address2, Customer.City, Customer.State, Customer.PinCode,
Customer.TinNo, Customer.VatNo, Customer.Note, Customer.LastModifiedBy, return_Status);
return(Convert.ToInt32(return_Status.Value));
}
}
public bool Update_ChildCustomerDetails(M_Customer pr)
{
try
{
using (DBLinqDataContext dbContext = new DBLinqDataContext())
{
dbContext.Connection.ConnectionString = Connection_;
dbContext.Connection.Open();
try
{
dbContext.Transaction = dbContext.Connection.BeginTransaction();
dbContext._setUpdateClientsCustomer(pr.ClientId,
pr.Customer_Name,
pr.Telephone,
pr.Fax,
pr.Email,
pr.Address1,
pr.Address2,
pr.Address3,
pr.ContactPersonName,
pr.ContactPersonDesignation,
pr.ContactPersonDirectPhone,
pr.ContactPersonMobile,
pr.ContactPersonEmail,
pr.ProductDetails,
pr.IsVat,
pr.ExportSectorId);
dbContext.SubmitChanges();
dbContext.Transaction.Commit();
return(true);
}
catch (Exception ex)
{
ErrorLog.LogError("B_Customer", ex);
dbContext.Transaction.Rollback();
return(false);
}
finally
{
dbContext.Connection.Close();
}
}
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(false);
}
}
public async Task <ResultObject> UpdateCustomer(M_Customer cust)
{
var resultObj = new ResultObject {
RowAffected = -1, ObjectValue = cust
};
using (var context = new MasterDbContext(contextOptions))
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
context.Entry(cust).State = EntityState.Modified;
MySqlParameter[] sqlParams = new MySqlParameter[] {
new MySqlParameter("strId", cust.Id),
new MySqlParameter("strCustomerCode", cust.CustomerCode),
new MySqlParameter("strCustomerName", cust.CustomerName),
new MySqlParameter("strAddressL1", cust.AddressL1),
new MySqlParameter("strAddressL2", cust.AddressL2),
new MySqlParameter("strAddressL3", cust.AddressL3),
new MySqlParameter("strAddressL4", cust.AddressL4),
new MySqlParameter("strTelephone", cust.Telephone),
new MySqlParameter("strFax", cust.Fax),
new MySqlParameter("strCustomerEmail", cust.CustomerEmail),
new MySqlParameter("strCustomerContact", cust.CustomerContact),
new MySqlParameter("strCreditTerm", cust.CreditTerm),
new MySqlParameter("strPriceLevel", cust.PriceLevel),
new MySqlParameter("strCustomerTaxId", cust.CustomerTaxId),
new MySqlParameter("strRemark", cust.Remark),
new MySqlParameter("strCompanyCode", cust.CompanyCode),
new MySqlParameter("strIs_Active", cust.Is_Active),
new MySqlParameter("strUpdated_By", cust.Updated_By)
};
//Output Parameter no need to define. @`strId`
resultObj.RowAffected = await context.Database.ExecuteSqlCommandAsync("call sp_customer_update(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", parameters : sqlParams);
transaction.Commit();
return(resultObj);
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public async Task <ResultObject> InsertCustomer(M_Customer cust)
{
var resultObj = new ResultObject {
RowAffected = -1, ObjectValue = cust
};
using (var context = new MasterDbContext(contextOptions))
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
MySqlParameter[] sqlParams = new MySqlParameter[] {
new MySqlParameter("strCustomerCode", cust.CustomerCode),
new MySqlParameter("strCustomerName", cust.CustomerName),
new MySqlParameter("strAddressL1", cust.AddressL1),
new MySqlParameter("strAddressL2", cust.AddressL2),
new MySqlParameter("strAddressL3", cust.AddressL3),
new MySqlParameter("strAddressL4", cust.AddressL4),
new MySqlParameter("strTelephone", cust.Telephone),
new MySqlParameter("strFax", cust.Fax),
new MySqlParameter("strCustomerEmail", cust.CustomerEmail),
new MySqlParameter("strCustomerContact", cust.CustomerContact),
new MySqlParameter("strCreditTerm", cust.CreditTerm),
new MySqlParameter("strPriceLevel", cust.PriceLevel),
new MySqlParameter("strCustomerTaxId", cust.CustomerTaxId),
new MySqlParameter("strRemark", cust.Remark),
new MySqlParameter("strCompanyCode", cust.CompanyCode),
new MySqlParameter("strIs_Active", cust.Is_Active),
new MySqlParameter("strCreated_By", cust.Created_By)
};
resultObj.RowAffected = await context.Database.ExecuteSqlCommandAsync("call sp_customer_insert(@`strId`, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", parameters : sqlParams);
//new department after insert.
var newCust = context.Customer.FromSql("SELECT * FROM m_customer WHERE Id = @`strId`;").ToListAsync();
resultObj.ObjectValue = newCust.Result[0];
transaction.Commit();
return(resultObj);
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public JsonResult EditCClient(M_Customer Model)
{
bool result = false;
Model.Parent_Id = _session.Customer_ID;
try
{
result = CustomerOBj.Update_ChildCustomerDetails(Model);
}
catch (Exception Ex)
{
ErrorLog.LogError(Ex);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult AddUpdateCustomer(M_Customer Customer)
{
UserResultModel resultdata = new UserResultModel();
if (Customer != null)
{
Customer.LastModifiedBy = UserHelper.GetCurrentUserName();
}
try
{
int OperationStatus = CustomerProxy.Instance.AddUpdateCustomer(ConfigExtension.GetWebApiUri,
"api/Customer/AddUpdateCustomer", Customer);
if (OperationStatus == (int)operation_status.Insert)
{
resultdata.operationstatuscode = (int)operation_status.Insert;//message when inserted.
resultdata.messagedata = UserMessage.ResourceManager.GetString("msgInsert");
}
else if (OperationStatus == (int)operation_status.Update)
{
resultdata.operationstatuscode = (int)operation_status.Update;//message when Update.
resultdata.messagedata = UserMessage.ResourceManager.GetString("msgUpdate");
}
else if (OperationStatus == (int)operation_status.Duplicate_Record)
{
resultdata.operationstatuscode = (int)operation_status.Duplicate_Record;//message when duplicate record.
resultdata.messagedata = UserMessage.ResourceManager.GetString("msgDuplicate");
}
else if (OperationStatus == (int)operation_status.Update_Prevent)
{
resultdata.operationstatuscode = (int)operation_status.Duplicate_Record;//message when duplicate record.
resultdata.messagedata = UserMessage.ResourceManager.GetString("msgUpdatePrevent");
}
else
{
resultdata.operationstatuscode = (int)operation_status.Error;//message when duplicate record.
resultdata.messagedata = UserMessage.ResourceManager.GetString("msgError");
}
}
catch (Exception ex)
{
resultdata.operationstatuscode = (int)operation_status.Error;//message when duplicate record.
resultdata.messagedata = UserMessage.ResourceManager.GetString("msgError");
resultdata.message = ex.Message;
}
return(Json(resultdata, JsonRequestBehavior.AllowGet));
}
public async Task <HttpResponseMessage> CustomerLogin([FromBody] M_Customer login)
{
try
{
M_Customer customer = new OnlineShop.Model.M_Customer();
await Task.Run(() =>
{
customer = icustomer.CustomerLogin(login);
});
return(Request.CreateResponse(HttpStatusCode.OK, customer));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public M_Customer get_ChildCustomerDetails(string ClientId)
{
try
{
M_Customer req = new M_Customer();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getClientCustomerDetailsResult> lst = datacontext._getClientCustomerDetails(ClientId);
foreach (_getClientCustomerDetailsResult r in lst)
{
req.Address1 = r.Address1;
req.Address2 = r.Address2;
req.Address3 = r.Address3;
req.ContactPersonDesignation = r.ContactPersonDesignation;
req.ContactPersonDirectPhone = r.ContactPersonDirectPhoneNumber;
req.ContactPersonEmail = r.ContactPersonEmail;
req.ContactPersonMobile = r.ContactPersonMobile;
req.ContactPersonName = r.ContactPersonName;
req.CreatedDate = Convert.ToDateTime(r.CreatedDate);
req.Customer_Name = r.CustomerName; // Child Customer
req.Email = r.Email;
req.Fax = r.Fax;
req.Request_Id = r.RequestId;
req.Telephone = r.Telephone;
req.IsNCEMember = r.NCEMember;
req.IsVat = r.IsSVat;
req.ProductDetails = r.Productdetails;
req.ExportSectorId = Convert.ToInt32(r.ExportSector);
req.ExportSector = r.ExportSectorName;
req.TemplateId = r.TemplateId;
req.Parent_Id = r.ParentCustomerId;
req.ClientId = ClientId;
}
}
return(req);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public List <M_Customer> getAllParentsChildren__(string Parentid)
{
try
{
List <M_Customer> Requests = new List <M_Customer>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getParentsChildrenDetailsResult> lst = datacontext._getParentsChildrenDetails(Parentid);
foreach (_getParentsChildrenDetailsResult result in lst)
{
M_Customer req = new M_Customer();
req.Customer_Name = result.CustomerName;
req.Address1 = result.Address1 + " ," + result.Address2 + " ," + result.Address3;
req.ContactPersonDesignation = result.ContactPersonDesignation;
req.ContactPersonDirectPhone = result.ContactPersonDirectPhoneNumber;
req.ContactPersonEmail = result.ContactPersonEmail;
req.ContactPersonMobile = result.ContactPersonMobile;
req.ContactPersonName = result.ContactPersonName;
req.CreatedDate = result.CreatedDate;
req.Email = result.Email;
req.Fax = result.Fax;
req.IsNCEMember = result.NCEMember;
req.IsVat = result.IsSVat;
req.Parent_Id = result.ParentCustomerId;
req.PaidType = result.PaidType;
req.Request_Id = result.RequestId;
req.Status = result.Status;
req.Telephone = result.Telephone;
req.TemplateId = result.TemplateName;
req.ClientId = result.CustomerId;
Requests.Add(req);
}
}
return(Requests);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public int DeleteCustomer(string apiUri, string requestUri, M_Customer Customer)
{
var result = ProxyHelper.PostRequestToApi(apiUri, requestUri, Customer);
return(JsonConvert.DeserializeObject <int>(result));
}
