private async Task <bool> UpdateEntity(Database.Customer entity, CustomerUpdateRequest request)
{
if (request.AreaId != 0)
{
entity.AreaId = request.AreaId;
}
if (request.Address != null)
{
entity.Address = request.Address;
}
if (request.CompanyName != null)
{
entity.CompanyName = request.CompanyName;
}
if (request.Email != null)
{
entity.Account.Email = request.Email;
}
if (request.PhoneNumber != null)
{
entity.Account.PhoneNumber = request.PhoneNumber;
}
if (request.Username != null)
{
entity.Account.Username = request.Username;
}
await _context.SaveChangesAsync();
return(true);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
string CustomerID = hdnCustomerID.Value;
if (!string.IsNullOrEmpty(CustomerID))
{
int customerID = Convert.ToInt32(CustomerID);
if (customerID > 0)
{
var CustomerObj = context.Customers.Where(x => x.CustomerID == customerID);
if (CustomerObj.Count() > 0)
{
var customerCollection = context.Customers.Where(x => x.IsActive == true && x.CustomerName == txtCustomerName.Text && x.CustomerMobile == txtCustomerMobile.Text && x.CustomerID != customerID);
if (customerCollection.Count() == 0)
{
Database.Customer customer = CustomerObj.FirstOrDefault();
customer.ModifiedBy = currentUserName;
customer.ModifiedDate = DateTime.Now.Date;
customer.CustomerAddress = txtCustomerAddress.Text;
customer.CustomerMobile = txtCustomerMobile.Text;
customer.CustomerName = txtCustomerName.Text;
customer.CustomerEmail = txtEmail.Text;
customer.IsActive = true;
context.SaveChanges();
lblMessage.Text = "Customer Updated Successfully";
lblMessage.ForeColor = Color.Green;
}
else
{
lblMessage.Text = "Customer Already Exist Choose Diffrent Name Or Mobile";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Customer Not Found";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Customer ID Not Valid";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Customer ID Not in proper format";
lblMessage.ForeColor = Color.Red;
}
}
catch (Exception ex)
{
Helper.LogError(ex);
lblMessage.Text = "Something went Wrong kindly check log";
lblMessage.ForeColor = Color.Red;
}
}
public string CreateCustomer(Customer customer)
{
try
{
if (customer != null)
{
var res = _DbContext.Customers.Where(x => x.Email == customer.Email).FirstOrDefault();
if (res != null)
{
return("already");
}
Database.Customer entity = new Database.Customer();
entity = AutoMapperConfig.CustomerMapper.Map <Database.Customer>(customer);
_DbContext.Customers.Add(entity);
_DbContext.SaveChanges();
return("created");
}
return("null");
}
catch (Exception ex)
{
return(ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
var customerCollection = context.Customers.Where(x => x.CustomerName == txtCustomerName.Text && x.CustomerMobile == txtCustomerMobile.Text && x.IsActive == true);
if (customerCollection.Count() == 0)
{
Database.Customer customer = new Database.Customer();
customer.CreatedBy = currentUserName;
customer.CreatedDate = DateTime.Now.Date;
customer.CustomerAddress = txtCustomerAddress.Text;
customer.CustomerMobile = txtCustomerMobile.Text;
customer.CustomerName = txtCustomerName.Text;
customer.CustomerEmail = txtEmail.Text;
customer.IsActive = true;
context.Customers.Add(customer);
context.SaveChanges();
lblMessage.Text = "Customer Added Successfully";
lblMessage.ForeColor = Color.Green;
ClearForm();
}
else
{
lblMessage.Text = "Customer Already exist with same name and Mobile";
lblMessage.ForeColor = Color.Red;
}
}
catch (Exception ex)
{
Helper.LogError(ex);
lblMessage.Text = "Something went Wrong kindly check log";
lblMessage.ForeColor = Color.Red;
}
}
public string createCustomer(CustomerVM model)
{
try
{
if (model != null)
{
Database.Customer entity = new Database.Customer();
entity.Name = model.Name;
entity.Address = model.Address;
//entity.lo = model.Locality;
entity.EmailId = model.EmailId;
entity.MobileNo = model.MobileNo;
entity.City = model.City;
entity.State = model.State;
entity.Password = model.Password;
entity.Zipcode = model.Zipcode;
_dbContext.Customers.Add(entity);
_dbContext.SaveChanges();
return("");
}
}
catch (Exception ex)
{
return(ex.Message);
}
return("");
}
// POST: api/Unicorn
public string Post(DTO obj)
{
var s = "r";
var db = new Database.Customer();
//db.Save(obj.FirstName, obj.LastName, obj.Nationality, obj.Age);
return("done");
}
public Customers getCustomer(int CustomerId)
{
Database.Customer entity = new Database.Customer();
entity = dbcontext.Customers.Find(CustomerId);
var config = new MapperConfiguration(cfg => cfg.CreateMap <Database.Customer, Customers>());
var mapper = new Mapper(config);
Customers customer = mapper.Map <Customers>(entity);
return(customer);
}
public string DeleteCustomer(int CustomerId)
{
Database.Customer entity = new Database.Customer();
entity = dbcontext.Customers.Find(CustomerId);
if (entity != null)
{
dbcontext.Customers.Remove(entity);
dbcontext.SaveChanges();
return("Successfully Deleted");
}
return("null");
}
protected void ddlBillNo_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (ddlBillNo.SelectedValue != "0")
{
string orderType = ddlOrderType.SelectedValue;
panelDetail.Visible = true;
divPersonName.Visible = true;
divmobile.Visible = true;
//For Sale Order
if (orderType == "1")
{
int saleOrderID = Convert.ToInt32(ddlBillNo.SelectedValue);
var saleOrderCollection = context.SalesOrders.Where(x => x.IsActive == true && x.SaleOrderID == saleOrderID);
if (saleOrderCollection.Count() > 0)
{
Database.SalesOrder saleOrder = saleOrderCollection.FirstOrDefault();
Database.Customer customer = context.Customers.Where(x => x.IsActive == true && x.CustomerID == saleOrder.CustomerID).SingleOrDefault();
txtMobile.Text = customer.CustomerMobile;
txtPersonOrgName.Text = customer.CustomerName;
txtRemainingAmt.Text = Convert.ToString(saleOrder.RemainingAmount);
divSeller.Visible = false;
}
}
//For Purchase Order
if (orderType == "2")
{
int purchaseOrderID = Convert.ToInt32(ddlBillNo.SelectedValue);
var purchaseOrderCollection = context.InventoryOrders.Where(x => x.IsActive == true && x.InventoryOrderID == purchaseOrderID);
if (purchaseOrderCollection.Count() > 0)
{
Database.InventoryOrder invOrder = purchaseOrderCollection.FirstOrDefault();
Database.Seller seller = context.Sellers.Where(x => x.IsActive == true && x.SellerID == invOrder.SellerID).SingleOrDefault();
txtMobile.Text = seller.SellerMobile;
txtPersonOrgName.Text = seller.SellerName;
txtRemainingAmt.Text = Convert.ToString(invOrder.BalanceAmount);
divcustomer.Visible = false;
}
}
}
}
catch (Exception ex)
{
Helper.LogError(ex);
lblMessage.Text = "Something went Wrong kindly check log";
lblMessage.ForeColor = Color.Red;
}
}
public Customer GetCustomer(int id)
{
Customer customer;
Database.Customer entity = _DbContext.Customers.Find(id);
if (entity != null)
{
customer = AutoMapperConfig.CustomerMapper.Map <Customer>(entity);
}
else
{
customer = new Customer();
}
return(customer);
}
public async Task <Model.Models.Customer> Insert(CustomerInsertRequest request)
{
if (request.Password != request.PasswordConfirm)
{
throw new UserException("Lozinke moraju biti iste");
}
var salt = AccountService.GenerateSalt();
var hash = AccountService.GenerateHash(salt, request.Password);
// Adding account for customer
Database.Account customerAccount = new Database.Account()
{
DateCreated = DateTime.Now,
Email = request.Email,
PasswordSalt = salt,
PasswordHash = hash,
PhoneNumber = request.PhoneNumber,
Username = request.Username
};
await _context.Account.AddAsync(customerAccount);
await _context.SaveChangesAsync();
// Adding customer
var result = await _context.Account
.Where(x => x.PasswordSalt == salt)
.SingleOrDefaultAsync();
var accountId = result.Id;
Database.Customer customer = new Database.Customer()
{
AccountId = accountId,
Address = request.Address,
AreaId = request.AreaId,
CompanyName = request.CompanyName
};
_context.Customer.Add(customer);
_context.SaveChanges();
return(_mapper.Map <Model.Models.Customer>(customer));
}
public void FillForm()
{
try
{
string CustomerIDObj = Request.QueryString[Constants.queryCustomerID];
if (!string.IsNullOrEmpty(CustomerIDObj))
{
int CustomerID = Convert.ToInt32(CustomerIDObj);
if (CustomerID > 0)
{
var CustomerCollection = context.Customers.Where(x => x.IsActive == true && x.CustomerID == CustomerID);
if (CustomerCollection.Count() > 0)
{
Database.Customer customer = CustomerCollection.FirstOrDefault();
txtCustomerAddress.Text = customer.CustomerAddress;
txtCustomerMobile.Text = customer.CustomerMobile;
txtCustomerName.Text = customer.CustomerName;
txtEmail.Text = customer.CustomerEmail;
hdnCustomerID.Value = Convert.ToString(customer.CustomerID);
}
else
{
lblMessage.Text = "Customer Not Found";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Customer ID Not Valid";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Customer ID Not in right format";
lblMessage.ForeColor = Color.Red;
}
}
catch
{
throw;
}
}
protected void btnPopupAddCustomer_Click(object sender, EventArgs e)
{
try
{
var customerCollection = context.Customers.Where(x => x.CustomerName == txtPopupCustomerName.Text && x.CustomerMobile == txtPopupCustomerMobile.Text && x.IsActive == true);
if (customerCollection.Count() == 0)
{
Database.Customer customer = new Database.Customer();
customer.CreatedBy = currentUserName;
customer.CreatedDate = DateTime.Now.Date;
customer.CustomerMobile = txtPopupCustomerMobile.Text;
customer.CustomerName = txtPopupCustomerName.Text;
customer.CustomerEmail = txtPopupEmail.Text;
customer.IsActive = true;
context.Customers.Add(customer);
context.SaveChanges();
txtPopupCustomerMobile.Text = "";
txtPopupCustomerName.Text = "";
txtPopupEmail.Text = "";
ClearPopup();
txtAutoCustomerName.Text = customer.CustomerName;
txtCustomerID.Text = Convert.ToString(customer.CustomerID);
divAddCustomerScript.Visible = false;
}
else
{
lblPopupCustomerResult.Text = "Customer Already exist with same name and Mobile";
lblPopupCustomerResult.ForeColor = Color.Red;
divAddCustomerScript.Visible = true;
}
}
catch (Exception ex)
{
Helper.LogError(ex);
lblPopupCustomerResult.Text = "Something went Wrong kindly check log";
lblPopupCustomerResult.ForeColor = Color.Red;
divAddCustomerScript.Visible = true;
}
}
public string Post(Database.Customer entity)
{
if (entity != null)
{
if (entity != new Database.Customer())
{
Logic.CustomerManager manager = new Logic.CustomerManager(new Database.CustomerDemoContext(config));
if (manager.AddUpdate(entity))
{
return("{\"UpdateStatus\":\"COMPLETE\"}");
}
else
{
return("{\"UpdateStatus\":\"FAIL\"}");
}
}
}
return("{\"UpdateStatus\":\"INVALID\"}");
}
private Database.Customer CustomerToDbCustomer(Customer cust)
{
if (cust == null)
return null;
Database.Customer dbCust = new Database.Customer(); // Database.Customer.CreateCustomer(cust.ID, cust.FirstName, cust.LastName);
if (cust.FirstName == null) cust.FirstName = "";
if (cust.LastName == null) cust.LastName = "";
if (cust.EmailAddress == null) cust.EmailAddress = "";
if (cust.Password == null) cust.Password = "";
if (cust.Address == null) cust.Address = "";
if (cust.Address2 == null) cust.Address2 = "";
if (cust.City == null) cust.City = "";
if (cust.State == null) cust.State = "";
if (cust.ZIPCode == null) cust.ZIPCode = "";
if (cust.FacebookAccessToken == null) cust.FacebookAccessToken = "";
if (cust.FacebookExpires == null) cust.FacebookExpires = "";
if (cust.FacebookUserID == null) cust.FacebookUserID = "";
if (cust.BillingID == null) cust.BillingID = "";
if (cust.BillingType == null) cust.BillingType = 0;
if (cust.AvatarURL == null) cust.AvatarURL = "";
dbCust.FirstName = cust.FirstName;
dbCust.LastName = cust.LastName;
dbCust.EmailAddress = cust.EmailAddress;
dbCust.Password = cust.Password;
dbCust.Address1 = cust.Address;
dbCust.Address2 = cust.Address2;
dbCust.City = cust.City;
dbCust.State = cust.State;
dbCust.ZIPCode = cust.ZIPCode;
dbCust.FacebookAccessToken = cust.FacebookAccessToken;
dbCust.FacebookExpires = cust.FacebookExpires;
dbCust.FacebookUserID = cust.FacebookUserID;
dbCust.BillingID = cust.BillingID;
dbCust.BillingType = cust.BillingType;
dbCust.AvatarURL = cust.AvatarURL;
return dbCust;
}
public string AddCustomer(Customers customer)
{
try
{
if (customer != null)
{
Database.Customer entity = new Database.Customer();
var config = new MapperConfiguration(cfg => cfg.CreateMap <Customers, Database.Customer>());
var mapper = new Mapper(config);
entity = mapper.Map <Database.Customer>(customer);
dbcontext.SaveChanges();
return("created");
}
return("null");
}
catch (Exception ex)
{
return(ex.Message);
}
}
/// <summary> </summary>
/// <param name="invoiceAdd">this is a test</param>
/// <returns></returns>
/// <remarks>
/// ///
/// </remarks>
public async Task <ICustomerView> CustomerAdd(ICustomerAdd customerAdd)
{
try
{
var result = new CustomerView();
using (var db = new InvoiceContext())
{
var customer = new Database.Customer();
if (!db.Entitys.Any(w => w.EntityId == customerAdd.EntityId))
{
return new CustomerView()
{
__CQRSSuccessful = false, __CQRSErrorMessage = "Unable to find parent for Entity", __CQRSStatusCode = 404
}
}
;
var entity = db.Entitys.First(w => w.EntityId == customerAdd.EntityId);
if (entity.Customers == null)
{
entity.Customers = new List <Database.Customer>();
}
entity.Customers.Add(customer);
customer.Active = customerAdd.Active;
if (customerAdd.Address == null)
{
customer.Address = new Address();
}
else
{
customer.Address = new Address()
{
AddresLine2 = customerAdd.Address.AddresLine2,
AddressExternalRef = customerAdd.Address.AddressExternalRef,
AddressLine1 = customerAdd.Address.AddressLine1,
AddressLine3 = customerAdd.Address.AddressLine3,
City = customerAdd.Address.City,
Country = customerAdd.Address.Country,
PostZipCode = customerAdd.Address.PostZipCode,
StateCounty = customerAdd.Address.StateCounty,
};
}
customer.CustomerExteranlRef = customerAdd.CustomerExteranlRef;
customer.EmailAddress = customerAdd.EmalAddress;
customer.IsCompany = customerAdd.IsCompany;
customer.Name = customerAdd.Name;
customer.PhoneNumber = customerAdd.PhoneNumber;
customer.TaxNo = customerAdd.TaxNo;
//UserCodeBlockStart-PreSave
//UserCodeBlockEnd-PreSave
await db.SaveChangesAsync();
result.Active = customer.Active;
result.CustomerExteranlRef = customer.CustomerExteranlRef;
result.CustomerId = customer.CustomerId;
result.EmalAddress = customer.EmailAddress;
result.EntityId = entity.EntityId;
result.IsCompany = customer.IsCompany;
result.Name = customer.Name;
result.PhoneNumber = customer.PhoneNumber;
result.TaxNo = customer.TaxNo;
//UserCodeBlockStart-PreResult
//UserCodeBlockEnd-PreResult
return(result);
}
}
catch (Exception e)
{
LogFactory.GetLogger().Log(LogLevel.Error, e);
return(new CustomerView()
{
__CQRSSuccessful = false, __CQRSErrorMessage = "Unable to create CustomerView", __CQRSStatusCode = 500
});
}
}
public void FillForm()
{
try
{
string SaleOrderIDObj = Request.QueryString[Constants.querySaleOrderID];
if (!string.IsNullOrEmpty(SaleOrderIDObj))
{
int SaleOrderID = Convert.ToInt32(SaleOrderIDObj);
if (SaleOrderID > 0)
{
var SaleCollection = context.SalesOrders.Where(x => x.IsActive == true && x.SaleOrderID == SaleOrderID);
if (SaleCollection.Count() > 0)
{
Database.SalesOrder saleOrder = SaleCollection.FirstOrDefault();
txtBalance.Text = Convert.ToString(saleOrder.RemainingAmount);
txtBillNo.Text = saleOrder.BillNo;
txtClass.Text = saleOrder.ClassName;
txtCustomerID.Text = Convert.ToString(saleOrder.CustomerID);
txtPaidAmount.Text = Convert.ToString(saleOrder.PaidAmount);
txtRemarks.Text = saleOrder.Remarks;
txtSellingDate.Text = saleOrder.SaleOrderDate == null ? "" : saleOrder.SaleOrderDate.Value.ToString(Constants.DateFormatDatePicker);
txtTotalOrderAmount.Text = Convert.ToString(saleOrder.TotalCost);
ddlCustomerType.SelectedValue = Convert.ToString(saleOrder.CustomerTypeID);
chkIsComplete.Checked = saleOrder.IsCompleted == null ? false : Convert.ToBoolean(saleOrder.IsCompleted);
chkIsMakingRequired.Checked = saleOrder.IsMakingRequired == null ? false : Convert.ToBoolean(saleOrder.IsMakingRequired);
int?customerID = saleOrder.CustomerID;
if (customerID != null)
{
var customerCollection = context.Customers.Where(x => x.CustomerID == customerID);
if (customerCollection.Count() > 0)
{
Database.Customer customer = customerCollection.FirstOrDefault();
txtAutoCustomerName.Text = customer.CustomerName;
}
}
if (saleOrder.IsMakingRequired == true)
{
var devWorkCollection = context.DevelopmentWorks.Where(x => x.IsActive == true && x.SaleOrderID == SaleOrderID);
if (devWorkCollection.Count() > 0)
{
Database.DevelopmentWork devWork = devWorkCollection.FirstOrDefault();
txtAutoMakingInventoryType.Text = Convert.ToString(devWork.InventoryTypeID);
txtBottomMeasurement.Text = devWork.BottomMeasurement;
txtConfirmDate.Text = devWork.ConfirmDate == null ? "" : devWork.ConfirmDate.Value.ToString(Constants.DateFormatDatePicker);
txtDeliveryDate.Text = devWork.DeliveryDate == null ? "" : devWork.DeliveryDate.Value.ToString(Constants.DateFormatDatePicker);
txtMakingCost.Text = Convert.ToString(devWork.MakingCost);
txtMakingInventoryType.Text = Convert.ToString(devWork.InventoryTypeID);
txtTopMeasurement.Text = devWork.TopMeasurement;
ddlWorkType.SelectedValue = Convert.ToString(devWork.WorkTypeID);
int?invTypeID = devWork.InventoryTypeID;
if (invTypeID != null)
{
var invCollection = context.InventoryTypes.Where(x => x.InventoryTypeId == invTypeID);
if (invCollection.Count() > 0)
{
Database.InventoryType inventory = invCollection.FirstOrDefault();
txtAutoMakingInventoryType.Text = inventory.InventoryTypeName;
}
}
}
else
{
//Nothing to Do
}
}
var saleDetailCollection = context.SaleOrderDetails.Where(x => x.IsActive == true && x.SaleOrderID == SaleOrderID).AsEnumerable();
var data = from saleDetail in saleDetailCollection
join inv in context.InventoryTypes.Where(x => x.IsActive == true).AsEnumerable() on saleDetail.InventoryTypeID equals inv.InventoryTypeId
select new rptrClass
{
ItemCode = inv.InventoryCode,
ItemID = inv.InventoryTypeId.ToString(),
ItemName = inv.InventoryTypeName,
Quantity = saleDetail.Quantity.ToString(),
SellingRate = saleDetail.SellingRate.ToString(),
TotalAmount = saleDetail.TotalAmount.ToString(),
VAT = saleDetail.VAT,
SaleOrderDetailID = saleDetail.SaleOrderDetailID
};
rptrData.DataSource = data.ToList();
rptrData.DataBind();
hdnSaleOrderID.Value = Convert.ToString(SaleOrderID);
}
else
{
lblMessage.Text = "Customer Not Found";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Customer ID Not Valid";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Customer ID Not in right format";
lblMessage.ForeColor = Color.Red;
}
}
catch
{
throw;
}
}
