public static CalculateAll CalculateTotalAmount(DataTable dtItems, DataTable dtSundri) { CalculateAll cal = new CalculateAll(); if (dtItems != null) { DataTable dtGrdItems = (DataTable)(dtItems); foreach (DataRow item in dtGrdItems.Rows) { cal.IGST += CommonCls.ConvertDecimalZero(item["IGSTTaxAmt"].ToString()); cal.SGST += CommonCls.ConvertDecimalZero(item["SGSTTaxAmt"].ToString()); cal.CGST += CommonCls.ConvertDecimalZero(item["CGSTTaxAmt"].ToString()); cal.CESS += CommonCls.ConvertDecimalZero(item["CESSTaxAmt"].ToString()); cal.ItemAmount += CommonCls.ConvertDecimalZero(item["ItemAmount"].ToString()); cal.ItemTaxable += CommonCls.ConvertDecimalZero(item["NetAmt"].ToString()); cal.ItemDiscount += CommonCls.ConvertDecimalZero(item["DiscountAmt"].ToString()); } } decimal SundriAmt = 0; if (dtSundri != null) { foreach (DataRow item in dtSundri.Rows) { if (item["SundriInd"].ToString() == "Add") //For Sundri Amount Add { SundriAmt += CommonCls.ConvertDecimalZero(item["SundriAmt"].ToString()); } else if (item["SundriInd"].ToString() == "Less") //For Sundri Amount Less { SundriAmt -= CommonCls.ConvertDecimalZero(item["SundriAmt"].ToString()); } } cal.TotalSundriAddLess = SundriAmt; } //cal.TotalGross = cal.ItemTaxable; //cal.TotalAllNet = (cal.TotalTaxable + cal.ItemTaxable + cal.TotalSundriAddLess); cal.TotalGross = Math.Round((cal.ItemAmount - cal.ItemDiscount), 2); cal.TotalTaxable = Math.Round((cal.IGST + cal.SGST + cal.CGST + cal.CESS), 2); cal.TotalAllNet = Math.Round((cal.TotalGross + cal.TotalTaxable + cal.TotalSundriAddLess), 2); return(cal); }
private void CalCulateRevisedBudgetAmt() { if (txtActualUptoBudgetAmtDr.Text == "" && txtPropLastQtrBudgetAmtDr.Text == "") { txtSanc2BudgetAmtDr.Text = ""; } else { decimal Sanc2BudgetAmtDr = (CommonCls.ConvertDecimalZero(txtActualUptoBudgetAmtDr.Text) + CommonCls.ConvertDecimalZero(txtPropLastQtrBudgetAmtDr.Text)); txtSanc2BudgetAmtDr.Text = (Sanc2BudgetAmtDr).ToString(); } if (txtActualUptoBudgetAmtCr.Text == "" && txtPropLastQtrBudgetAmtCr.Text == "") { txtSanc2BudgetAmtDr.Text = ""; } else { decimal Sanc2BudgetAmtCr = (CommonCls.ConvertDecimalZero(txtActualUptoBudgetAmtCr.Text) + CommonCls.ConvertDecimalZero(txtPropLastQtrBudgetAmtCr.Text)); txtSanc2BudgetAmtCr.Text = (Sanc2BudgetAmtCr).ToString(); } }
void BindItemOSEGrid() { DataTable dtItemOSE = new DataTable(); if (ViewState["dtItemOSE"] == null) { dtItemOSE = DtItemOSESchema(); } else { dtItemOSE = (DataTable)ViewState["dtItemOSE"]; } DataRow DrItemOSE = dtItemOSE.NewRow(); DrItemOSE["OrgId"] = Convert.ToInt32(GlobalSession.OrgID); DrItemOSE["ItemID"] = 0; DrItemOSE["WarehouseId"] = Convert.ToInt32(ddlWarehouse.SelectedValue); DrItemOSE["WareHouseName"] = ddlWarehouse.SelectedItem.Text; DrItemOSE["OpeningUnit"] = CommonCls.ConvertIntZero(ddlPriUnit.SelectedValue);//ddlItemUnit.SelectedValue; DrItemOSE["OpeningQty"] = CommonCls.ConvertDecimalZero(txtOpeningQty.Text); if (GlobalSession.StockMaintaineByMinorUnit) { DrItemOSE["OpeningMinorUnit"] = CommonCls.ConvertIntZero(ddlSecUnit.SelectedValue);//ddlMinorUnit.SelectedValue; DrItemOSE["OpeningMinorQty"] = CommonCls.ConvertDecimalZero(txtSecQty.Text); } else { DrItemOSE["OpeningMinorUnit"] = 0; DrItemOSE["OpeningMinorQty"] = 0; } DrItemOSE["OpRate"] = CommonCls.ConvertDecimalZero(txtOpeningRate.Text); DrItemOSE["OpDate"] = CommonCls.ConvertToDate(txtOpeningDate.Text); dtItemOSE.Rows.Add(DrItemOSE); grdItemMaster.DataSource = ViewState["dtItemOSE"] = dtItemOSE; grdItemMaster.DataBind(); }
protected void btnSave_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtSectionName.Text)) { ShowMessage("Select Section Name.", false); txtSectionName.Focus(); return; } if (ddlSubSection.SelectedValue == "0") { ShowMessage("Select Sub-Section Name.", false); ddlSubSection.Focus(); return; } if (string.IsNullOrEmpty(txtSubSection.Text)) { ShowMessage("Select Cost Centre Name.", false); txtSubSection.Focus(); return; } if (string.IsNullOrEmpty(txtBudgetHead.Text)) { ShowMessage("Select Budget Head Name.", false); txtBudgetHead.Focus(); return; } CalCulateRevisedBudgetAmt(); objNewBudgetAmountModel = new NewBudgetAmountModel(); objNewBudgetAmountModel.Ind = 21; objNewBudgetAmountModel.OrgID = GlobalSession.OrgID; objNewBudgetAmountModel.BrID = GlobalSession.BrID; objNewBudgetAmountModel.YrCode = GlobalSession.BudgetYrCD; objNewBudgetAmountModel.SectionCD = 0; objNewBudgetAmountModel.SubSectionCD = CommonCls.ConvertIntZero(SubSectionID); objNewBudgetAmountModel.BudgetHeadCD = CommonCls.ConvertIntZero(BudgetHeadID); objNewBudgetAmountModel.SecCode = CommonCls.ConvertIntZero(SectionID); objNewBudgetAmountModel.UserID = GlobalSession.UserID; objNewBudgetAmountModel.IP = ""; //Current Year Capital if (txtPropBudgetCapitalAmtDr.Text == "" && txtPropBudgetCapitalAmtDr.Enabled == true) { objNewBudgetAmountModel.PropBudgetCapitalAmtDr = -1; } else { objNewBudgetAmountModel.PropBudgetCapitalAmtDr = CommonCls.ConvertDecimalZero(txtPropBudgetCapitalAmtDr.Text); } if (txtPropBudgetCapitalAmtCr.Text == "" && txtPropBudgetCapitalAmtCr.Enabled == true) { objNewBudgetAmountModel.PropBudgetCapitalAmtCr = -1; } else { objNewBudgetAmountModel.PropBudgetCapitalAmtCr = CommonCls.ConvertDecimalZero(txtPropBudgetCapitalAmtCr.Text); } //Current Year Revenue if (txtPropBudgetRevenueAmtDr.Text == "" && txtPropBudgetRevenueAmtDr.Enabled == true) { objNewBudgetAmountModel.PropBudgetRevenueAmtDr = -1; } else { objNewBudgetAmountModel.PropBudgetRevenueAmtDr = CommonCls.ConvertDecimalZero(txtPropBudgetRevenueAmtDr.Text); } if (txtPropBudgetRevenueAmtCr.Text == "" && txtPropBudgetRevenueAmtCr.Enabled == true) { objNewBudgetAmountModel.PropBudgetRevenueAmtCr = -1; } else { objNewBudgetAmountModel.PropBudgetRevenueAmtCr = CommonCls.ConvertDecimalZero(txtPropBudgetRevenueAmtCr.Text); } // Propose Budget Amt if (txtProp2BudgetAmtDr.Text == "" && txtProp2BudgetAmtDr.Enabled == true) { objNewBudgetAmountModel.Prop2BudgetAmtDr = -1; } else { objNewBudgetAmountModel.Prop2BudgetAmtDr = CommonCls.ConvertDecimalZero(txtProp2BudgetAmtDr.Text); } if (txtProp2BudgetAmtCr.Text == "" && txtProp2BudgetAmtCr.Enabled == true) { objNewBudgetAmountModel.Prop2BudgetAmtCr = -1; } else { objNewBudgetAmountModel.Prop2BudgetAmtCr = CommonCls.ConvertDecimalZero(txtProp2BudgetAmtCr.Text); } //Actual Busget Amt if (txtActualUptoBudgetAmtCr.Text == "" && txtActualUptoBudgetAmtCr.Enabled == true) { objNewBudgetAmountModel.ActualUptoBudgetAmtCr = -1; } else { objNewBudgetAmountModel.ActualUptoBudgetAmtCr = CommonCls.ConvertDecimalZero(txtActualUptoBudgetAmtCr.Text); } if (txtActualUptoBudgetAmtDr.Text == "" && txtActualUptoBudgetAmtDr.Enabled == true) { objNewBudgetAmountModel.ActualUptoBudgetAmtDr = -1; } else { objNewBudgetAmountModel.ActualUptoBudgetAmtDr = CommonCls.ConvertDecimalZero(txtActualUptoBudgetAmtDr.Text); } //Qtr Amt if (txtPropLastQtrBudgetAmtCr.Text == "" && txtPropLastQtrBudgetAmtCr.Enabled == true) { objNewBudgetAmountModel.PropLastQtrBudgetAmtCr = -1; } else { objNewBudgetAmountModel.PropLastQtrBudgetAmtCr = CommonCls.ConvertDecimalZero(txtPropLastQtrBudgetAmtCr.Text); } if (txtPropLastQtrBudgetAmtDr.Text == "" && txtPropLastQtrBudgetAmtDr.Enabled == true) { objNewBudgetAmountModel.PropLastQtrBudgetAmtDr = -1; } else { objNewBudgetAmountModel.PropLastQtrBudgetAmtDr = CommonCls.ConvertDecimalZero(txtPropLastQtrBudgetAmtDr.Text); } //Revised //if (txtSanc2BudgetAmtCr.Text == "" && txtSanc2BudgetAmtCr.Enabled == true) // objNewBudgetAmountModel.Sanc2BudgetAmtCr = -1; //else // objNewBudgetAmountModel.Sanc2BudgetAmtCr = CommonCls.ConvertDecimalZero(txtSanc2BudgetAmtCr.Text); //if (txtSanc2BudgetAmtDr.Text == "" && txtSanc2BudgetAmtDr.Enabled == true) // objNewBudgetAmountModel.Sanc2BudgetAmtDr = -1; //else // objNewBudgetAmountModel.Sanc2BudgetAmtDr = CommonCls.ConvertDecimalZero(txtSanc2BudgetAmtDr.Text); objNewBudgetAmountModel.Sanc2BudgetAmtCr = (CommonCls.ConvertDecimalZero(objNewBudgetAmountModel.ActualUptoBudgetAmtCr) + CommonCls.ConvertDecimalZero(objNewBudgetAmountModel.PropLastQtrBudgetAmtCr)); objNewBudgetAmountModel.Sanc2BudgetAmtDr = (CommonCls.ConvertDecimalZero(objNewBudgetAmountModel.ActualUptoBudgetAmtDr) + CommonCls.ConvertDecimalZero(objNewBudgetAmountModel.PropLastQtrBudgetAmtDr)); if (txtPropBudgetCapitalAmtCr.Text == "" && txtPropBudgetRevenueAmtCr.Text == "" && txtPropBudgetCapitalAmtCr.Enabled == true && txtPropBudgetRevenueAmtCr.Enabled == true) { objNewBudgetAmountModel.PropBudgetAmtCr = -1; } else { decimal PropBudgetAmtCr = (CommonCls.ConvertDecimalZero(txtPropBudgetCapitalAmtCr.Text) + CommonCls.ConvertDecimalZero(txtPropBudgetRevenueAmtCr.Text)); objNewBudgetAmountModel.PropBudgetAmtCr = CommonCls.ConvertDecimalZero(PropBudgetAmtCr); } if (txtPropBudgetCapitalAmtDr.Text == "" && txtPropBudgetRevenueAmtDr.Text == "" && txtPropBudgetCapitalAmtDr.Enabled == true && txtPropBudgetRevenueAmtDr.Enabled == true) { objNewBudgetAmountModel.PropBudgetAmtDr = -1; } else { decimal PropBudgetAmtDr = (CommonCls.ConvertDecimalZero(txtPropBudgetCapitalAmtDr.Text) + CommonCls.ConvertDecimalZero(txtPropBudgetRevenueAmtDr.Text)); objNewBudgetAmountModel.PropBudgetAmtDr = CommonCls.ConvertDecimalZero(PropBudgetAmtDr); } //objNewBudgetAmountModel.PropBudgetAmtCr = CommonCls.ConvertDecimalZero(txtPropBudgetCapitalAmtCr.Text + txtPropBudgetRevenueAmtCr.Text); //objNewBudgetAmountModel.PropBudgetAmtDr = CommonCls.ConvertDecimalZero(txtPropBudgetCapitalAmtDr.Text + txtPropBudgetRevenueAmtDr.Text); string uri = string.Format("NewBudgetAmount/SaveBudget"); DataTable dtOpeningBalance = CommonCls.ApiPostDataTable(uri, objNewBudgetAmountModel); if (dtOpeningBalance.Rows.Count > 0) { ShowMessage("Record Save successfully.", true); ClearAll(); } else { ShowMessage("Record Not Save successfully.", false); } } catch (Exception ex) { ShowMessage(ex.Message, false); } }
protected void btnAdd_Click(object sender, EventArgs e) { try { lblmsg.Text = lblmsg.CssClass = ""; if (CommonCls.ConvertIntZero(ddlItemName.SelectedValue) == 0) { ddlItemName.Focus(); ShowMessage("Fill Item Name..!", false); return; } if (CommonCls.ConvertIntZero(ddlwarehouse.SelectedValue) == 0) { ddlwarehouse.Focus(); ShowMessage("Select WareHouse ..!", false); return; } if (CommonCls.ConvertDecimalZero(txtPriQty.Text) == 0) { txtPriQty.Focus(); ShowMessage("Select Item Opening Quantity ..!", false); return; } if (CommonCls.ConvertDecimalZero(txtPriQty.Text) == 0) { txtPriQty.Focus(); txtPriQty.Text = ""; ShowMessage("Enter Opening Item Quantity..!", false); return; } if (CommonCls.ConvertDecimalZero(txtOpRate.Text) == 0) { txtOpRate.Focus(); txtOpRate.Text = ""; ShowMessage("Enter Item Rate..! ", false); return; } if (VsDtOpenStock == null) { VsDtOpenStock = createdtGrdDT(); } if (VsDtOpenStock.Rows.Count > 0) { foreach (DataRow row in VsDtOpenStock.Rows) { //decimal opRate = Convert.ToDecimal(row["OpRate"].ToString()); //int itemID = Convert.ToInt32(row["ItemID"].ToString()); //int Warehousetext = Convert.ToInt32(row["WareHouseId"].ToString()); decimal opRate = Convert.ToDecimal(row["ItemOpeningRate"].ToString()); int itemID = Convert.ToInt32(row["ItemUnitID"].ToString()); int Warehousetext = Convert.ToInt32(row["WareHouseID"].ToString()); if (Convert.ToInt32(ddlItemName.SelectedValue) == itemID && opRate == Convert.ToDecimal(txtOpRate.Text) && Warehousetext == Convert.ToInt32(ddlwarehouse.SelectedValue)) { ShowMessage("Rate allready exist for this item.", false); return; } } } DataRow dr = VsDtOpenStock.NewRow(); #region Old //dr["OrgId"] = GlobalSession.OrgID; //dr["ItemID"] = ddlItemName.SelectedValue; //dr["WareHouseId"] = ddlwarehouse.SelectedItem.Value; //dr["WareHouseName"] = ddlwarehouse.SelectedItem.Text; //dr["OpeningUnit"] = ddlPriUnit.SelectedValue; //dr["OpeningQty"] = txtPriQty.Text; //if (ddlsecunit.SelectedValue == "0") //{ // dr["OpeningMinorUnit"] = 0; //} //else //{ // dr["OpeningMinorUnit"] = ddlsecunit.SelectedValue; //} //dr["OpeningMinorQty"] = txtsecQty.Text; //dr["OpRate"] = txtOpRate.Text; //dr["OpDate"] = CommonCls.ConvertToDate(txtDate.Text); #endregion dr["CompanyID"] = GlobalSession.OrgID; dr["ItemUnitID"] = ddlItemName.SelectedValue; dr["WareHouseID"] = ddlwarehouse.SelectedItem.Value; dr["Address"] = ddlwarehouse.SelectedItem.Text; dr["ItemUnitID"] = ddlPriUnit.SelectedValue; dr["ItemOpeningQty"] = txtPriQty.Text; if (ddlsecunit.SelectedValue == "0") { dr["ItemMinorUnitID"] = 0; } else { dr["ItemMinorUnitID"] = ddlsecunit.SelectedValue; } dr["ItemMinorUnitQty"] = "0"; dr["ItemOpeningRate"] = txtOpRate.Text; dr["ItemOpeningDate"] = CommonCls.ConvertToDate(txtDate.Text); VsDtOpenStock.Rows.Add(dr); gridOpenStock.DataSource = VsDtOpenStock; gridOpenStock.DataBind(); clearGrid(); } catch (Exception ex) { ShowMessage(ex.Message, false); } }
protected void btnSave_Click(object sender, EventArgs e) { lblMsg.Text = lblMsg.CssClass = ""; bool IsValid = ValidationBtnSave(); if (!IsValid) { return; } bool chkUncheck = false; foreach (GridViewRow grdRow in grdReportFormats.Rows) { CheckBox chkSelectOnce = (CheckBox)grdRow.FindControl("chkSelectOnce"); if (chkSelectOnce.Checked == true) { hfFormatID.Value = ((Label)grdRow.FindControl("lblFormatID")).Text; chkUncheck = true; break; } } objPCModel = new ProfileCreationModel(); objPCModel.Ind = 1; objPCModel.CompName = txtCompanyName.Text; objPCModel.ShortName = txtShortName.Text; objPCModel.OrgType = Convert.ToInt32(ddlOrgType.SelectedValue); objPCModel.BusiNature = Convert.ToInt32(ddlBussiNature.SelectedValue); objPCModel.BusiType = Convert.ToInt32(ddlBussiType.SelectedValue); objPCModel.Addr = txtAddress.Text; objPCModel.City = txtCityCompany.Text; objPCModel.State = Convert.ToInt32(ddlStateCompany.SelectedValue); objPCModel.Pin = Convert.ToInt32(txtPincodeCompany.Text); objPCModel.Phone = txtLandLineNo.Text; objPCModel.Fax = txtFaxNo.Text; objPCModel.EMail = txtEmail.Text; objPCModel.PAN = txtPanNo.Text; objPCModel.TAN = txtTanNo.Text; objPCModel.CIN = txtCINNo.Text; objPCModel.IECode = txtImportExportCode.Text; objPCModel.ExportCtg = 0; objPCModel.ContactName = txtPersonName.Text; objPCModel.ContactDesg = txtDesiPerson.Text; objPCModel.ContactEmail = txtEmailPerson.Text; objPCModel.ContactMobile = txtMobileNoPerson.Text; objPCModel.AltPerson = txtPersonNameAlter.Text; objPCModel.AltPersonDesg = txtDesiPersonAlter.Text; objPCModel.AltPersonEmail = txtEmailPersonAlter.Text; objPCModel.AltMobile = txtMobileNoPersonAlter.Text; objPCModel.Composition = Convert.ToInt32(ddlComposiOpted.SelectedValue); objPCModel.CompositionDate = CommonCls.ConvertToDate(txtCompoEffDate.Text); objPCModel.GSTIN = string.IsNullOrEmpty(txtGSTIN.Text) ? "" : txtGSTIN.Text; objPCModel.RegDate = string.IsNullOrEmpty(CommonCls.ConvertToDate(txtRegDate.Text)) ? "" : CommonCls.ConvertToDate(txtRegDate.Text); objPCModel.RegAddr = string.IsNullOrEmpty(txtRegAddress.Text) ? "" : txtRegAddress.Text; objPCModel.RegCity = string.IsNullOrEmpty(txtCityGSTIN.Text) ? "" : txtCityGSTIN.Text; objPCModel.RegState = Convert.ToInt32(ddlStateGSTIN.SelectedValue) == 0 ? 0 : Convert.ToInt32(ddlStateGSTIN.SelectedValue); objPCModel.RegPin = string.IsNullOrEmpty(txtPincodeGSTIN.Text) ? 0 : Convert.ToInt32(txtPincodeGSTIN.Text); objPCModel.RegAuthPerson = txtAuthorizedSign.Text; objPCModel.RegAuthDesg = txtAuthorizedDesi.Text; objPCModel.InvoiceNoSeries = ""; //txtInvioceSeries.Text; objPCModel.InvoiceNo = 0; //string.IsNullOrEmpty(txtStartingNo.Text) ? 0 : Convert.ToInt32(txtStartingNo.Text); objPCModel.YrCD = GlobalSession.YrCD; objPCModel.User = GlobalSession.UserID; objPCModel.IP = GlobalSession.IP; objPCModel.InvoiceCaption1 = txtInvoiceCaption1.Text; objPCModel.InvoicePrint1 = Convert.ToInt32(ddlInvoicePrint1.SelectedValue); objPCModel.InvoiceCaption2 = txtInvoiceCaption2.Text; objPCModel.InvoicePrint2 = Convert.ToInt32(ddlInvoicePrint2.SelectedValue); objPCModel.InvoiceCaption3 = txtInvoiceCaption3.Text; objPCModel.InvoicePrint3 = Convert.ToInt32(ddlInvoicePrint3.SelectedValue); objPCModel.InvoiceCaption4 = txtInvoiceCaption4.Text; objPCModel.InvoicePrint4 = Convert.ToInt32(ddlInvoicePrint4.SelectedValue); objPCModel.InvoiceCaption5 = txtInvoiceCaption5.Text; objPCModel.InvoicePrint5 = Convert.ToInt32(ddlInvoicePrint5.SelectedValue); objPCModel.CompanyLogo = imgCompanyLogo.ImageUrl.Substring(imgCompanyLogo.ImageUrl.LastIndexOf("/") + 1); objPCModel.DtSeries = VsDtSeries; // Series Table objPCModel.UnRegistered = ddlCompanyType.SelectedValue == "1" ? 0 : ddlCompanyType.SelectedValue == "2" ? 0 : 1; objPCModel.CompanyType = Convert.ToInt32(ddlCompanyType.SelectedValue); objPCModel.TurnoverID = Convert.ToInt32(ddlTurnover.SelectedValue); objPCModel.TurnoverDescription = ddlTurnover.SelectedItem.Text; objPCModel.PrintHSNSACCode = Convert.ToInt32(ddlPrintTurnover.SelectedValue); objPCModel.BankName = txtBankName.Text; objPCModel.IFSCCode = txtIFSCCode.Text; objPCModel.AccountNumber = txtAccountNumber.Text; if (cbCopyType.Items[0].Selected) { objPCModel.InvoiceCopy1Header = cbCopyType.Items[0].Text; } if (cbCopyType.Items[1].Selected) { objPCModel.InvoiceCopy2Header = cbCopyType.Items[1].Text; } if (cbCopyType.Items[2].Selected) { objPCModel.InvoiceCopy3Header = cbCopyType.Items[2].Text; } if (cbCopyType.Items[3].Selected) { objPCModel.InvoiceCopy4Header = txtExtra1.Text; } if (cbCopyType.Items[4].Selected) { objPCModel.InvoiceCopy5Header = txtExtra2.Text; } objPCModel.InvoiceOnPrePrinted = Convert.ToInt32(ddlSIOnPrePrinted.SelectedValue); objPCModel.InvoiceCopyNo = string.IsNullOrEmpty(txtNoPrintedCopy.Text) ? 0 : Convert.ToInt32(txtNoPrintedCopy.Text); objPCModel.CompositionCategoryID = ddlCompositionCategory.SelectedItem == null ? 0 : Convert.ToInt32(ddlCompositionCategory.SelectedValue); if (VSDTCompositionCategory != null) // First Time DataTable Create For Grid { DataRow[] row = VSDTCompositionCategory.Select("CompositionCategoryID=" + Convert.ToInt32(ddlCompositionCategory.SelectedValue)); if (row.Count() > 0) { objPCModel.CompositionTaxRate = CommonCls.ConvertDecimalZero(row[0]["CompositionTaxRate"]); } } objPCModel.StcokMaintaneByMinorUnit = Convert.ToInt32(ddlStockMISecUnit.SelectedValue); if (chkUncheck == true) { objPCModel.ReportFormat = Convert.ToInt32(hfFormatID.Value); } else { lblMsg.Text = "Choose Invoice Format!"; ShowMessage(lblMsg.Text, false); return; } if (VSTerms != null) { objPCModel.DtTerms = VSTerms;//(DataTable)ViewState["dtTerms"]; } else { DataTable dtTerms = new DataTable(); dtTerms.Columns.Add("Terms", typeof(string)); dtTerms.Columns.Add("UserID", typeof(int)); dtTerms.Columns.Add("IP", typeof(string)); DataRow drTerms = dtTerms.NewRow(); drTerms["Terms"] = ""; drTerms["UserID"] = GlobalSession.UserID; drTerms["IP"] = GlobalSession.IP; dtTerms.Rows.Add(drTerms); objPCModel.DtTerms = dtTerms; } string uri = string.Format("ProfileCreation/SaveCompanyProfile"); DataTable dtSave = CommonCls.ApiPostDataTable(uri, objPCModel); if (dtSave.Rows.Count > 0) { if (dtSave.Rows[0]["RecordID"].ToString() == "0") { lblMsg.Text = "Record Not Save Please Try Again."; ShowMessage(lblMsg.Text, false); } else if (dtSave.Rows[0]["RecordID"].ToString() == "1") { ClearAll(); Response.Redirect("frmSuccessfullyProfileCreation.aspx?ProfileCreation=" + "Profile Create Successfully!&&OrgName=" + GlobalSession.OrgName); } else if (dtSave.Rows[0]["RecordID"].ToString() == "2") { lblMsg.Text = "Duplicate Record."; ShowMessage(lblMsg.Text, false); txtCompanyName.Focus(); } } else { lblMsg.Text = "Record Not Save Please Try Again."; ShowMessage(lblMsg.Text, false); } }
bool ValidationBtnSave() { if (string.IsNullOrEmpty(txtItemName.Text)) { txtItemName.Focus(); ShowMessage("Enter Item Name.", false); return(false); } if (ddlItemUnit.SelectedValue == "0") { ddlItemUnit.Focus(); ShowMessage("Select Item Unit.", false); return(false); } if (Convert.ToInt16(ddlIsUnitInd.SelectedValue) == 1) { if (CommonCls.ConvertIntZero(ddlMinorUnit.SelectedValue) == 0) { ddlMinorUnit.Focus(); ShowMessage("Select Item Secondary Unit.", false); return(false); } //if (CommonCls.ConvertDecimalZero(txtMinorUnitQty.Text) == 0) //{ // txtMinorUnitQty.Focus(); // ShowMessage("Enter Secondary Unit Qty.", false); // return false; //} } //if (GlobalSession.StockMaintaineByMinorUnit) //{ //} //else //{ // if (CommonCls.ConvertIntZero(ddlMinorUnit.SelectedValue) > 0) // { // if (CommonCls.ConvertDecimalZero(txtMinorUnitQty.Text) == 0) // { // txtMinorUnitQty.Focus(); // ShowMessage("Enter Calculation Factor.", false); // return false; // } // } //} if (CommonCls.ConvertIntZero(ddlItemUnit.SelectedValue) == CommonCls.ConvertIntZero(ddlMinorUnit.SelectedValue)) { ShowMessage("Item Primary Unit & Secondary Unit Could Not Be Same!", false); ddlMinorUnit.Focus(); return(false); } if (ddlItemType.SelectedValue == "0") { ddlItemType.Focus(); ShowMessage("Select Item Type.", false); return(false); } if (string.IsNullOrEmpty(txtHSNSACCode.Text)) { txtHSNSACCode.Focus(); ShowMessage("Enter HSN / SAC Code.", false); return(false); } if (CommonCls.ConvertDecimalZero(ddlTaxrate.SelectedValue) == -1) { ddlTaxrate.Focus(); ShowMessage("Select Tax Rate.", false); return(false); } return(true); }
protected void btnSave_Click(object sender, EventArgs e) { try { if (!CommonCls.CheckGUIDIsValid()) { return; } bool IsValid = ValidationBtnSave(); if (!IsValid) { return; } objItemMaster = new ItemMasterModel(); objItemMaster.Ind = 3; objItemMaster.OrgID = GlobalSession.OrgID; objItemMaster.YrCD = GlobalSession.YrCD; objItemMaster.ItemMainID = Convert.ToInt32(hfMainGrCode.Value); objItemMaster.ItemSubID = Convert.ToInt32(hfSubGrCode.Value); objItemMaster.ItemMinorID = Convert.ToInt32(ddlMinorGroup.SelectedValue); objItemMaster.ItemGroupID = Convert.ToInt32(hfItemGroupID.Value); objItemMaster.ItemName = txtItemName.Text; objItemMaster.ItemShortName = txtShortName.Text; objItemMaster.ItemUnitID = Convert.ToInt32(ddlItemUnit.SelectedValue); objItemMaster.GoodServiceInd = Convert.ToInt32(ddlItemType.SelectedValue); objItemMaster.ItemSellingRate = CommonCls.ConvertDecimalZero(txtSellingRate.Text); objItemMaster.ItemDesc = txtItemDescription.Text == null ? "" : txtItemDescription.Text; objItemMaster.HSNSACCode = txtHSNSACCode.Text; //ddlHSNSACCode.SelectedValue; objItemMaster.ItemCode = Convert.ToInt64(hfMainGrCode.Value + hfSubGrCode.Value + ddlMinorGroup.SelectedValue); objItemMaster.User = GlobalSession.UserID; objItemMaster.IP = GlobalSession.IP; objItemMaster.DtItemOpening = (DataTable)ViewState["dtItemOSE"]; objItemMaster.ItemMinorUnitID = CommonCls.ConvertIntZero(ddlMinorUnit.SelectedValue); objItemMaster.ItemMinorUnitQyt = CommonCls.ConvertDecimalZero(txtMinorUnitQty.Text); objItemMaster.TaxRate = CommonCls.ConvertDecimalZero(ddlTaxrate.SelectedValue) < CommonCls.ConvertDecimalZero("0.05") ? 0 : CommonCls.ConvertDecimalZero(ddlTaxrate.SelectedValue); objItemMaster.TaxRateDesc = ddlTaxrate.SelectedItem.Text; objItemMaster.StockMaintainInd = 0; if (objItemMaster.DtItemOpening != null) { if (objItemMaster.DtItemOpening.Columns.Contains("ItemID")) { objItemMaster.DtItemOpening.Columns.Remove("ItemID"); } if (objItemMaster.DtItemOpening.Columns.Contains("WareHouseName")) { objItemMaster.DtItemOpening.Columns.Remove("WareHouseName"); } //if (objItemMaster.DtItemOpening.Columns.Contains("Warehouse")) //{ // objItemMaster.DtItemOpening.Columns.Remove("Warehouse"); //} } else { objItemMaster.DtItemOpening = DtItemOSESchema(); DataRow drItemOpening = objItemMaster.DtItemOpening.NewRow(); if (objItemMaster.DtItemOpening.Columns.Contains("ItemID")) { objItemMaster.DtItemOpening.Columns.Remove("ItemID"); } if (objItemMaster.DtItemOpening.Columns.Contains("WareHouseName")) { objItemMaster.DtItemOpening.Columns.Remove("WareHouseName"); } drItemOpening["OpeningUnit"] = ""; drItemOpening["OpeningMinorUnit"] = ""; drItemOpening["OpeningMinorQty"] = ""; drItemOpening["OrgId"] = 0; drItemOpening["WarehouseId"] = 0; drItemOpening["OpeningQty"] = 0; drItemOpening["OpRate"] = 0; drItemOpening["OpDate"] = ""; objItemMaster.DtItemOpening.Rows.Add(drItemOpening); //objItemMaster.DtItemOpening.Columns.Remove("Warehouse"); } string uri = string.Format("ItemMaster/SaveItem"); DataTable dtSave = CommonCls.ApiPostDataTable(uri, objItemMaster); if (dtSave.Rows.Count > 0) { if (dtSave.Rows[0]["Column1"].ToString() == "1") { ClearAll(); ShowMessage("Item Save successfully.", true); ddlMinorGroup.Focus(); } else if (dtSave.Rows[0]["Column1"].ToString() == "2") { ShowMessage("Item Already Added.", false); txtItemName.Focus(); } else if (dtSave.Rows[0]["Column1"].ToString() == "3") { ShowMessage("Invalid HSN / SAC Code.", false); txtHSNSACCode.Focus(); } } else { ShowMessage("Record Not Save Please Try Again.", false); } } catch (Exception ex) { ShowMessage(ex.Message, false); } }
bool ValidationBtnAddItemOSE() { if (ddlItemUnit.SelectedValue == ddlMinorUnit.SelectedValue) { ShowMessage("Item Primary Unit & Secondary Unit Could Not Be Same!", false); ddlMinorUnit.Focus(); return(false); } if (CommonCls.ConvertIntZero(ddlItemUnit.SelectedValue) == 0) { ddlItemUnit.Focus(); ShowMessage("Select Item Unit.", false); return(false); } if (ddlWarehouse.SelectedValue == "0") { ddlWarehouse.Focus(); ShowMessage("Select Warehouse.", false); return(false); } if (ViewState["dtItemOSE"] != null) { DataTable dtItemOSE = (DataTable)ViewState["dtItemOSE"]; DataRow[] rows = dtItemOSE.Select("WarehouseId='" + ddlWarehouse.SelectedItem.Value + "' And OpeningQty='" + txtOpeningQty.Text + "' And OpRate='" + txtOpeningRate.Text + "'"); if (rows.Count() >= 1) { ShowMessage("This Qty And Rate Alredy Added On Same Warehouse.", false); //Repeated Record Occurred ddlWarehouse.Focus(); ClearAllAfterBtnAddItemOSE(); return(false); } } if (CommonCls.ConvertDecimalZero(txtOpeningQty.Text) == 0) { txtOpeningQty.Focus(); ShowMessage("Enter Opening Qty.", false); return(false); } if (CommonCls.ConvertDecimalZero(txtOpeningRate.Text) == 0) { txtOpeningRate.Focus(); ShowMessage("Enter Opening Rate.", false); return(false); } if (GlobalSession.StockMaintaineByMinorUnit) { if (CommonCls.ConvertIntZero(txtSecQty.Text) == 0) { txtSecQty.Focus(); ShowMessage("Enter Opening Secondary Qty.", false); return(false); } if (CommonCls.ConvertIntZero(ddlMinorUnit.SelectedValue) == 0) { ShowMessage("Select Secondary Unit.", false); ddlMinorUnit.Focus(); return(false); } } if (string.IsNullOrEmpty(txtOpeningDate.Text)) { txtOpeningDate.Focus(); ShowMessage("Enter Opening Date.", false); return(false); } return(true); }
protected void btnSave_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtSectionName.Text)) { ShowMessage("Select Section Name.", false); txtSectionName.Focus(); return; } if (string.IsNullOrEmpty(txtSubSection.Text)) { ShowMessage("Select Sub-Section Name.", false); txtSubSection.Focus(); return; } if (string.IsNullOrEmpty(txtBudgetHead.Text)) { ShowMessage("Select Budget Head Name.", false); txtBudgetHead.Focus(); return; } //if (txtProposedDrAmt.Enabled == true) //{ // if (string.IsNullOrEmpty(txtProposedDrAmt.Text) || Convert.ToDecimal(txtProposedDrAmt.Text) <= 0) // { // ShowMessage("Enter Proposed Budget Amount 2017-2018.", false); // txtProposedDrAmt.Focus(); // return; // } //} //if (txtProposedCrAmt.Enabled == true) //{ // if (string.IsNullOrEmpty(txtProposedCrAmt.Text) || Convert.ToDecimal(txtProposedCrAmt.Text) <= 0) // { // ShowMessage("Enter Proposed Budget Amount 2017-2018.", false); // txtProposedCrAmt.Focus(); // return; // } //} objBudgetAmountModel = new BudgetAmountModel(); objBudgetAmountModel.Ind = 2; objBudgetAmountModel.OrgID = GlobalSession.OrgID; objBudgetAmountModel.BrID = GlobalSession.BrID; objBudgetAmountModel.YrCode = GlobalSession.YrCD; //objBudgetAmountModel.SectionCD = CommonCls.ConvertIntZero(ddlSection.SelectedValue); //objBudgetAmountModel.SubSectionCD = CommonCls.ConvertIntZero(ddlSubSection.SelectedValue); objBudgetAmountModel.SectionCD = CommonCls.ConvertIntZero(SectionID); objBudgetAmountModel.SubSectionCD = CommonCls.ConvertIntZero(SubSectionID); //objBudgetAmountModel.BudgetHeadCD = CommonCls.ConvertIntZero(ddlBudgetHead.SelectedValue); objBudgetAmountModel.BudgetHeadCD = CommonCls.ConvertIntZero(BudgetHeadID); objBudgetAmountModel.UserID = GlobalSession.UserID; objBudgetAmountModel.IP = ""; objBudgetAmountModel.Actual3budgetAmtDr = CommonCls.ConvertDecimalZero(txtAcutal3DrAmt.Text); objBudgetAmountModel.Actual3budgetAmtCr = CommonCls.ConvertDecimalZero(txtAcutal3CrAmt.Text); objBudgetAmountModel.Prop2BudgetAmtDr = CommonCls.ConvertDecimalZero(txtProposed2DrAmt.Text); objBudgetAmountModel.Prop2BudgetAmtCr = CommonCls.ConvertDecimalZero(txtProposed2CrAmt.Text); objBudgetAmountModel.Sanc2BudgetAmtDr = CommonCls.ConvertDecimalZero(txtSanctioned2DrAmt.Text); objBudgetAmountModel.Sanc2BudgetAmtCr = CommonCls.ConvertDecimalZero(txtSanctioned2CrAmt.Text); objBudgetAmountModel.Actual2budgetAmtDr = CommonCls.ConvertDecimalZero(txtActual2DrAmt.Text); objBudgetAmountModel.Actual2budgetAmtcr = CommonCls.ConvertDecimalZero(txtActual2CrAmt.Text); objBudgetAmountModel.PropBudgetAmtDr = CommonCls.ConvertDecimalZero(txtProposedDrAmt.Text); objBudgetAmountModel.PropBudgetAmtCr = CommonCls.ConvertDecimalZero(txtProposedCrAmt.Text); string uri = string.Format("BudgetAmount/SaveBudget"); DataTable dtOpeningBalance = CommonCls.ApiPostDataTable(uri, objBudgetAmountModel); if (dtOpeningBalance.Rows.Count > 0) { ShowMessage("Record Save successfully.", true); ClearAll(); } else { ShowMessage("Record Not Save successfully.", false); } } catch (Exception ex) { ShowMessage(ex.Message, false); } }