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 void FillForm()
{
try
{
string PurchaseOrderIDObj = Request.QueryString[Constants.queryPurchaseOrderID];
if (!string.IsNullOrEmpty(PurchaseOrderIDObj))
{
int PurchaseOrderID = Convert.ToInt32(PurchaseOrderIDObj);
if (PurchaseOrderID > 0)
{
var PurchaseOrderCollection = context.InventoryOrders.Where(x => x.InventoryOrderID == PurchaseOrderID);
if (PurchaseOrderCollection.Count() > 0)
{
//Fill Other Form Data
Database.InventoryOrder purchaseOrder = PurchaseOrderCollection.FirstOrDefault();
txtAmountPaidDate.Text = purchaseOrder.AmountPaidDate.GetValueOrDefault().ToString(Constants.DateFormatDatePicker);
txtBalance.Text = Convert.ToString(purchaseOrder.BalanceAmount);
txtBillDate.Text = purchaseOrder.BillDate.GetValueOrDefault().ToString(Constants.DateFormatDatePicker);
txtDetails.Text = purchaseOrder.Remarks;
txtOwnBillNo.Text = purchaseOrder.OwnBillNo;
txtPaidAmount.Text = Convert.ToString(purchaseOrder.AmountPaid);
txtPurchaseBillNO.Text = purchaseOrder.PurchaseBillNo;
txtPurchaseDate.Text = purchaseOrder.PurchaseDate.GetValueOrDefault().ToString(Constants.DateFormatDatePicker);
txtTotalOrderAmount.Text = Convert.ToString(purchaseOrder.TotalOrderAmount);
ddlCustomerType.SelectedValue = Convert.ToString(purchaseOrder.CustomerTypeID);
txtSellerID.Text = Convert.ToString(purchaseOrder.SellerID);
Database.Seller seller = context.Sellers.Where(x => x.SellerID == purchaseOrder.SellerID).FirstOrDefault();
txtAutoSeller.Text = seller.SellerName;
chkOrderComplete.Checked = Convert.ToBoolean(purchaseOrder.IsCompleted);
//Fill Repeater Data
var invOrderCollection = context.InventoryOrderDetails.Where(x => x.InventoryOrderID == purchaseOrder.InventoryOrderID).ToList();
if (invOrderCollection.Count() > 0)
{
var purchaseOrders = from invOrder in invOrderCollection
join inv in context.InventoryTypes on invOrder.InventoryTypeID equals inv.InventoryTypeId
select new rptrClass
{
ItemID = invOrder.InventoryTypeID,
ItemName = inv.InventoryTypeName,
PurchaseRate = invOrder.PurchaseRate,
Quantity = invOrder.Quantity,
SellingRate = invOrder.SaleRate,
TotalAmount = invOrder.TotalItemsCost,
VAT = invOrder.VatNo,
ItemCode = inv.InventoryCode,
OrderDetailID = invOrder.InventoryOrderDetailID
};
rptrData.DataSource = purchaseOrders.ToList();
rptrData.DataBind();
}
}
else
{
lblMessage.Text = "PurchaseOrder Not Found";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "PurchaseOrder ID Not Valid";
lblMessage.ForeColor = Color.Red;
}
}
else
{
lblMessage.Text = "PurchaseOrder ID Not in right format";
lblMessage.ForeColor = Color.Red;
}
}
catch
{
throw;
}
}
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;
}
}
