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;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (ddlOrderType.SelectedValue != "0" && ddlBillNo.SelectedValue != "0")
{
if (ddlOrderType.SelectedValue == "1")
{
int saleOrderID = Convert.ToInt32(ddlBillNo.SelectedValue);
Database.SalesOrder saleOrder = context.SalesOrders.Where(x => x.SaleOrderID == saleOrderID).SingleOrDefault();
if (saleOrder.BillNo == ddlBillNo.SelectedItem.Text)
{
saleOrder.ModifiedBy = currentUserName;
saleOrder.ModifiedDate = DateTime.Now.Date;
int amountPaid = txtCustomerPay.Text == "" ? 0 : Convert.ToInt32(txtCustomerPay.Text);
saleOrder.PaidAmount = (saleOrder.PaidAmount == null ? 0 : saleOrder.PaidAmount) + amountPaid;
decimal?totalCost = saleOrder.TotalCost == null ? 0 : saleOrder.TotalCost;
saleOrder.RemainingAmount = totalCost - saleOrder.PaidAmount;
context.SaveChanges();
lblMessage.Text = "Payment Updated For Sale Order for " + saleOrder.BillNo;
lblMessage.ForeColor = Color.Green;
CreatePrintDiv(saleOrder.BillNo, txtPayeeName.Text, amountPaid);
}
else
{
lblMessage.Text = "Not Found Bill No " + saleOrder.BillNo;
lblMessage.ForeColor = Color.Red;
}
}
if (ddlOrderType.SelectedValue == "2")
{
int purchaseOrderID = Convert.ToInt32(ddlBillNo.SelectedValue);
Database.InventoryOrder purchaseOrder = context.InventoryOrders.Where(x => x.IsActive == true && x.InventoryOrderID == purchaseOrderID).SingleOrDefault();
if (purchaseOrder.PurchaseBillNo == ddlBillNo.SelectedItem.Text)
{
purchaseOrder.ModifiedBy = currentUserName;
purchaseOrder.ModifiedDate = DateTime.Now.Date;
int amountPaid = txtPayToSeller.Text == "" ? 0 : Convert.ToInt32(txtPayToSeller.Text);
purchaseOrder.AmountPaid = (purchaseOrder.AmountPaid == null ? 0 : purchaseOrder.AmountPaid) + amountPaid;
decimal?totalCost = purchaseOrder.TotalOrderAmount == null ? 0 : purchaseOrder.TotalOrderAmount;
purchaseOrder.BalanceAmount = totalCost - purchaseOrder.AmountPaid;
purchaseOrder.AmountPaidDate = DateTime.Now.Date;
context.SaveChanges();
lblMessage.Text = "Payment Updated For Sale Order for " + purchaseOrder.PurchaseBillNo;
lblMessage.ForeColor = Color.Green;
CreatePrintDiv(purchaseOrder.PurchaseBillNo, txtPayeeName.Text, amountPaid);
}
else
{
lblMessage.Text = "Not Found Bill No " + purchaseOrder.PurchaseBillNo;
lblMessage.ForeColor = Color.Red;
}
}
}
}
catch (Exception ex)
{
Helper.LogError(ex);
lblMessage.Text = "Something went Wrong kindly check log";
lblMessage.ForeColor = Color.Red;
}
}
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;
}
}
