protected void btnAddRecord_Click(object sender, EventArgs e)
{
try
{
List <rptrClass> data = new List <rptrClass>();
rptrClass obj = new rptrClass();
obj.ItemID = Convert.ToInt32(hdnItemID.Value);
obj.ItemName = txtItemName.Text;
obj.ItemCode = txtItemCode.Text;
obj.PurchaseRate = Convert.ToDecimal(txtPurchasRate.Text);
obj.Quantity = Convert.ToInt32(txtQuantity.Text);
obj.SellingRate = Convert.ToDecimal(txtSellingRate.Text);
obj.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
obj.VAT = txtVAT.Text;
data.Add(obj);
if (rptrData.Items.Count > 0)
{
data = BindRepeater(data);
}
rptrData.DataSource = data;
rptrData.DataBind();
ClearRepeater();
lblMessage.Text = "";
}
catch (Exception ex)
{
Helper.LogError(ex);
lblMessage.Text = "Something went Wrong kindly check log";
lblMessage.ForeColor = Color.Red;
}
}
public List <rptrClass> BindRepeater(List <rptrClass> data = null)
{
try
{
if (data == null)
{
data = new List <rptrClass>();
}
int editItemIndex = hdnItemIndex.Value == "" ? -1 : Convert.ToInt32(hdnItemIndex.Value);
foreach (RepeaterItem item in rptrData.Items)
{
//for deleting of repeater row
if (item.Visible)
{
//To check edit button press so not add record
if (item.ItemIndex != editItemIndex)
{
rptrClass objNext = new rptrClass();
objNext.ItemID = ((HiddenField)item.FindControl("hdnItemID")).Value;
objNext.ItemName = ((Label)item.FindControl("lblItemName")).Text;
objNext.Quantity = ((Label)item.FindControl("lblQuantity")).Text;
objNext.WorkAssignInventoryUsedID = ((HiddenField)item.FindControl("hdnWorkassignUsedID")).Value;
data.Add(objNext);
}
}
}
hdnItemIndex.Value = "-1";
return(data);
}
catch
{
throw;
}
}
protected void btnAddRecord_Click(object sender, EventArgs e)
{
try
{
List <rptrClass> data = new List <rptrClass>();
rptrClass obj = new rptrClass();
obj.ItemID = ddlInventoryType.SelectedValue;
obj.ItemName = ddlInventoryType.SelectedItem.Text;
obj.Quantity = txtQuantity.Text;
data.Add(obj);
if (rptrData.Items.Count > 0)
{
data = BindRepeater(data);
}
rptrData.DataSource = data;
rptrData.DataBind();
ClearRepeater();
}
catch (Exception ex)
{
Helper.LogError(ex);
lblMessage.Text = "Something went Wrong kindly check log";
lblMessage.ForeColor = Color.Red;
}
}
public List <rptrClass> BindRepeater(List <rptrClass> data = null)
{
try
{
if (data == null)
{
data = new List <rptrClass>();
}
int editItemIndex = hdnItemIndex.Value == "" ? -1 : Convert.ToInt32(hdnItemIndex.Value);
foreach (RepeaterItem item in rptrData.Items)
{
//for deleting of repeater row
if (item.Visible)
{
//To check edit button press so not add record
if (item.ItemIndex != editItemIndex)
{
rptrClass objNext = new rptrClass();
objNext.ItemID = Convert.ToInt32(((HiddenField)item.FindControl("rptrhdnItemID")).Value);
objNext.ItemName = ((Label)item.FindControl("lblItemName")).Text;
objNext.PurchaseRate = Convert.ToDecimal(((Label)item.FindControl("lblPurchaseRate")).Text);
objNext.Quantity = Convert.ToInt32(((Label)item.FindControl("lblQuantity")).Text);
objNext.SellingRate = Convert.ToDecimal(((Label)item.FindControl("lblSellingRate")).Text);
objNext.TotalAmount = Convert.ToDecimal(((Label)item.FindControl("lblTotalAmount")).Text);
objNext.VAT = ((Label)item.FindControl("lblVAT")).Text;
objNext.ItemCode = ((Label)item.FindControl("lblItemCode")).Text;
data.Add(objNext);
}
}
}
//to make edit done
hdnItemIndex.Value = "-1";
return(data);
}
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;
}
}
