private Inv_RChallan ConvertTmpToRchallan(Inv_RChallan_Temp t) { Inv_RChallan c = new Inv_RChallan(); c.BalanceQty = t.BalanceQuanity; c.Barcode = t.BarCode; c.Brand = t.Brand; c.ChallanDate = t.PurchaseDate; c.ChallanNo = t.ChallanNo; c.ChallanTotal = t.ChallanTotal; c.CompanyCode = t.CompanyCode; c.CompanyId = t.CompanyId; c.CompanyName = t.CompanyName; c.CPU = t.CPU; c.DeliveryQty = t.DeliveryQty; c.EditDate = t.EditDate; c.EditUser = t.EditUser; c.FloorName = t.FloorName; c.Id = t.Id; c.PurchaseDate = t.PurchaseDate; c.Ocode = t.OCode; c.ProductGroup = t.ProductGroup; c.ProductId = t.ProductId; c.ProductName = t.ProductName; c.ReceiveQuantity = t.ReceiveQuantity; c.RPU = t.RPU; c.ExpireDate = t.ExpireDate; c.StyleSize = t.StyleSize; c.SupplierCode = t.SupplierCode; c.SupplierReturnQty = t.SupplierReturnQty; c.UnitName = t.UnitName; // if neeeded //c.VailPerPack = t.VailPerPack; //c.TestPerVail = t.TestPerVail; //c.TotalVailQty = t.TotalVailQty; //c.BalanceStatus = t.BalanceStatus; c.Item_Remarks = t.Item_Remarks; c.PO_No = t.PO_No; c.Mode_Of_Delivery = t.Mode_Of_Delivery; c.Unit_Cheked = t.Unit_Cheked; c.Reciept_Condition = t.Reciept_Condition; c.Delivery_Type = t.Delivery_Type; c.Senior_Packer_EID = t.Senior_Packer_EID; c.Move_Coordinator = t.Move_Coordinator; c.Project_Code = t.Project_Code; c.Store_Id = t.Store_Id; c.Store_Unit_Id = t.Store_Unit_Id; return(c); }
internal int Insert(Inv_RChallan rChallan_Obj) { try { _context.Inv_RChallan.AddObject(rChallan_Obj); _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
internal int Update_Rchallan(int Id, string OrderNo) { try { Inv_RChallan prodObj = _context.Inv_RChallan.First(x => x.Id == Id); prodObj.OrderNo = OrderNo; _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
private Inv_RChallan ConvertTmpToRchallan(Inv_RChallan_Temp t) { Inv_RChallan c = new Inv_RChallan(); c.BalanceQty = t.BalanceQuanity; c.Barcode = t.BarCode; c.Brand = t.Brand; c.ChallanDate = t.ChallanDate; c.ChallanNo = t.ChallanNo; c.ChallanTotal = t.ChallanTotal; c.CompanyCode = t.CompanyCode; c.CompanyId = t.CompanyId; c.CompanyName = t.CompanyName; c.CPU = t.CPU; c.DeliveryQty = t.DeliveryQty; c.EditDate = t.EditDate; c.EditUser = t.EditUser; c.FloorName = t.FloorName; c.Id = t.Id; c.PurchaseDate = t.PurchaseDate; c.Ocode = t.OCode; c.ProductGroup = t.ProductGroup; c.ProductId = t.ProductId; c.ProductName = t.ProductName; c.ReceiveQuantity = t.ReceiveQuantity; c.Remarks = t.Item_Remarks; c.RPU = t.RPU; c.ExpireDate = t.ExpireDate; c.StyleSize = t.StyleSize; c.FloorName = t.FloorName; c.SupplierCode = t.SupplierCode; c.SupplierId = t.SupplierId; c.SupplierReturnQty = t.SupplierReturnQty; c.UnitName = t.UnitName; c.OrderNo = t.OrderNo; // if neeeded //c.VailPerPack = t.VailPerPack; //c.TestPerVail = t.TestPerVail; //c.TotalVailQty = t.TotalVailQty; //c.BalanceStatus = t.BalanceStatus; return(c); }
protected void btnTransfer_Click(object sender, EventArgs e) { try { bool status = true; bool CheckStatus = false; foreach (GridViewRow gvRow in grvPOItemList.Rows) { CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox")); if (rowChkBox.Checked == true) { CheckStatus = true; } } if (CheckStatus) { foreach (GridViewRow gvRow in grvPOItemList.Rows) { CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox")); if (rowChkBox.Checked == true) { TextBox txtbxReceive = (TextBox)gvRow.FindControl("txtbxReceiveAmount"); if (txtbxReceive.Text != "") { //Label lblLastRceceive = ((Label)gvRow.FindControl("lblLastReceive")); //double lastReceive = Convert.ToDouble(lblLastRceceive.Text); double ReceiveQty = Convert.ToDouble(txtbxReceive.Text); Label lblOrderQty = ((Label)gvRow.FindControl("lblOrderQty")); double Poqty = Convert.ToDouble(lblOrderQty.Text); if (ReceiveQty == 0) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Check Quantity!')", true); status = false; break; } //else if (ReceiveQty + lastReceive > Poqty) //{ // ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Check Quantity!')", true); // status = false; // break; //} } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input Receive Qty!')", true); status = false; break; } } } if (status) { foreach (GridViewRow gvRow in grvPOItemList.Rows) { CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox")); if (rowChkBox.Checked == true) { Label lbl = ((Label)gvRow.FindControl("lblID")); Label lblPO = ((Label)gvRow.FindControl("lblPONo")); Label lblOrderQty = ((Label)gvRow.FindControl("lblOrderQty")); Label lblStyleAndSize = ((Label)gvRow.FindControl("lblStyleAndSize")); TextBox txtbxReceive = (TextBox)gvRow.FindControl("txtbxReceiveAmount"); double ReceiveQty = Convert.ToDouble(txtbxReceive.Text); DropDownList ddlStoreName = (DropDownList)gvRow.FindControl("ddlStoreName"); //Label lblLastRceceive = ((Label)gvRow.FindControl("lblLastReceive")); //double lastReceive = Convert.ToDouble(lblLastRceceive.Text); TextBox txtRemarks = (TextBox)gvRow.FindControl("txtRemarks"); string ItemsRemark = txtRemarks.Text; //for new product int Id = Convert.ToInt16(lbl.Text); //if (IsExist(Id)) //{ // ProductBLL _productBll = new ProductBLL(); // LC_PurchaseOrder purchaseorder = aLC_RequisitionBLL.GetPurchaseOrderById(Id); //if (!IsExist(purchaseorder)) //{ // Inv_Product _productObj = new Inv_Product(); // _productObj.ProductName = purchaseorder.ProductName; // _productObj.StyleAndSize = purchaseorder.StyleAndSize; // _productObj.ReOrderQty = 0; // _productObj.Price = purchaseorder.Price; // _productObj.Brand = "HB"; // _productObj.GroupId = purchaseorder.GroupId; // _productObj.UnitId = purchaseorder.UnitId; // _productObj.UnitName = purchaseorder.UnitName; // _productObj.EditDate = DateTime.Now; // _productObj.EditUser = ((SessionUser)Session["SessionUser"]).UserId; // _productObj.OCode = ((SessionUser)Session["SessionUser"]).OCode.ToString(); // int productId = _productBll.InsertProductAndGetID(_productObj); // if (productId > 0) // { // _purchaseOrderbll.UpdatePurchaseOrder(Id, productId); // } //} //} string CType = "CENTRAL"; if (CType == "CENTRAL") { LC_PurchaseOrder purchaseorder = aLC_RequisitionBLL.GetPurchaseOrderById(Id); //if (purchaseorder.ItemType == "New Item") //{ // string productName = purchaseorder.ProductName.ToString(); // string StyleandSize = purchaseorder.StyleAndSize.ToString(); // Inv_Product _invProduct = _purchaseOrderbll.GetProductByProductNameandStyle(productName, StyleandSize); // // Inv_Product _invProduct = _purchaseOrderbll.GetProductByProductId(Convert.ToInt32(purchaseorder.BarCode)); // string id = Convert.ToString(Id); // string ChalanNo = GetChalanNo(id); // Inv_BuyCentral buyCentral = buyCentralBll.GetBuyCentralByCompanyAndBarcode(hdnBarCode.Value, ddlCompanyCode.SelectedValue); // if (buyCentral == null) // { // Insert New // Inv_BuyCentral newBuyCentral = new Inv_BuyCentral(); // newBuyCentral.ChallanNo = ChalanNo; // //newBuyCentral.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue); // newBuyCentral.CompanyCode = HiddenCompanyCode.Value; // newBuyCentral.CompanyName = HiddenCompanyName.Value; // newBuyCentral.BarCode = _invProduct.ProductId.ToString(); // newBuyCentral.ProductId = _invProduct.ProductId; // newBuyCentral.ProductGroup = _invProduct.GroupId; // newBuyCentral.ProductName = _invProduct.ProductName; // newBuyCentral.Brand = _invProduct.Brand; // newBuyCentral.Item_Remarks = ItemsRemark; // //------------------------------------------------------------- // //if (ddlProject.SelectedValue != "0") // //{ // // newBuyCentral.Project_Code = ddlProject.SelectedValue; // //} // if (ddlStoreName.SelectedValue != "0") // { // newBuyCentral.Store_Code = ddlStoreName.SelectedValue.ToString(); // } // //if (ddlStoreUnit.SelectedValue != "0") // //{ // // newBuyCentral.Store_Unit_Id = Convert.ToInt16(ddlStoreUnit.SelectedValue); // //} // //DropDownList drpumCheck = (DropDownList)gvRow.FindControl("drpumCkeck"); // //DropDownList drpRecieptCondition = (DropDownList)gvRow.FindControl("ddlRecieptCondition"); // newBuyCentral.StyleSize = _invProduct.StyleAndSize; // //newBuyCentral.FloorName = rchallan.FloorName; // newBuyCentral.UnitName = _invProduct.UnitName; // newBuyCentral.ReceiveQuantity = ReceiveQty;// Convert.ToInt32(purchaseorder.OrderedQty); // //newBuyCentral.CPU = rchallan.CPU; // //newBuyCentral.RPU = rchallan.RPU; // //newBuyCentral.ExpireDate = rchallan.ExpireDate; // newBuyCentral.BalanceQuanity = ReceiveQty;//Convert.ToInt32(purchaseorder.OrderedQty); // try // { // newBuyCentral.PurchaseDate = DateTime.Now; // } // catch // { // newBuyCentral.PurchaseDate = DateTime.Today; // } // newBuyCentral.EditDate = DateTime.Now; // newBuyCentral.EditUser = ((SessionUser)Session["SessionUser"]).UserId; // newBuyCentral.OCode = ((SessionUser)Session["SessionUser"]).OCode; // buyCentralBll.Insert(newBuyCentral); // } // else // { // buyCentral.BalanceQuanity = buyCentral.BalanceQuanity + ReceiveQty;// Convert.ToInt32(purchaseorder.OrderedQty); // //buyCentral.CPU = rchallan.CPU; // //buyCentral.RPU = rchallan.RPU; // //buyCentral.ExpireDate = rchallan.ExpireDate; // buyCentral.ReceiveQuantity = buyCentral.ReceiveQuantity + ReceiveQty;// Convert.ToInt32(purchaseorder.OrderedQty); // buyCentralBll.Update(buyCentral, Convert.ToInt32(buyCentral.Id)); // } // //} // Inv_RChallan rchallan = new Inv_RChallan(); // rchallan.ChallanNo = ChalanNo; // rchallan.PO_No = lblPO.Text; // rchallan.ChallanDate = DateTime.Now; // // rchallan.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue); // rchallan.CompanyCode = HiddenCompanyCode.Value; // rchallan.CompanyName = HiddenCompanyName.Value; // rchallan.Barcode = hdnBarCode.Value; // rchallan.ProductId = _invProduct.ProductId; // rchallan.ProductGroup = _invProduct.GroupId; // rchallan.ProductName = _invProduct.ProductName; // rchallan.Brand = _invProduct.Brand; // rchallan.Remarks = ItemsRemark; // //if (ddlProject.SelectedValue != "0") // //{ // // rchallan.Project_Code = ddlProject.SelectedValue; // //} // if (ddlStoreName.SelectedValue != "0") // { // rchallan.Store_Code = ddlStoreName.SelectedValue.ToString(); // } // //if (ddlStoreUnit.SelectedValue != "0") // //{ // // rchallan.Store_Unit_Id = Convert.ToInt16(ddlStoreUnit.SelectedValue); // //} // //DropDownList drpumCheck1 = (DropDownList)gvRow.FindControl("drpumCkeck"); // //DropDownList drpRecieptConditio1n = (DropDownList)gvRow.FindControl("ddlRecieptCondition"); // //if (drpumCheck1.SelectedValue != "0") // //{ // // rchallan.Unit_Cheked = drpumCheck1.SelectedItem.Text; // //} // //if (drpRecieptConditio1n.SelectedValue != "0") // //{ // // rchallan.Reciept_Condition = drpRecieptConditio1n.SelectedItem.Text; // //} // //rchallan.StyleSize = rchallan.StyleSize; // //rchallan.FloorName = rchallan.FloorName; // rchallan.UnitName = _invProduct.UnitName; // rchallan.ReceiveQuantity = ReceiveQty;// Convert.ToInt32(purchaseorder.OrderedQty); // //rchallan.CPU = rchallan.CPU; // //rchallan.RPU = rchallan.RPU; // //rchallan.ExpireDate = rchallan.ExpireDate; // rchallan.BalanceQty = ReceiveQty;// Convert.ToInt32(purchaseorder.OrderedQty); // try // { // rchallan.PurchaseDate = DateTime.Today; // } // catch // { // rchallan.PurchaseDate = DateTime.Today; // } // rchallan.EditDate = DateTime.Now; // rchallan.EditUser = ((SessionUser)Session["SessionUser"]).UserId; // rchallan.Ocode = ((SessionUser)Session["SessionUser"]).OCode; // rChallanBll.Insert(rchallan); // // string Po = lblPO.Text; // if (lastReceive == 0 && ReceiveQty == Convert.ToDouble(lblOrderQty.Text)) // { // PurchaseOrderBll.PurchaseDone(id); // // PurchaseOrderBll.UpdateLastQty(id, ReceiveQty); // } // else if ((Convert.ToInt16(lblOrderQty.Text) == ReceiveQty + Convert.ToInt16(lastReceive))) // { // PurchaseOrderBll.UpdateLastQty(id, ReceiveQty); // PurchaseOrderBll.PurchaseDone(id); // // PurchaseOrderBll.UpdateLastQty(id, ReceiveQty); // } // else // { // ReceiveQty = ReceiveQty + Convert.ToDouble(lastReceive); // PurchaseOrderBll.UpdateLastQty(id, ReceiveQty); // } // // lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>"; // ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information posted successfully')", true); // SetGriview(); //} //else //{ int productId = Convert.ToInt32(purchaseorder.ProductId); ERPSSL.LC.DAL.Inv_Product _invProduct = aLC_RequisitionBLL.GetProductByProductID(productId); // Inv_Product _invProduct = _purchaseOrderbll.GetProductByProductId(Convert.ToInt32(purchaseorder.BarCode)); string id = Convert.ToString(Id); string ChalanNo = rChallanBll.GetNewRChalanNo(purchaseorder.SupplierCode, DateTime.Now); //string ChalanNo = GetChalanNo(id); //ERPSSL.INV.DAL.Inv_BuyCentral buyCentral = buyCentralBll.GetBuyCentralByCompanyAndBarcode(productId, ddlCompanyCode.SelectedValue); ERPSSL.INV.DAL.Inv_BuyCentral buyCentral = buyCentralBll.GetBuyCentralByCompanyAndBarcode(productId.ToString(), ddlCompanyCode.SelectedValue); if (buyCentral == null) { // Insert New ERPSSL.INV.DAL.Inv_BuyCentral newBuyCentral = new ERPSSL.INV.DAL.Inv_BuyCentral(); newBuyCentral.ChallanNo = ChalanNo; //newBuyCentral.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue); newBuyCentral.CompanyCode = HiddenCompanyCode.Value; newBuyCentral.CompanyName = HiddenCompanyName.Value; newBuyCentral.BarCode = _invProduct.ProductId.ToString(); newBuyCentral.ProductId = _invProduct.ProductId; newBuyCentral.ProductGroup = _invProduct.GroupId; newBuyCentral.ProductName = _invProduct.ProductName; newBuyCentral.Brand = _invProduct.Brand; newBuyCentral.Item_Remarks = ItemsRemark; //if (ddlProject.SelectedValue != "0") //{ // newBuyCentral.Project_Code = ddlProject.SelectedValue; //} if (ddlStoreName.SelectedValue != "0") { newBuyCentral.Store_Code = ddlStoreName.SelectedValue.ToString(); } //if (ddlStoreUnit.SelectedValue != "0") //{ // newBuyCentral.Store_Unit_Id = Convert.ToInt16(ddlStoreUnit.SelectedValue); //} //DropDownList drpumCheck1 = (DropDownList)gvRow.FindControl("drpumCkeck"); //DropDownList drpRecieptConditio1n = (DropDownList)gvRow.FindControl("ddlRecieptCondition"); newBuyCentral.StyleSize = _invProduct.StyleAndSize; //newBuyCentral.FloorName = rchallan.FloorName; newBuyCentral.UnitName = _invProduct.UnitName; newBuyCentral.ReceiveQuantity = ReceiveQty;// Convert.ToInt32(purchaseorder.OrderedQty); //newBuyCentral.CPU = rchallan.CPU; //newBuyCentral.RPU = rchallan.RPU; //newBuyCentral.ExpireDate = rchallan.ExpireDate; newBuyCentral.BalanceQuanity = ReceiveQty;// Convert.ToInt32(purchaseorder.OrderedQty); try { newBuyCentral.PurchaseDate = DateTime.Now; } catch { newBuyCentral.PurchaseDate = DateTime.Today; } newBuyCentral.EditDate = DateTime.Now; newBuyCentral.EditUser = ((SessionUser)Session["SessionUser"]).UserId; newBuyCentral.OCode = ((SessionUser)Session["SessionUser"]).OCode; buyCentralBll.Insert(newBuyCentral); } else { buyCentral.BalanceQuanity = buyCentral.BalanceQuanity + ReceiveQty;// Convert.ToInt32(purchaseorder.OrderedQty); //buyCentral.CPU = rchallan.CPU; //buyCentral.RPU = rchallan.RPU; //buyCentral.ExpireDate = rchallan.ExpireDate; buyCentral.ReceiveQuantity = buyCentral.ReceiveQuantity + ReceiveQty;// Convert.ToInt32(purchaseorder.OrderedQty); buyCentralBll.Update(buyCentral, Convert.ToInt32(buyCentral.Id)); } //} Inv_RChallan rchallan = new Inv_RChallan(); rchallan.ChallanNo = ChalanNo; rchallan.PO_No = lblPO.Text; rchallan.ChallanDate = DateTime.Now; // rchallan.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue); rchallan.CompanyCode = HiddenCompanyCode.Value; rchallan.CompanyName = HiddenCompanyName.Value; rchallan.Barcode = hdnBarCode.Value; rchallan.ProductId = _invProduct.ProductId; rchallan.ProductGroup = _invProduct.GroupId; rchallan.ProductName = _invProduct.ProductName; rchallan.Brand = _invProduct.Brand; //if (ddlProject.SelectedValue != "0") //{ // rchallan.Project_Code = ddlProject.SelectedValue; //} if (ddlStoreName.SelectedValue != "0") { rchallan.Store_Code = ddlStoreName.SelectedValue.ToString(); } //if (ddlStoreUnit.SelectedValue != "0") //{ // rchallan.Store_Unit_Id = Convert.ToInt16(ddlStoreUnit.SelectedValue); //} //DropDownList drpumCheck11 = (DropDownList)gvRow.FindControl("drpumCkeck"); //DropDownList drpRecieptConditio11n = (DropDownList)gvRow.FindControl("ddlRecieptCondition"); //if (drpumCheck11.SelectedValue != "0") //{ // rchallan.Unit_Cheked = drpumCheck11.SelectedItem.Text; //} //if (drpRecieptConditio11n.SelectedValue != "0") //{ // rchallan.Reciept_Condition = drpRecieptConditio11n.SelectedItem.Text; //} rchallan.Remarks = ItemsRemark; //rchallan.StyleSize = rchallan.StyleSize; //rchallan.FloorName = rchallan.FloorName; rchallan.UnitName = _invProduct.UnitName; rchallan.ReceiveQuantity = ReceiveQty;// Convert.ToInt32(purchaseorder.OrderedQty); //rchallan.CPU = rchallan.CPU; //rchallan.RPU = rchallan.RPU; //rchallan.ExpireDate = rchallan.ExpireDate; rchallan.BalanceQty = rchallan.BalanceQty; try { rchallan.PurchaseDate = DateTime.Today; } catch { rchallan.PurchaseDate = DateTime.Today; } rchallan.EditDate = DateTime.Now; rchallan.EditUser = ((SessionUser)Session["SessionUser"]).UserId; rchallan.Ocode = ((SessionUser)Session["SessionUser"]).OCode; rChallanBll.Insert(rchallan); // string Po = lblPO.Text; // PurchaseOrderBll.PurchaseDone(id); //if (lastReceive == 0 && ReceiveQty == Convert.ToDouble(lblOrderQty.Text)) //{ // PurchaseOrderBll.PurchaseDoneByPO(id); // // PurchaseOrderBll.UpdateLastQty(id, ReceiveQty); //} //else if ((Convert.ToDouble(lblOrderQty.Text) == ReceiveQty + Convert.ToInt16(lastReceive))) //{ // PurchaseOrderBll.PurchaseDoneByPO(id); // // PurchaseOrderBll.UpdateLastQty(id, ReceiveQty); //} //else //{ // ReceiveQty = ReceiveQty + Convert.ToDouble(lastReceive); //PurchaseOrderBll.UpdatePOLastQty(id, ReceiveQty); //} // lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>"; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information posted successfully')", true); SetGriview(); //} } } } } } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Select Items')", true); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
internal int Enter_VoucherDetails(string OCODE, string Company_Code, string Edit_User, string ModuleName, string ModuleType, string VoucherType, string IdentitiNo, Inv_RChallan rChallan_Obj) { try { decimal Amount = 0; Amount = Convert.ToDecimal(Amount) + (Convert.ToDecimal(rChallan_Obj.CPU) * Convert.ToDecimal(rChallan_Obj.ReceiveQuantity)); var Amount_ = new SqlParameter("@Amount", Amount); var ModuleName_ = new SqlParameter("@ModuleName", ModuleName); var VoucherType_ = new SqlParameter("@VoucherType", VoucherType); var Edit_User_ = new SqlParameter("@Edit_User", Edit_User); var Company_Code_ = new SqlParameter("@Company_Code", Company_Code); var OCode_ = new SqlParameter("@OCode", OCODE); var ItemCode_ = new SqlParameter("@ItemCode", ModuleType); var Identity = new SqlParameter("@IdentificationNo", IdentitiNo); string SP_SQL = "Vch_Enter_AC_VoucherDetails_by_Module @Amount,@ModuleName,@VoucherType,@Edit_User,@Company_Code,@OCode,@ItemCode,@IdentificationNo"; return(_context.ExecuteStoreCommand(SP_SQL, Amount_, ModuleName_, VoucherType_, Edit_User_, Company_Code_, OCode_, ItemCode_, Identity)); } catch (Exception) { throw; } }
protected void BtnSave_Click(object sender, EventArgs e) { try { string challanNo = txtChalanNo.Text.Trim(); //string CType = hiddenCompanyType.Value; string CType = "CENTRAL"; if (CType == "CENTRAL") { Inv_BuyCentral buyCentral = buyCentralBll.GetBuyCentralByCompanyAndBarcode(hdnBarCode.Value, ddlCompanyCode.SelectedValue.ToString()); if (buyCentral == null) { // Insert New Inv_BuyCentral newBuyCentral = new Inv_BuyCentral(); newBuyCentral.ChallanNo = txtChalanNo.Text; newBuyCentral.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue); newBuyCentral.CompanyCode = HiddenCompanyCode.Value; newBuyCentral.CompanyName = HiddenCompanyName.Value; newBuyCentral.BarCode = hdnBarCode.Value; newBuyCentral.ProductId = int.Parse(hdnBarCode.Value.ToString()); newBuyCentral.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString()); newBuyCentral.ProductName = txtProduct.Text; newBuyCentral.Brand = txtBrand.Text; //newBuyCentral.StyleSize = rchallan.StyleSize; //newBuyCentral.FloorName = rchallan.FloorName; newBuyCentral.UnitName = txtUnit.Text; newBuyCentral.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim()); //newBuyCentral.CPU = rchallan.CPU; //newBuyCentral.RPU = rchallan.RPU; //newBuyCentral.ExpireDate = rchallan.ExpireDate; //newBuyCentral.BalanceQuanity = rchallan.BalanceQty; try { newBuyCentral.PurchaseDate = DateTime.Parse(txtDate.Text); } catch { newBuyCentral.PurchaseDate = DateTime.Today; } newBuyCentral.EditDate = DateTime.Now; newBuyCentral.EditUser = ((SessionUser)Session["SessionUser"]).UserId; newBuyCentral.OCode = ((SessionUser)Session["SessionUser"]).OCode; buyCentralBll.Insert(newBuyCentral); } else { buyCentral.BalanceQuanity = buyCentral.BalanceQuanity + Convert.ToInt32(txtRecQty.Text.Trim()); //buyCentral.CPU = rchallan.CPU; //buyCentral.RPU = rchallan.RPU; //buyCentral.ExpireDate = rchallan.ExpireDate; buyCentral.ReceiveQuantity = buyCentral.ReceiveQuantity + Convert.ToInt32(txtRecQty.Text.Trim()); buyCentralBll.Update(buyCentral, Convert.ToInt32(buyCentral.Id)); } Inv_RChallan rchallan = new Inv_RChallan(); rchallan.ChallanNo = txtChalanNo.Text; rchallan.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue); rchallan.CompanyCode = HiddenCompanyCode.Value; rchallan.CompanyName = HiddenCompanyName.Value; rchallan.Barcode = hdnBarCode.Value; rchallan.ProductId = int.Parse(hdnBarCode.Value.ToString()); rchallan.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString()); rchallan.ProductName = txtProduct.Text; rchallan.Brand = txtBrand.Text; //rchallan.StyleSize = rchallan.StyleSize; //rchallan.FloorName = rchallan.FloorName; rchallan.UnitName = txtUnit.Text; rchallan.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim()); //rchallan.CPU = rchallan.CPU; //rchallan.RPU = rchallan.RPU; //rchallan.ExpireDate = rchallan.ExpireDate; //rchallan.BalanceQuanity = rchallan.BalanceQty; try { rchallan.PurchaseDate = DateTime.Parse(txtDate.Text); } catch { rchallan.PurchaseDate = DateTime.Today; } rchallan.EditDate = DateTime.Now; rchallan.EditUser = ((SessionUser)Session["SessionUser"]).UserId; rchallan.Ocode = ((SessionUser)Session["SessionUser"]).OCode; rChallanBll.Insert(rchallan); PurchaseOrderBll.PurchaseDone(txtPOrderNo.Text); LoadPurchaseOrders(); // lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>"; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information posted successfully')", true); GenerateReport(); ClearForm(); } else // obsolete // hiddenCompanyType = General { Inv_Buy buy = buyBll.GetBuyByCompanyAndBarcode(hdnBarCode.Value, ddlCompanyCode.SelectedValue.ToString()); if (buy == null) { // Insert New Inv_Buy invBuy = new Inv_Buy(); invBuy.ChallanNo = txtChalanNo.Text; invBuy.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue); invBuy.CompanyCode = HiddenCompanyCode.Value; invBuy.CompanyName = HiddenCompanyName.Value; invBuy.BarCode = hdnBarCode.Value; invBuy.ProductId = int.Parse(hdnBarCode.Value.ToString()); invBuy.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString()); invBuy.ProductName = txtProduct.Text; invBuy.Brand = txtBrand.Text; //newBuyCentral.StyleSize = rchallan.StyleSize; //newBuyCentral.FloorName = rchallan.FloorName; invBuy.UnitName = txtUnit.Text; invBuy.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim()); //newBuyCentral.CPU = rchallan.CPU; //newBuyCentral.RPU = rchallan.RPU; //newBuyCentral.ExpireDate = rchallan.ExpireDate; //newBuyCentral.BalanceQuanity = rchallan.BalanceQty; try { invBuy.PurchaseDate = DateTime.Parse(txtDate.Text); } catch { invBuy.PurchaseDate = DateTime.Today; } invBuy.EditDate = DateTime.Now; invBuy.EditUser = ((SessionUser)Session["SessionUser"]).UserId; invBuy.OCode = ((SessionUser)Session["SessionUser"]).OCode; buyBll.Insert(invBuy); } else { buy.BalanceQuanity = buy.BalanceQuanity + Convert.ToInt32(txtRecQty.Text.Trim()); //buy.CPU = rchallan.CPU; //buy.RPU = rchallan.RPU; //buy.ExpireDate = rchallan.ExpireDate; buy.ReceiveQuantity = buy.ReceiveQuantity + Convert.ToInt32(txtRecQty.Text.Trim()); buyBll.Update(buy, Convert.ToInt32(buy.Id)); } Inv_RChallan rchallan = new Inv_RChallan(); rchallan.ChallanNo = txtChalanNo.Text; rchallan.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue); rchallan.CompanyCode = HiddenCompanyCode.Value; rchallan.CompanyName = HiddenCompanyName.Value; rchallan.Barcode = hdnBarCode.Value; rchallan.ProductId = int.Parse(hdnBarCode.Value.ToString()); rchallan.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString()); rchallan.ProductName = txtProduct.Text; rchallan.Brand = txtBrand.Text; //rchallan.StyleSize = rchallan.StyleSize; //rchallan.FloorName = rchallan.FloorName; rchallan.UnitName = txtUnit.Text; rchallan.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim()); //rchallan.CPU = rchallan.CPU; //rchallan.RPU = rchallan.RPU; //rchallan.ExpireDate = rchallan.ExpireDate; //rchallan.BalanceQuanity = rchallan.BalanceQty; try { rchallan.PurchaseDate = DateTime.Parse(txtDate.Text); } catch { rchallan.PurchaseDate = DateTime.Today; } rchallan.EditDate = DateTime.Now; rchallan.EditUser = ((SessionUser)Session["SessionUser"]).UserId; rchallan.Ocode = ((SessionUser)Session["SessionUser"]).OCode; rChallanBll.Insert(rchallan); PurchaseOrderBll.PurchaseDone(txtPOrderNo.Text); LoadPurchaseOrders(); //lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>"; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information posted successfully')", true); } ClearForm(); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
internal int Insert(Inv_RChallan rChallanObj) { return(rChallanDal.Insert(rChallanObj)); }
internal int Enter_VoucherDetails(string OCODE, string Company_Code, string Edit_User, string ModuleName, string ModuleType, string VoucherType, string Identity, Inv_RChallan rChallan_Obj) { return(rChallanDal.Enter_VoucherDetails(OCODE, Company_Code, Edit_User, ModuleName, ModuleType, VoucherType, Identity, rChallan_Obj)); }