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();
}
