protected void lbDelete_Click(object sender, EventArgs e) { LinkButton linkButton = new LinkButton(); linkButton = (LinkButton)sender; bool result = ACC_HeadTypeManager.DeleteACC_HeadType(Convert.ToInt32(linkButton.CommandArgument)); showACC_HeadTypeGrid(); }
private void showACC_HeadTypeData() { ACC_HeadType aCC_HeadType = new ACC_HeadType(); aCC_HeadType = ACC_HeadTypeManager.GetACC_HeadTypeByID(Int32.Parse(Request.QueryString["aCC_HeadTypeID"])); txtHeadTypeName.Text = aCC_HeadType.HeadTypeName; txtExtraField1.Text = aCC_HeadType.ExtraField1; txtExtraField2.Text = aCC_HeadType.ExtraField2; txtExtraField3.Text = aCC_HeadType.ExtraField3; }
protected void btnAdd_Click(object sender, EventArgs e) { ACC_HeadType aCC_HeadType = new ACC_HeadType(); aCC_HeadType.HeadTypeName = txtHeadTypeName.Text; aCC_HeadType.ExtraField1 = txtExtraField1.Text; aCC_HeadType.ExtraField2 = txtExtraField2.Text; aCC_HeadType.ExtraField3 = txtExtraField3.Text; int resutl = ACC_HeadTypeManager.InsertACC_HeadType(aCC_HeadType); Response.Redirect("AdminACC_HeadTypeDisplay.aspx"); }
private void loadACC_HeadType() { List <ACC_HeadType> aCC_HeadTypes = new List <ACC_HeadType>(); aCC_HeadTypes = ACC_HeadTypeManager.GetAllACC_HeadTypes(); foreach (ACC_HeadType aCC_HeadType in aCC_HeadTypes) { ListItem item = new ListItem(aCC_HeadType.HeadTypeName.ToString(), aCC_HeadType.ACC_HeadTypeID.ToString()); rbtnHeadType.Items.Add(item); } rbtnHeadType.Items.Add(new ListItem("N/A", "0")); rbtnHeadType.Items[rbtnHeadType.Items.Count - 1].Selected = true; }
private void loadACC_HeadType() { ListItem li = new ListItem("Select ACC_HeadType...", "0"); ddlACC_HeadType.Items.Add(li); List <ACC_HeadType> aCC_HeadTypes = new List <ACC_HeadType>(); aCC_HeadTypes = ACC_HeadTypeManager.GetAllACC_HeadTypes(); foreach (ACC_HeadType aCC_HeadType in aCC_HeadTypes) { ListItem item = new ListItem(aCC_HeadType.ACC_HeadTypeName.ToString(), aCC_HeadType.ACC_HeadTypeID.ToString()); ddlACC_HeadType.Items.Add(item); } }
protected void btnUpdate_Click(object sender, EventArgs e) { ACC_HeadType aCC_HeadType = new ACC_HeadType(); aCC_HeadType = ACC_HeadTypeManager.GetACC_HeadTypeByID(Int32.Parse(Request.QueryString["aCC_HeadTypeID"])); ACC_HeadType tempACC_HeadType = new ACC_HeadType(); tempACC_HeadType.ACC_HeadTypeID = aCC_HeadType.ACC_HeadTypeID; tempACC_HeadType.HeadTypeName = txtHeadTypeName.Text; tempACC_HeadType.ExtraField1 = txtExtraField1.Text; tempACC_HeadType.ExtraField2 = txtExtraField2.Text; tempACC_HeadType.ExtraField3 = txtExtraField3.Text; bool result = ACC_HeadTypeManager.UpdateACC_HeadType(tempACC_HeadType); Response.Redirect("AdminACC_HeadTypeDisplay.aspx"); }
private void loadACC_ChartOfAccountLabel4() { ddlAllACC_ChartOfAccountLabel4.Items.Add(new ListItem("Select", "0")); List<ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4s = new List<ACC_ChartOfAccountLabel4>(); aCC_ChartOfAccountLabel4s = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4sForJournalEntry(); List<ACC_HeadType> allACC_HeadType= ACC_HeadTypeManager.GetAllACC_HeadTypes(); foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s) { /* ACC_HeadTypeID HeadTypeName 1 Work Station 2 Raw Materials 3 Products 4 Employee 5 Bank Account 6 Supplier 7 ShareHolder 8 Others */ if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 1 || aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 4 || aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 5 || aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 6 || aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 8 ) { foreach (ACC_HeadType aCC_HeadType in allACC_HeadType) { if (aCC_HeadType.ACC_HeadTypeID == aCC_ChartOfAccountLabel4.ACC_HeadTypeID) { aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text = aCC_HeadType.HeadTypeName+" -> "+ aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text; } } ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString()); ddlAllACC_ChartOfAccountLabel4.Items.Add(item); } } }
protected void btnJournalSubmit_Click(object sender, EventArgs e) { List<ACC_HeadType> allACC_HeadType= ACC_HeadTypeManager.GetAllACC_HeadTypes(); foreach (GridViewRow gvr in gvACC_ChartOfAccountLabel3.Rows) { HiddenField hfChartOfAccountLabel3ID = (HiddenField)gvr.FindControl("hfChartOfAccountLabel3ID"); //DropDownList ddlACC_ChartOfAccountLabel4 = (DropDownList)gvr.FindControl("ddlACC_ChartOfAccountLabel4"); Label lblChartOfAccountLabel3Text = (Label)gvr.FindControl("lblChartOfAccountLabel3Text"); Label lblJournalMasterID = (Label)gvr.FindControl("lblJournalMasterID"); TextBox txtAmount = (TextBox)gvr.FindControl("txtAmount"); TextBox txtPayto = (TextBox)gvr.FindControl("txtPayto"); TextBox txtAddress = (TextBox)gvr.FindControl("txtAddress"); TextBox txtNote = (TextBox)gvr.FindControl("txtNote"); TextBox txtCheckDate = (TextBox)gvr.FindControl("txtCheckDate"); TextBox txtCheckNo = (TextBox)gvr.FindControl("txtCheckNo"); TextBox txtBank = (TextBox)gvr.FindControl("txtBank"); if (txtAmount.Text == "0") { continue; } try { ACC_JournalMaster aCC_JournalMaster = new ACC_JournalMaster(); aCC_JournalMaster.JournalMasterName = "2";//Voucher Type aCC_JournalMaster.ExtraField1 = txtPayto.Text; aCC_JournalMaster.ExtraField2 = txtAddress.Text; aCC_JournalMaster.ExtraField3 = ""; aCC_JournalMaster.Note = txtNote.Text; aCC_JournalMaster.JournalDate = DateTime.Parse(txtJournalDate.Text); aCC_JournalMaster.AddedBy = getLogin().LoginID; aCC_JournalMaster.AddedDate = DateTime.Now; aCC_JournalMaster.UpdatedBy = getLogin().LoginID; aCC_JournalMaster.UpdatedDate = DateTime.Now; aCC_JournalMaster.RowStatusID = 1; int JournalMasterID = 0; JournalMasterID = ACC_JournalMasterManager.InsertACC_JournalMaster(aCC_JournalMaster); ACC_JournalDetail aCC_JournalDetail = new ACC_JournalDetail(); aCC_JournalDetail.JournalMasterID = JournalMasterID; //if(ddlACC_ChartOfAccountLabel4.SelectedValue != "0") //{ // aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(ddlACC_ChartOfAccountLabel4.SelectedValue); // aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ddlACC_ChartOfAccountLabel4.SelectedItem.Text; //} //else //{ aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 0; aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "N/A"; //} aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = lblChartOfAccountLabel3Text.Text; aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = Int32.Parse(hfChartOfAccountLabel3ID.Value); string workStationText = ""; foreach (ACC_HeadType item in allACC_HeadType) { if (item.ACC_HeadTypeID == 1) { workStationText = item.HeadTypeName; break; } } //if (ddlACC_ChartOfAccountLabel4.SelectedItem.Text.Contains(workStationText)) //{ // aCC_JournalDetail.WorkStation = aCC_JournalDetail.ACC_ChartOfAccountLabel4ID; // aCC_JournalDetail.WorkStationName = aCC_JournalDetail.ACC_ChartOfAccountLabel4Text; //} //else //{ aCC_JournalDetail.WorkStation = 1; aCC_JournalDetail.WorkStationName = "Head Office"; //} aCC_JournalDetail.Debit = Decimal.Parse(txtAmount.Text); aCC_JournalDetail.Credit = Decimal.Parse("0"); aCC_JournalDetail.ExtraField3 = ""; aCC_JournalDetail.ExtraField2 = ""; aCC_JournalDetail.ExtraField1 = ""; aCC_JournalDetail.AddedBy = getLogin().LoginID; aCC_JournalDetail.AddedDate = DateTime.Now; aCC_JournalDetail.UpdatedBy = getLogin().LoginID; aCC_JournalDetail.UpdatedDate = DateTime.Now; aCC_JournalDetail.RowStatusID = 1; //For Debit part ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); //For Money Entry aCC_JournalDetail.ACC_ChartOfAccountLabel3Text =""; aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = int.Parse(ddlBalance.SelectedValue.Split('@')[0]); aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = int.Parse(ddlBalance.SelectedValue.Split('@')[1]); aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ""; aCC_JournalDetail.Debit = 0; aCC_JournalDetail.Credit = Decimal.Parse(txtAmount.Text); aCC_JournalDetail.WorkStation = 1; aCC_JournalDetail.WorkStationName = "Head Office"; aCC_JournalDetail.ExtraField3 = txtCheckNo.Text; aCC_JournalDetail.ExtraField2 = txtBank.Text; aCC_JournalDetail.ExtraField1 = txtCheckDate.Text; ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); lblJournalMasterID.Text = "<a href='Voucherprint.aspx?JournalMasterID=" + JournalMasterID.ToString() + "' target='_blank'>PV # " + JournalMasterID.ToString() + "</a>"; //showAlartMessage("Successfully Done."); } catch (Exception ex) { lblJournalMasterID.Text = "<span style='color:red;'>Error !!</span>"; //showAlartMessage("Error occured"); } } }
private void loadACC_ChartOfAccountLabel4() { ddlAllACC_ChartOfAccountLabel4.Items.Add(new ListItem("Select", "0")); List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4s = new List <ACC_ChartOfAccountLabel4>(); List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4sBranches = new List <ACC_ChartOfAccountLabel4>(); List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4sBanks = new List <ACC_ChartOfAccountLabel4>(); //aCC_ChartOfAccountLabel4s = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4sForJournalEntry(); string sql = @" SELECT ACC_ChartOfAccountLabel4.[ACC_ChartOfAccountLabel4ID] ,ACC_ChartOfAccountLabel4.[Code] ,ACC_ChartOfAccountLabel4.[ACC_HeadTypeID] ,ACC_HeadType.HeadTypeName +' -> '+ACC_ChartOfAccountLabel4.[ChartOfAccountLabel4Text] as ChartOfAccountLabel4Text --,ACC_HeadType.HeadTypeName +' -> '+ACC_ChartOfAccountLabel4.[ChartOfAccountLabel4Text] as ChartOfAccountLabel4Text ,ACC_ChartOfAccountLabel4.[ExtraField1] ,ACC_ChartOfAccountLabel4.[ExtraField2] ,ACC_ChartOfAccountLabel4.[ExtraField3] ,ACC_ChartOfAccountLabel4.[AddedBy] ,ACC_ChartOfAccountLabel4.[AddedDate] ,ACC_ChartOfAccountLabel4.[UpdatedBy] ,ACC_ChartOfAccountLabel4.[UpdatedDate] ,ACC_ChartOfAccountLabel4.[RowStatusID] ,ACC_ChartOfAccountLabel4Visibility.IsVisible FROM ACC_ChartOfAccountLabel4 inner join ACC_HeadType on ACC_HeadType.ACC_HeadTypeID=ACC_ChartOfAccountLabel4.ACC_HeadTypeID left outer join ACC_ChartOfAccountLabel4Visibility on ACC_ChartOfAccountLabel4Visibility.ACC_ChartOfAccountLabel4ID =ACC_ChartOfAccountLabel4.[ACC_ChartOfAccountLabel4ID] where ACC_ChartOfAccountLabel4.[RowStatusID] =1 order by ACC_HeadType.ACC_HeadTypeID,ACC_ChartOfAccountLabel4.[ChartOfAccountLabel4Text] "; DataSet ds = CommonManager.SQLExec(sql); foreach (DataRow dr in ds.Tables[0].Rows) { try { dr["IsVisible"] = bool.Parse(dr["IsVisible"].ToString()); } catch (Exception ex) { dr["IsVisible"] = false; } if (!bool.Parse(dr["IsVisible"].ToString())) { ACC_ChartOfAccountLabel4 l4 = new ACC_ChartOfAccountLabel4(); l4.ACC_ChartOfAccountLabel4ID = int.Parse(dr["ACC_ChartOfAccountLabel4ID"].ToString()); l4.ACC_HeadTypeID = int.Parse(dr["ACC_HeadTypeID"].ToString()); l4.ChartOfAccountLabel4Text = dr["ChartOfAccountLabel4Text"].ToString(); aCC_ChartOfAccountLabel4s.Add(l4); } } List <ACC_HeadType> allACC_HeadType = ACC_HeadTypeManager.GetAllACC_HeadTypes(); foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s) { /* * ACC_HeadTypeID HeadTypeName * 1 Work Station * 2 Raw Materials * 3 Products * 4 Employee * 5 Bank Account * 6 Supplier * 7 ShareHolder * 8 Others */ if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 1 && aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.Contains("Show")) { aCC_ChartOfAccountLabel4sBranches.Add(aCC_ChartOfAccountLabel4); } if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 5) { aCC_ChartOfAccountLabel4sBanks.Add(aCC_ChartOfAccountLabel4); } if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 1 || aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 4 || aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 5 || aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 6 || aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 8 ) { //foreach (ACC_HeadType aCC_HeadType in allACC_HeadType) //{ // if (aCC_HeadType.ACC_HeadTypeID == aCC_ChartOfAccountLabel4.ACC_HeadTypeID) // { // aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text = aCC_HeadType.HeadTypeName+" -> "+ aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text; // } //} ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString()); ddlAllACC_ChartOfAccountLabel4.Items.Add(item); } } gvACC_ChartOfAccountLabel4.DataSource = aCC_ChartOfAccountLabel4sBranches; gvACC_ChartOfAccountLabel4.DataBind(); foreach (GridViewRow gvr in gvACC_ChartOfAccountLabel4.Rows) { DropDownList ddlBanks = (DropDownList)gvr.FindControl("ddlBanks"); ddlBanks.Items.Add(new ListItem("select bank acc", "0")); foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4sBanks) { ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString().Split('>')[1], aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString()); ddlBanks.Items.Add(item); } } }
protected void btnJournalSubmit_Click(object sender, EventArgs e) { List <ACC_HeadType> allACC_HeadType = ACC_HeadTypeManager.GetAllACC_HeadTypes(); ACC_JournalMaster aCC_JournalMaster = new ACC_JournalMaster(); aCC_JournalMaster.JournalMasterName = "1";//Voucher Type aCC_JournalMaster.ExtraField1 = ""; aCC_JournalMaster.ExtraField2 = ""; aCC_JournalMaster.ExtraField3 = ""; aCC_JournalMaster.Note = ""; aCC_JournalMaster.JournalDate = DateTime.Parse(txtJournalDate.Text); aCC_JournalMaster.AddedBy = getLogin().LoginID; aCC_JournalMaster.AddedDate = DateTime.Now; aCC_JournalMaster.UpdatedBy = getLogin().LoginID; aCC_JournalMaster.UpdatedDate = DateTime.Now; aCC_JournalMaster.RowStatusID = 1; int JournalMasterID = 0; JournalMasterID = ACC_JournalMasterManager.InsertACC_JournalMaster(aCC_JournalMaster); foreach (GridViewRow gvr in gvACC_ChartOfAccountLabel4.Rows) { HiddenField hfChartOfAccountLabel4ID = (HiddenField)gvr.FindControl("hfChartOfAccountLabel4ID"); DropDownList ddlBank = (DropDownList)gvr.FindControl("ddlBanks"); Label lblChartOfAccountLabel4Text = (Label)gvr.FindControl("lblChartOfAccountLabel4Text"); TextBox txtCashSales = (TextBox)gvr.FindControl("txtCashSales"); TextBox txtCardSaleDBBL = (TextBox)gvr.FindControl("txtCardSaleDBBL"); TextBox txtCardSaleCITY = (TextBox)gvr.FindControl("txtCardSaleCITY"); TextBox txtbKash = (TextBox)gvr.FindControl("txtbKash"); TextBox txtBankDepostiedAmount = (TextBox)gvr.FindControl("txtBankDepostiedAmount"); TextBox txtDiscountAmount = (TextBox)gvr.FindControl("txtDiscountAmount"); if (txtCashSales.Text == "0" && txtCardSaleDBBL.Text == "0" && txtCardSaleCITY.Text == "0") { continue; } try { ACC_JournalDetail aCC_JournalDetail = new ACC_JournalDetail(); aCC_JournalDetail.JournalMasterID = JournalMasterID; aCC_JournalDetail.ExtraField3 = ""; aCC_JournalDetail.ExtraField2 = ""; aCC_JournalDetail.ExtraField1 = ""; aCC_JournalDetail.AddedBy = getLogin().LoginID; aCC_JournalDetail.AddedDate = DateTime.Now; aCC_JournalDetail.UpdatedBy = getLogin().LoginID; aCC_JournalDetail.UpdatedDate = DateTime.Now; aCC_JournalDetail.RowStatusID = 1; aCC_JournalDetail.WorkStation = int.Parse(hfChartOfAccountLabel4ID.Value); aCC_JournalDetail.WorkStationName = lblChartOfAccountLabel4Text.Text; //Discount if (txtDiscountAmount.Text != "0") { //discount Expence aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(hfChartOfAccountLabel4ID.Value); aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = lblChartOfAccountLabel4Text.Text; aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Discount"; aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 181; aCC_JournalDetail.Debit = Decimal.Parse(txtDiscountAmount.Text); aCC_JournalDetail.Credit = Decimal.Parse("0"); ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); //Sales revinew discount aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 829; aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "All products"; aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Sales revinew discount"; aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 180; aCC_JournalDetail.Credit = Decimal.Parse(txtDiscountAmount.Text); aCC_JournalDetail.Debit = Decimal.Parse("0"); ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); } ////Money entry for cash sale //aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(hfChartOfAccountLabel4ID.Value); //aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = lblChartOfAccountLabel4Text.Text; //aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash in Hand"; //aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 1; //aCC_JournalDetail.WorkStation = aCC_JournalDetail.ACC_ChartOfAccountLabel4ID; //aCC_JournalDetail.WorkStationName = aCC_JournalDetail.ACC_ChartOfAccountLabel4Text; //aCC_JournalDetail.Debit = Decimal.Parse(txtCashSales.Text); //aCC_JournalDetail.Credit = Decimal.Parse("0"); //if (txtCashSales.Text !="0") //ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); //Money entry for bKash Sale //<option value="1803"> Brac Bank (New Account) A/C (1524-2029-8148-6001)</option> aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(hfChartOfAccountLabel4ID.Value); aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = lblChartOfAccountLabel4Text.Text; aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 1803; aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "Brac Bank A/C (1524-2029-8148-6001)"; aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash at Bank"; aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 3; aCC_JournalDetail.Debit = Decimal.Parse(txtbKash.Text); aCC_JournalDetail.Credit = Decimal.Parse("0"); if (txtbKash.Text != "0") { ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); } //Money entry for Crard sale CITY aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(hfChartOfAccountLabel4ID.Value); aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = lblChartOfAccountLabel4Text.Text; aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 823; aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "CITY BANK - GentlePark (1401307973001)"; aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash at Bank"; aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 3; aCC_JournalDetail.Debit = Decimal.Parse(txtCardSaleCITY.Text); aCC_JournalDetail.Credit = Decimal.Parse("0"); if (txtCardSaleCITY.Text != "0") { ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); } //Money entry for Crard sale DBBL aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 828; aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "DBBL-126-110-11033"; aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash at Bank"; aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 3; aCC_JournalDetail.Debit = Decimal.Parse(txtCardSaleDBBL.Text); aCC_JournalDetail.Credit = Decimal.Parse("0"); if (txtCardSaleDBBL.Text != "0") { ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); } //bKash sales //<option value="315">bKash Sales ( (Operating income)-Sales Revenue -> Sales Revenue)</option> aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 829; aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "All products"; aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "bKash sales"; aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 315; aCC_JournalDetail.Credit = Decimal.Parse(txtbKash.Text); aCC_JournalDetail.Debit = Decimal.Parse("0"); if (txtbKash.Text != "0") { ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); } //Cash Sales DBBL aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 829; aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "All products"; aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Card Sales (DBBL)"; aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 107; aCC_JournalDetail.Credit = Decimal.Parse(txtCardSaleDBBL.Text); aCC_JournalDetail.Debit = Decimal.Parse("0"); if (txtCardSaleDBBL.Text != "0") { ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); } //Cash Sales CITY aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 829; aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "All products"; aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Card Sales (CITY)"; aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 143; aCC_JournalDetail.Credit = Decimal.Parse(txtCardSaleCITY.Text); aCC_JournalDetail.Debit = Decimal.Parse("0"); if (txtCardSaleCITY.Text != "0") { ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); } if (ddlBank.SelectedValue != "0" && txtCashSales.Text != "0") //if (ddlBank.SelectedValue != "0" && txtBankDepostiedAmount.Text != "0") { //Cash Sales aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 829; aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "All products"; aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash Sale"; aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 106; aCC_JournalDetail.Credit = Decimal.Parse(txtCashSales.Text); aCC_JournalDetail.Debit = Decimal.Parse("0"); ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); ////Bank Deposit //aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(hfChartOfAccountLabel4ID.Value); //aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = lblChartOfAccountLabel4Text.Text; //aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash in Hand"; //aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 1; //aCC_JournalDetail.WorkStation = aCC_JournalDetail.ACC_ChartOfAccountLabel4ID; //aCC_JournalDetail.WorkStationName = aCC_JournalDetail.ACC_ChartOfAccountLabel4Text; ////aCC_JournalDetail.Credit = Decimal.Parse(txtBankDepostiedAmount.Text); //aCC_JournalDetail.Credit = Decimal.Parse(txtCashSales.Text); //aCC_JournalDetail.Debit = Decimal.Parse("0"); //ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(ddlBank.SelectedValue); aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ddlBank.SelectedItem.Text; aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash at Bank"; aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 3; //aCC_JournalDetail.Debit = Decimal.Parse(txtBankDepostiedAmount.Text); aCC_JournalDetail.Debit = Decimal.Parse(txtCashSales.Text); aCC_JournalDetail.Credit = Decimal.Parse("0"); ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); } } catch (Exception ex) { } } hlnkPrintVoucher.Visible = true; hlnkPrintVoucher.NavigateUrl = "Voucherprint.aspx?JournalMasterID=" + JournalMasterID; }
private void loadACC_ChartOfAccountLabel4() { #region Bank balance string sql = @"select SUM(Debit)- SUM(Credit) as Balance ,ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text ,ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID ,ACC_ChartOfAccountLabel3.ACC_ChartOfAccountLabel3ID ,ACC_ChartOfAccountLabel3.ChartOfAccountLabel3Text from ACC_JournalDetail inner join ACC_ChartOfAccountLabel4 on ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID =ACC_JournalDetail.ACC_ChartOfAccountLabel4ID inner join ACC_ChartOfAccountLabel3 on ACC_ChartOfAccountLabel3.ACC_ChartOfAccountLabel3ID = ACC_JournalDetail.ACC_ChartOfAccountLabel3ID inner join ACC_JournalMaster on ACC_JournalDetail.JournalMasterID =ACC_JournalMaster.ACC_JournalMasterID where ACC_JournalDetail.ACC_ChartOfAccountLabel3ID in (1,3) and ACC_JournalMaster.RowStatusID=1 group by ACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text ,ACC_ChartOfAccountLabel3.ChartOfAccountLabel3Text ,ACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID ,ACC_ChartOfAccountLabel3.ACC_ChartOfAccountLabel3ID order by ACC_ChartOfAccountLabel3ID,ChartOfAccountLabel4Text"; DataSet ds = CommonManager.SQLExec(sql); #endregion ddlAllACC_ChartOfAccountLabel4.Items.Add(new ListItem("Select", "0")); List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4s = new List <ACC_ChartOfAccountLabel4>(); List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4sSupplier = new List <ACC_ChartOfAccountLabel4>(); List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4sBanks = new List <ACC_ChartOfAccountLabel4>(); aCC_ChartOfAccountLabel4s = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4sForJournalEntry(); List <ACC_HeadType> allACC_HeadType = ACC_HeadTypeManager.GetAllACC_HeadTypes(); foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s) { /* * ACC_HeadTypeID HeadTypeName * 1 Work Station * 2 Raw Materials * 3 Products * 4 Employee * 5 Bank Account * 6 Supplier * 7 ShareHolder * 8 Others */ if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 6) { aCC_ChartOfAccountLabel4sSupplier.Add(aCC_ChartOfAccountLabel4); } if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 5) { aCC_ChartOfAccountLabel4sBanks.Add(aCC_ChartOfAccountLabel4); } } gvACC_ChartOfAccountLabel4.DataSource = aCC_ChartOfAccountLabel4sBanks; gvACC_ChartOfAccountLabel4.DataBind(); foreach (GridViewRow gvr in gvACC_ChartOfAccountLabel4.Rows) { DropDownList ddlBanks = (DropDownList)gvr.FindControl("ddlBanks"); DropDownList ddlSupplier = (DropDownList)gvr.FindControl("ddlSupplier"); Label lblChartOfAccountLabel4Text = (Label)gvr.FindControl("lblChartOfAccountLabel4Text"); HiddenField hfChartOfAccountLabel4ID = (HiddenField)gvr.FindControl("hfChartOfAccountLabel4ID"); ddlBanks.Items.Add(new ListItem("select bank acc", "0")); TextBox txtOpiningBalance = (TextBox)gvr.FindControl("txtOpiningBalance"); TextBox txtCheckDate = (TextBox)gvr.FindControl("txtCheckDate"); txtCheckDate.Text = DateTime.Today.ToString("dd MMM yyyy"); //lblChartOfAccountLabel4Text.Text = lblChartOfAccountLabel4Text.Text.Split('>')[1]; foreach (DataRow dr in ds.Tables[0].Rows) { if (dr["ACC_ChartOfAccountLabel4ID"].ToString() == hfChartOfAccountLabel4ID.Value) { txtOpiningBalance.Text = dr["Balance"].ToString(); break; } } foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4sBanks) { ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString()); ddlBanks.Items.Add(item); } foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4sSupplier) { ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString()); ddlSupplier.Items.Add(item); } } }
protected void btnJournalSubmit_Click(object sender, EventArgs e) { List <ACC_HeadType> allACC_HeadType = ACC_HeadTypeManager.GetAllACC_HeadTypes(); ACC_JournalMaster aCC_JournalMaster = new ACC_JournalMaster(); aCC_JournalMaster.JournalMasterName = "4";//Contra aCC_JournalMaster.ExtraField1 = ""; aCC_JournalMaster.ExtraField2 = ""; aCC_JournalMaster.ExtraField3 = ""; aCC_JournalMaster.Note = ""; aCC_JournalMaster.JournalDate = DateTime.Parse(txtJournalDate.Text); aCC_JournalMaster.AddedBy = getLogin().LoginID; aCC_JournalMaster.AddedDate = DateTime.Now; aCC_JournalMaster.UpdatedBy = getLogin().LoginID; aCC_JournalMaster.UpdatedDate = DateTime.Now; aCC_JournalMaster.RowStatusID = 1; int JournalMasterID = 0; JournalMasterID = ACC_JournalMasterManager.InsertACC_JournalMaster(aCC_JournalMaster); foreach (GridViewRow gvr in gvACC_ChartOfAccountLabel4.Rows) { HiddenField hfChartOfAccountLabel4ID = (HiddenField)gvr.FindControl("hfChartOfAccountLabel4ID"); DropDownList ddlBanks = (DropDownList)gvr.FindControl("ddlBanks"); DropDownList ddlSupplier = (DropDownList)gvr.FindControl("ddlSupplier"); Label lblChartOfAccountLabel4Text = (Label)gvr.FindControl("lblChartOfAccountLabel4Text"); TextBox txtOpiningBalance = (TextBox)gvr.FindControl("txtOpiningBalance"); TextBox txtCheckDate = (TextBox)gvr.FindControl("txtCheckDate"); TextBox txtCashWithdraw = (TextBox)gvr.FindControl("txtCashWithdraw"); TextBox txtSypplyerPayment = (TextBox)gvr.FindControl("txtSypplyerPayment"); TextBox txtCheckNo = (TextBox)gvr.FindControl("txtCheckNo"); TextBox txtFundTransfer = (TextBox)gvr.FindControl("txtFundTransfer"); TextBox txtDiscountIncome = (TextBox)gvr.FindControl("txtDiscountIncome"); try { ACC_JournalDetail aCC_JournalDetail = new ACC_JournalDetail(); aCC_JournalDetail.JournalMasterID = JournalMasterID; aCC_JournalDetail.ExtraField3 = ""; aCC_JournalDetail.ExtraField2 = ""; aCC_JournalDetail.ExtraField1 = ""; aCC_JournalDetail.AddedBy = getLogin().LoginID; aCC_JournalDetail.AddedDate = DateTime.Now; aCC_JournalDetail.UpdatedBy = getLogin().LoginID; aCC_JournalDetail.UpdatedDate = DateTime.Now; aCC_JournalDetail.RowStatusID = 1; aCC_JournalDetail.WorkStation = 1; aCC_JournalDetail.WorkStationName = "Heand Office"; //For fund transfer To Bank if (txtFundTransfer.Text != "0" && ddlBanks.SelectedValue != "0") { aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(ddlBanks.SelectedValue); } aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ddlBanks.SelectedItem.Text; aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash at Bank"; aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 3; aCC_JournalDetail.Debit = Decimal.Parse(txtFundTransfer.Text); aCC_JournalDetail.Credit = Decimal.Parse("0"); if (txtFundTransfer.Text != "0" && ddlBanks.SelectedValue != "0") { ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); } //For fund transfer From Bank aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(hfChartOfAccountLabel4ID.Value); aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = lblChartOfAccountLabel4Text.Text; aCC_JournalDetail.Credit = Decimal.Parse(txtFundTransfer.Text); aCC_JournalDetail.Debit = Decimal.Parse("0"); if (txtFundTransfer.Text != "0" && ddlBanks.SelectedValue != "0") { ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); } //Cash Withdrawal for Bank aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash at Bank"; aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 3; aCC_JournalDetail.Credit = Decimal.Parse(txtCashWithdraw.Text); aCC_JournalDetail.Debit = Decimal.Parse("0"); if (txtCashWithdraw.Text != "0") { ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); } //Cash Withdrawal for Head OFfcie aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 1; aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "Head Office"; aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash in hand"; aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 1; aCC_JournalDetail.Debit = Decimal.Parse(txtCashWithdraw.Text); aCC_JournalDetail.Credit = 0; if (txtCashWithdraw.Text != "0") { ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); } //Supplier Payment for Bank aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(hfChartOfAccountLabel4ID.Value); aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = lblChartOfAccountLabel4Text.Text; aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash at Bank"; aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 3; aCC_JournalDetail.Credit = Decimal.Parse(txtSypplyerPayment.Text); aCC_JournalDetail.Debit = Decimal.Parse("0"); if (txtSypplyerPayment.Text != "0" && ddlSupplier.SelectedValue != "0") { ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); } //Supplier Payment for Suppliyer if (txtSypplyerPayment.Text != "0" && ddlSupplier.SelectedValue != "0") { aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(ddlSupplier.SelectedValue); } aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ddlSupplier.SelectedItem.Text; aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Suppliyer payable"; aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 43; aCC_JournalDetail.Debit = Decimal.Parse(txtSypplyerPayment.Text); aCC_JournalDetail.Credit = Decimal.Parse("0"); if (txtSypplyerPayment.Text != "0" && ddlSupplier.SelectedValue != "0") { ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); } //Cash discount supplier payable aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(ddlSupplier.SelectedValue); aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ddlSupplier.SelectedItem.Text; aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Suppliyer payable"; aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 43; aCC_JournalDetail.Debit = Decimal.Parse(txtDiscountIncome.Text); aCC_JournalDetail.Credit = Decimal.Parse("0"); if (txtDiscountIncome.Text != "0" && txtDiscountIncome.Text != "") { ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); } //Cash discount for Income aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(ddlSupplier.SelectedValue); aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ddlSupplier.SelectedItem.Text; aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash Discount from Supplier"; aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 211; aCC_JournalDetail.Credit = Decimal.Parse(txtDiscountIncome.Text); aCC_JournalDetail.Debit = Decimal.Parse("0"); if (txtDiscountIncome.Text != "0" && txtDiscountIncome.Text != "") { ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail); } } catch (Exception ex) { } } hlnkPrintVoucher.Visible = true; hlnkPrintVoucher.NavigateUrl = "Voucherprint.aspx?JournalMasterID=" + JournalMasterID; }
private void showACC_HeadTypeGrid() { gvACC_HeadType.DataSource = ACC_HeadTypeManager.GetAllACC_HeadTypes(); gvACC_HeadType.DataBind(); }