protected void btnPopupAddInventory_Click(object sender, EventArgs e)
{
try
{
string invName = txtPopupInventoryTypeName.Text;
string invCode = txtPopupInventoryCode.Text;
var invType = context.InventoryTypes.Where(x => x.InventoryCode == invCode || x.InventoryTypeName == invName);
if (invType.Count() == 0)
{
Database.InventoryType Inventory = new Database.InventoryType();
Inventory.CreatedBy = currentUserName;
Inventory.CreatedDate = DateTime.Now.Date;
Inventory.FastMoving = chkPopupFastMoving.Checked;
Inventory.InventoryCode = txtPopupInventoryCode.Text;
Inventory.InventoryDescription = txtPopupInvDesc.Text;
Inventory.InventoryTypeName = txtPopupInventoryTypeName.Text;
Inventory.IsActive = true;
Inventory.LowStockCount = Convert.ToInt32(txtPopupLowCount.Text);
Inventory.PurchaseRate = Convert.ToDecimal(txtPopupPurchaseRate.Text);
Inventory.RagNo = txtPopupRagNo.Text;
Inventory.SellingRate = Convert.ToDecimal(txtPopupSellingRate.Text);
Inventory.UnitName = txtPopupUnit.Text;
Inventory.VAT = txtPopupVat.Text;
context.InventoryTypes.Add(Inventory);
context.SaveChanges();
ClearPopup();
txtItemCode.Text = Inventory.InventoryCode;
txtAutoItemCode.Text = Inventory.InventoryCode;
txtItemName.Text = Inventory.InventoryTypeName;
txtSellingRate.Text = Convert.ToString(Inventory.SellingRate);
txtVAT.Text = Inventory.VAT;
hdnItemID.Value = Convert.ToString(Inventory.InventoryTypeId);
divAddInventoryScript.Visible = false;
}
else
{
lblPopupInvResult.Text = "Inventory Name or code already exist kindly choose another one";
lblPopupInvResult.ForeColor = Color.Red;
divAddInventoryScript.Visible = true;
}
}
catch (Exception ex)
{
Helper.LogError(ex);
lblPopupInvResult.Text = "Something went Wrong kindly check log";
lblPopupInvResult.ForeColor = Color.Red;
divAddInventoryScript.Visible = true;
}
}
public void FillForm()
{
try
{
string InventoryIDObj = Request.QueryString[Constants.queryInventoryID];
if (!string.IsNullOrEmpty(InventoryIDObj))
{
int InventoryTypeID = Convert.ToInt32(InventoryIDObj);
if (InventoryTypeID > 0)
{
var InventoryCollection = context.InventoryTypes.Where(x => x.IsActive == true && x.InventoryTypeId == InventoryTypeID);
if (InventoryCollection.Count() > 0)
{
Database.InventoryType inventoryType = InventoryCollection.FirstOrDefault();
txtInvDesc.Text = inventoryType.InventoryDescription;
txtInventoryCode.Text = inventoryType.InventoryCode;
txtInventoryTypeName.Text = inventoryType.InventoryTypeName;
txtLowCount.Text = Convert.ToString(inventoryType.LowStockCount);
txtPurchaseRate.Text = Convert.ToString(inventoryType.PurchaseRate);
txtRagNo.Text = inventoryType.RagNo;
txtSellingRate.Text = Convert.ToString(inventoryType.SellingRate);
txtUnit.Text = inventoryType.UnitName;
txtVAT.Text = inventoryType.VAT;
chkFastMoving.Checked = Convert.ToBoolean(inventoryType.FastMoving);
hdnInventoryID.Value = Convert.ToString(InventoryTypeID);
}
else
{
lblMessage.Text = "Inventory Not Found";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Inventory ID Not Valid";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Inventory ID Not in right format";
lblMessage.ForeColor = Color.Red;
}
}
catch
{
throw;
}
}
protected void btnAddInventory_Click(object sender, EventArgs e)
{
try
{
string invName = txtInventoryTypeName.Text;
string invCode = txtInventoryCode.Text;
var invType = context.InventoryTypes.Where(x => x.InventoryCode == invCode || x.InventoryTypeName == invName);
if (invType.Count() == 0)
{
Database.InventoryType Inventory = new Database.InventoryType();
Inventory.CreatedBy = currentUserName;
Inventory.CreatedDate = DateTime.Now.Date;
Inventory.FastMoving = chkFastMoving.Checked;
Inventory.InventoryCode = txtInventoryCode.Text;
Inventory.InventoryDescription = txtInvDesc.Text;
Inventory.InventoryTypeName = txtInventoryTypeName.Text;
Inventory.IsActive = true;
Inventory.LowStockCount = string.IsNullOrEmpty(txtLowCount.Text) ? 0 : Convert.ToInt32(txtLowCount.Text);
Inventory.PurchaseRate = string.IsNullOrEmpty(txtPurchaseRate.Text) ? 0 : Convert.ToDecimal(txtPurchaseRate.Text);
Inventory.RagNo = txtRagNo.Text;
Inventory.SellingRate = string.IsNullOrEmpty(txtSellingRate.Text) ? 0 : Convert.ToDecimal(txtSellingRate.Text);
Inventory.UnitName = txtUnit.Text;
Inventory.VAT = txtVAT.Text;
context.InventoryTypes.Add(Inventory);
context.SaveChanges();
lblMessage.Text = "Inventory Added Successfully";
lblMessage.ForeColor = Color.Green;
ClearForm();
}
else
{
lblMessage.Text = "Inventory Name or code already exist kindly choose another one";
lblMessage.ForeColor = Color.Red;
}
}
catch (Exception ex)
{
Helper.LogError(ex);
lblMessage.Text = "Something went Wrong kindly check log";
lblMessage.ForeColor = Color.Red;
}
}
public void UpdateAssignWork()
{
try
{
string workAssignIDObj = hdnAssignWorkID.Value;
if (!string.IsNullOrEmpty(workAssignIDObj))
{
int workAssignID = Convert.ToInt32(workAssignIDObj);
var workCollection = context.WorkAssigns.Where(x => x.IsActive == true && x.WorkAssignID == workAssignID);
if (workCollection.Count() > 0)
{
using (TransactionScope scope = new TransactionScope())
{
Database.WorkAssign workAssign = workCollection.FirstOrDefault();
workAssign.BillNo = ddlBillNo.SelectedItem.Text;
workAssign.CompletedCount = txtCompletedCount.Text == "" ? 0 : Convert.ToInt32(txtCompletedCount.Text);
workAssign.ModifiedBy = currentUserName;
workAssign.ModifiedDate = DateTime.Now;
workAssign.EmployeeID = Convert.ToInt32(ddlEmployeeName.SelectedValue);
if (!string.IsNullOrEmpty(txtExpectedDeliveryDate.Text))
{
workAssign.ExpectedCompletionDate = Convert.ToDateTime(txtExpectedDeliveryDate.Text);
}
else
{
workAssign.ExpectedCompletionDate = null;
}
workAssign.IsComplete = chkIsWorkCompleted.Checked;
workAssign.Remarks = txtRemarks.Text;
if (!string.IsNullOrEmpty(txtWorkAssignDate.Text))
{
workAssign.WorkAssignDate = Convert.ToDateTime(txtWorkAssignDate.Text);
}
else
{
workAssign.WorkAssignDate = null;
}
workAssign.WorkCount = txtItemCount.Text == "" ? 0 : Convert.ToInt32(txtItemCount.Text);
workAssign.WorkTypeID = Convert.ToInt32(ddlWorkType.SelectedValue);
workAssign.IsActive = true;
workAssign.TotalCost = txtTotalCost.Text == "" ? 0 : Convert.ToDecimal(txtTotalCost.Text);
var totalAmt = txtTotalCost.Text == "" ? 0 : Convert.ToDecimal(txtTotalCost.Text);
var paidAmt = txtAmountPaid.Text == "" ? 0 : Convert.ToDecimal(txtAmountPaid.Text);
var remAmount = totalAmt - paidAmt;
workAssign.RemainingCost = remAmount;
context.SaveChanges();
if (rptrData.Items.Count > 0)
{
foreach (RepeaterItem rptrItem in rptrData.Items)
{
if (rptrItem.Visible)
{
int workAssignInventoryUsedID = Convert.ToInt32(((HiddenField)rptrItem.FindControl("hdnWorkassignUsedID")).Value);
var invUsedObj = context.WorkAssignInventoryUseds.Where(x => x.IsActive == true && x.WorkAssignInventoryUsedID == workAssignInventoryUsedID);
if (invUsedObj.Count() > 0)
{
WorkAssignInventoryUsed workAssUID = invUsedObj.SingleOrDefault();
int?oldCount = workAssUID.InventoryUsedCount;
workAssUID.InventoryTypeID = Convert.ToInt32(((HiddenField)rptrItem.FindControl("hdnItemID")).Value);
workAssUID.InventoryUsedCount = Convert.ToInt32(((Label)rptrItem.FindControl("lblQuantity")).Text);
workAssUID.ModifiedBy = currentUserName;
workAssUID.ModifiedDate = DateTime.Now.Date;
workAssUID.IsActive = true;
workAssUID.WorkAssignID = workAssign.WorkAssignID;
context.SaveChanges();
Database.InventoryType currentInventory = context.InventoryTypes.Where(x => x.IsActive == true && x.InventoryTypeId == workAssUID.InventoryTypeID).SingleOrDefault();
if (currentInventory != null)
{
var currentQuantity = currentInventory.InventoryCount == null ? 0 : currentInventory.InventoryCount;
currentInventory.InventoryCount = currentQuantity + (oldCount - workAssUID.InventoryUsedCount);
context.SaveChanges();
}
}
}
else
{
int workAssignInventoryUsedID = Convert.ToInt32(((HiddenField)rptrItem.FindControl("hdnWorkassignUsedID")).Value);
var invUsedObj = context.WorkAssignInventoryUseds.Where(x => x.IsActive == true && x.WorkAssignInventoryUsedID == workAssignInventoryUsedID);
if (invUsedObj.Count() > 0)
{
WorkAssignInventoryUsed workAssUID = invUsedObj.SingleOrDefault();
workAssUID.ModifiedBy = currentUserName;
workAssUID.ModifiedDate = DateTime.Now.Date;
workAssUID.IsActive = false;
context.SaveChanges();
Database.InventoryType currentInventory = context.InventoryTypes.Where(x => x.IsActive == true && x.InventoryTypeId == workAssUID.InventoryTypeID).SingleOrDefault();
if (currentInventory != null)
{
var currentQuantity = currentInventory.InventoryCount == null ? 0 : currentInventory.InventoryCount;
currentInventory.InventoryCount = currentQuantity + workAssUID.InventoryUsedCount;
context.SaveChanges();
}
}
}
}
}
var salCollection = context.Salaries.Where(x => x.IsActive == true && x.WorkAssignID == workAssign.WorkAssignID);
if (salCollection.Count() > 0)
{
Salary EmpSalary = salCollection.FirstOrDefault();
EmpSalary.AmountPaid = txtAmountPaid.Text == "" ? 0 : Convert.ToDecimal(txtAmountPaid.Text);
EmpSalary.AmountPaidDate = txtPaidDate.Text == "" ? DateTime.Now.Date : Convert.ToDateTime(txtPaidDate.Text);
EmpSalary.ModifiedBy = currentUserName;
EmpSalary.ModifiedDate = DateTime.Now;
EmpSalary.EmployeeID = Convert.ToInt32(ddlEmployeeName.SelectedValue);
EmpSalary.Remarks = txtRemarks.Text;
EmpSalary.WorkAssignID = workAssign.WorkAssignID;
EmpSalary.IsActive = true;
context.SaveChanges();
}
lblMessage.Text = "Assign Successfully";
lblMessage.ForeColor = Color.Green;
scope.Complete();
}
}
else
{
lblMessage.Text = "Work Assign ID Not Found ";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Work Assign ID Not in proper format ";
lblMessage.ForeColor = Color.Red;
}
}
catch
{
throw;
}
}
public void AssignWork()
{
try
{
if (ddlEmployeeName.SelectedValue != "0" && ddlBillNo.SelectedValue != "0" && ddlWorkType.SelectedValue != "0")
{
int empId = Convert.ToInt32(ddlEmployeeName.SelectedValue);
var BillNo = ddlBillNo.SelectedValue;
var workTypeID = Convert.ToInt32(ddlWorkType.SelectedValue);
//To Check same bill no and same work is not assign to emplyee
var workCollection = context.WorkAssigns.Where(x => x.EmployeeID == empId && x.BillNo == BillNo && x.WorkTypeID == workTypeID);
if (workCollection.Count() == 0)
{
using (TransactionScope scope = new TransactionScope())
{
WorkAssign workAssign = new WorkAssign();
workAssign.BillNo = ddlBillNo.SelectedItem.Text;
workAssign.CompletedCount = txtCompletedCount.Text == "" ? 0 : Convert.ToInt32(txtCompletedCount.Text);
workAssign.CreatedBy = currentUserName;
workAssign.CreatedDate = DateTime.Now;
workAssign.EmployeeID = ddlEmployeeName.SelectedValue == "0" ? 0 : Convert.ToInt32(ddlEmployeeName.SelectedValue);
if (!string.IsNullOrEmpty(txtExpectedDeliveryDate.Text))
{
workAssign.ExpectedCompletionDate = Convert.ToDateTime(txtExpectedDeliveryDate.Text);
}
workAssign.IsComplete = chkIsWorkCompleted.Checked;
workAssign.Remarks = txtRemarks.Text;
if (!string.IsNullOrEmpty(txtWorkAssignDate.Text))
{
workAssign.WorkAssignDate = Convert.ToDateTime(txtWorkAssignDate.Text);
}
workAssign.WorkCount = txtItemCount.Text == "" ? 0 : Convert.ToInt32(txtItemCount.Text);
workAssign.WorkTypeID = ddlWorkType.SelectedValue == "0" ? 0 : Convert.ToInt32(ddlWorkType.SelectedValue);
workAssign.IsActive = true;
workAssign.TotalCost = txtTotalCost.Text == "" ? 0 : Convert.ToInt32(txtTotalCost.Text);
var totalAmt = txtTotalCost.Text == "" ? 0 : Convert.ToInt32(txtTotalCost.Text);
var paidAmt = txtAmountPaid.Text == "" ? 0 : Convert.ToInt32(txtAmountPaid.Text);
var remAmount = totalAmt - paidAmt;
workAssign.RemainingCost = remAmount;
context.WorkAssigns.Add(workAssign);
context.SaveChanges();
Salary EmpSalary = new Salary();
EmpSalary.AmountPaid = paidAmt;
EmpSalary.AmountPaidDate = txtPaidDate.Text == "" ? DateTime.Now.Date : Convert.ToDateTime(txtPaidDate.Text);
EmpSalary.CreatedBy = currentUserName;
EmpSalary.CreatedDate = DateTime.Now;
EmpSalary.EmployeeID = ddlEmployeeName.SelectedValue == "0" ? 0 : Convert.ToInt32(ddlEmployeeName.SelectedValue);
EmpSalary.Remarks = txtRemarks.Text;
EmpSalary.WorkAssignID = workAssign.WorkAssignID;
EmpSalary.IsActive = true;
context.Salaries.Add(EmpSalary);
context.SaveChanges();
if (rptrData.Items.Count > 0)
{
foreach (RepeaterItem rptrItem in rptrData.Items)
{
if (rptrItem.Visible)
{
WorkAssignInventoryUsed workAssUID = new WorkAssignInventoryUsed();
workAssUID.InventoryTypeID = Convert.ToInt32(((HiddenField)rptrItem.FindControl("hdnItemID")).Value);
workAssUID.InventoryUsedCount = Convert.ToInt32(((Label)rptrItem.FindControl("lblQuantity")).Text);
workAssUID.WorkAssignID = workAssign.WorkAssignID;
workAssUID.CreatedBy = currentUserName;
workAssUID.CreatedDate = DateTime.Now.Date;
workAssUID.IsActive = true;
context.WorkAssignInventoryUseds.Add(workAssUID);
context.SaveChanges();
Database.InventoryType currentInventory = context.InventoryTypes.Where(x => x.InventoryTypeId == workAssUID.InventoryTypeID).SingleOrDefault();
if (currentInventory != null)
{
var currentQuantity = currentInventory.InventoryCount == null ? 0 : currentInventory.InventoryCount;
currentInventory.InventoryCount = currentQuantity - workAssUID.InventoryUsedCount;
currentInventory.ModifiedBy = currentUserName;
currentInventory.ModifiedDate = DateTime.Now.Date;
context.SaveChanges();
}
}
}
}
lblMessage.Text = "Assign Successfully";
lblMessage.ForeColor = Color.Green;
ClearForm();
scope.Complete();
}
}
else
{
lblMessage.Text = "Work is already assign to Employee";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Form is not properly filled";
lblMessage.ForeColor = Color.Red;
}
}
catch
{
throw;
}
}
public void UpdateSaleOrder()
{
try
{
if (rptrData.Items.Count != 0 || chkIsMakingRequired.Checked)
{
string saleOrderIDObj = hdnSaleOrderID.Value;
if (!string.IsNullOrEmpty(saleOrderIDObj))
{
int saleID = Convert.ToInt32(saleOrderIDObj);
var saleCollection = context.SalesOrders.Where(x => x.IsActive == true && x.SaleOrderID == saleID);
if (saleCollection.Count() > 0)
{
using (TransactionScope scope = new TransactionScope())
{
Database.SalesOrder saleOrder = saleCollection.FirstOrDefault();
saleOrder.BillNo = txtBillNo.Text;
saleOrder.ClassName = txtClass.Text;
saleOrder.ModifiedBy = currentUserName;
saleOrder.ModifiedDate = DateTime.Now;
saleOrder.CustomerID = Convert.ToInt32(txtCustomerID.Text);
saleOrder.CustomerTypeID = Convert.ToInt32(ddlCustomerType.SelectedValue);
saleOrder.IsActive = true;
saleOrder.IsCompleted = chkIsComplete.Checked;
saleOrder.IsMakingRequired = chkIsMakingRequired.Checked;
saleOrder.PaidAmount = txtPaidAmount.Text == "" ? 0 : Convert.ToDecimal(txtPaidAmount.Text);
//Profit is set at the end of all items
//saleOrder.Profit=
saleOrder.Remarks = txtRemarks.Text;
saleOrder.SaleOrderDate = Convert.ToDateTime(txtSellingDate.Text);
saleOrder.TotalCost = txtTotalOrderAmount.Text == "" ? 0 : Convert.ToDecimal(txtTotalOrderAmount.Text);
//Below due to total cost above set
saleOrder.RemainingAmount = saleOrder.TotalCost - saleOrder.PaidAmount;
context.SaveChanges();
if (chkIsMakingRequired.Checked)
{
string devWorkIDObj = hdnDevWorkID.Value;
if (!string.IsNullOrEmpty(devWorkIDObj))
{
int devWorkID = Convert.ToInt32(devWorkIDObj);
var devWorkCollection = context.DevelopmentWorks.Where(x => x.IsActive == true && x.DevelopmentWorkID == devWorkID);
if (devWorkCollection.Count() > 0)
{
//Developement work detail
DevelopmentWork dwork = devWorkCollection.FirstOrDefault();
dwork.BillNo = saleOrder.BillNo;
dwork.BottomMeasurement = txtBottomMeasurement.Text;
if (txtConfirmDate.Text != "")
{
dwork.ConfirmDate = Convert.ToDateTime(txtConfirmDate.Text);
}
dwork.ModifiedBy = currentUserName;
dwork.ModifiedDate = DateTime.Now.Date;
if (txtDeliveryDate.Text != "")
{
dwork.DeliveryDate = Convert.ToDateTime(txtDeliveryDate.Text);
}
if (fileuploadDesign.FileName != "")
{
string fileNamePath = ConfigurationManager.AppSettings[Constants.ConfigDesignPhotoPath] + "\\" + fileuploadDesign.FileName;
fileuploadDesign.SaveAs(fileNamePath);
dwork.DesignPhotoUrl = ConfigurationManager.AppSettings[Constants.ConfigDesignPhotoURL] + "\\" + fileuploadDesign.FileName;
}
dwork.InventoryTypeID = Convert.ToInt32(txtMakingInventoryType.Text);
dwork.IsActive = true;
dwork.MakingCost = txtMakingCost.Text == "" ? 0 : Convert.ToDecimal(txtMakingCost.Text);
dwork.SaleOrderID = saleOrder.SaleOrderID;
dwork.TopMeasurement = txtTopMeasurement.Text;
dwork.WorkTypeID = Convert.ToInt32(ddlWorkType.SelectedValue);
context.SaveChanges();
}
}
}
decimal?profit = 0;
List <rptrClass> printLst = new List <rptrClass>();
if (rptrData.Items.Count > 0)
{
foreach (RepeaterItem rptrItem in rptrData.Items)
{
if (rptrItem.Visible)
{
int saleOrderDetailID = Convert.ToInt32(((HiddenField)rptrItem.FindControl("hdnSaleOrderDetailID")).Value);
var saleOrderDetailCollection = context.SaleOrderDetails.Where(x => x.IsActive == true && x.SaleOrderDetailID == saleOrderDetailID);
if (saleOrderDetailCollection.Count() > 0)
{
Database.SaleOrderDetail saleOrderDetail = saleOrderDetailCollection.FirstOrDefault();
var oldQuantity = saleOrderDetail.Quantity;
saleOrderDetail.ModifiedBy = currentUserName;
saleOrderDetail.ModifiedDate = DateTime.Now;
saleOrderDetail.InventoryTypeID = Convert.ToInt32(((HiddenField)rptrItem.FindControl("hdnItemID")).Value);
saleOrderDetail.IsActive = true;
saleOrderDetail.Quantity = Convert.ToInt32(((Label)rptrItem.FindControl("lblQuantity")).Text);
saleOrderDetail.SaleOrderID = saleOrder.SaleOrderID;
saleOrderDetail.SellingRate = Convert.ToDecimal(((Label)rptrItem.FindControl("lblSellingRate")).Text);
saleOrderDetail.TotalAmount = Convert.ToDecimal(((Label)rptrItem.FindControl("lblTotalAmount")).Text);
saleOrderDetail.VAT = ((Label)rptrItem.FindControl("lblVat")).Text;
context.SaveChanges();
Database.InventoryType currentInventory = context.InventoryTypes.Where(x => x.IsActive == true && x.InventoryTypeId == saleOrderDetail.InventoryTypeID).SingleOrDefault();
if (currentInventory != null)
{
var invCount = currentInventory.InventoryCount == null ? 0 : currentInventory.InventoryCount;
currentInventory.InventoryCount = invCount + (oldQuantity - saleOrderDetail.Quantity);
context.SaveChanges();
decimal?pRate = currentInventory.PurchaseRate == null ? 0 : currentInventory.PurchaseRate;
decimal?sRate = saleOrderDetail.SellingRate == null ? 0 : saleOrderDetail.SellingRate;
profit = profit + (sRate - pRate);
}
rptrClass obj = new rptrClass();
obj.ItemName = ((Label)rptrItem.FindControl("lblItemName")).Text;
obj.Quantity = Convert.ToString(saleOrderDetail.Quantity);
obj.SellingRate = Convert.ToString(saleOrderDetail.SellingRate);
obj.TotalAmount = Convert.ToString(saleOrderDetail.TotalAmount);
obj.VAT = saleOrderDetail.VAT;
printLst.Add(obj);
}
}
else
{
int saleOrderDetailID = Convert.ToInt32(((HiddenField)rptrItem.FindControl("hdnSaleOrderDetailID")).Value);
var saleOrderCollection = context.SaleOrderDetails.Where(x => x.IsActive == true && x.SaleOrderDetailID == saleOrderDetailID);
if (saleOrderCollection.Count() > 0)
{
Database.SaleOrderDetail saleOrderDetail = saleOrderCollection.FirstOrDefault();
var oldQuantity = saleOrderDetail.Quantity;
saleOrderDetail.ModifiedBy = currentUserName;
saleOrderDetail.ModifiedDate = DateTime.Now;
saleOrderDetail.IsActive = false;
context.SaveChanges();
Database.InventoryType currentInventory = context.InventoryTypes.Where(x => x.IsActive == true && x.InventoryTypeId == saleOrderDetail.InventoryTypeID).SingleOrDefault();
if (currentInventory != null)
{
var invCount = currentInventory.InventoryCount == null ? 0 : currentInventory.InventoryCount;
currentInventory.InventoryCount = invCount + oldQuantity;
context.SaveChanges();
}
}
}
}
}
saleOrder.Profit = profit;
context.SaveChanges();
lblMessage.Text = "Record updated sucessfully of BILL NO " + saleOrder.BillNo;
lblMessage.ForeColor = Color.Green;
CreatePrintDiv(saleOrder.BillNo, txtAutoCustomerName.Text, saleOrder.TotalCost, printLst);
txtSellingDate.Text = DateTime.Now.ToString(Constants.DateFormatDatePicker);
scope.Complete();
}
}
else
{
lblMessage.Text = "Sale Order ID Not Found ";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Sale Order ID Not in proper format ";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Sale Order is not proper ";
lblMessage.ForeColor = Color.Red;
}
}
catch
{
throw;
}
}
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;
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
string InventoryIDObj = hdnInventoryID.Value;
if (!string.IsNullOrEmpty(InventoryIDObj))
{
int InventoryID = Convert.ToInt32(InventoryIDObj);
if (InventoryID > 0)
{
var inventoryObj = context.InventoryTypes.Where(x => x.IsActive == true && x.InventoryTypeId == InventoryID);
if (inventoryObj.Count() > 0)
{
var InventoryCollection = context.InventoryTypes.Where(x => x.IsActive == true && (x.InventoryCode == txtInventoryCode.Text || x.InventoryTypeName == txtInventoryTypeName.Text) && x.InventoryTypeId != InventoryID);
if (InventoryCollection.Count() == 0)
{
Database.InventoryType inventory = inventoryObj.FirstOrDefault();
inventory.FastMoving = chkFastMoving.Checked;
inventory.InventoryCode = txtInventoryCode.Text;
inventory.InventoryDescription = txtInvDesc.Text;
inventory.InventoryTypeName = txtInventoryTypeName.Text;
inventory.IsActive = true;
inventory.ModifiedBy = currentUserName;
inventory.ModifiedDate = DateTime.Now.Date;
inventory.LowStockCount = string.IsNullOrEmpty(txtLowCount.Text) ? 0 : Convert.ToInt32(txtLowCount.Text);
inventory.PurchaseRate = string.IsNullOrEmpty(txtPurchaseRate.Text) ? 0 : Convert.ToDecimal(txtPurchaseRate.Text);
inventory.RagNo = txtRagNo.Text;
inventory.SellingRate = string.IsNullOrEmpty(txtSellingRate.Text) ? 0 : Convert.ToDecimal(txtSellingRate.Text);
inventory.UnitName = txtUnit.Text;
inventory.VAT = txtVAT.Text;
context.SaveChanges();
lblMessage.Text = "Inventory Updated Successfully";
lblMessage.ForeColor = Color.Green;
}
else
{
lblMessage.Text = "Inventory Name or Code already Exist kindly choose other";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Inventory ID Not Found";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Inventory ID Not Valid";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "Inventory ID Not in Valid Format";
lblMessage.ForeColor = Color.Red;
}
}
catch (Exception ex)
{
Helper.LogError(ex);
lblMessage.Text = "Something went Wrong kindly check log";
lblMessage.ForeColor = Color.Red;
}
}
