protected void btnUpdate_Click(object sender, EventArgs e)
{
ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 = new ACC_ChartOfAccountLabel4();
aCC_ChartOfAccountLabel4 = ACC_ChartOfAccountLabel4Manager.GetACC_ChartOfAccountLabel4ByID(Int32.Parse(hfaCC_ChartOfAccountLabel4ID.Value));
ACC_ChartOfAccountLabel4 tempACC_ChartOfAccountLabel4 = new ACC_ChartOfAccountLabel4();
tempACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID = aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID;
tempACC_ChartOfAccountLabel4.Code = txtCode.Text;
tempACC_ChartOfAccountLabel4.ACC_HeadTypeID = Int32.Parse(ddlACC_HeadType.SelectedValue);
tempACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text = txtChartOfAccountLabel4Text.Text;
tempACC_ChartOfAccountLabel4.ExtraField1 = txtExtraField1.Text;
tempACC_ChartOfAccountLabel4.ExtraField2 = txtExtraField2.Text;
tempACC_ChartOfAccountLabel4.ExtraField3 = ddlACC_HeadType.SelectedValue == "10" ? (ddlCOAL3.SelectedValue == "0" ? "203" : ddlCOAL3.SelectedValue) : txtExtraField3.Text;
tempACC_ChartOfAccountLabel4.AddedBy = getLogin().LoginID;
tempACC_ChartOfAccountLabel4.AddedDate = DateTime.Now;
tempACC_ChartOfAccountLabel4.UpdatedBy = getLogin().LoginID;
tempACC_ChartOfAccountLabel4.UpdatedDate = DateTime.Now;
tempACC_ChartOfAccountLabel4.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
bool result = ACC_ChartOfAccountLabel4Manager.UpdateACC_ChartOfAccountLabel4(tempACC_ChartOfAccountLabel4);
showACC_ChartOfAccountLabel4Grid();
btnUpdate.Visible = false;
btnAdd.Visible = true;
btnClear_Click(this, new EventArgs());
}
private void loadACC_ChartOfAccountLabel4()
{
List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4s = new List <ACC_ChartOfAccountLabel4>();
aCC_ChartOfAccountLabel4s = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4sForJournalEntry();
ddlProduct.Items.Add(new ListItem("Any Product", "0"));
ddlWorkStation.Items.Add(new ListItem("Select ShowRoom", "0"));
foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_HeadTypeID.ToString() + "@" + aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 3)
{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlProduct.Items.Add(item);
}
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 1 && aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.Contains("Room"))
{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlWorkStation.Items.Add(item);
}
}
}
private void showACC_ChartOfAccountLabel4Data()
{
ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 = new ACC_ChartOfAccountLabel4();
aCC_ChartOfAccountLabel4 = ACC_ChartOfAccountLabel4Manager.GetACC_ChartOfAccountLabel4ByID(Int32.Parse(hfaCC_ChartOfAccountLabel4ID.Value));
txtCode.Text = aCC_ChartOfAccountLabel4.Code;
ddlACC_HeadType.SelectedValue = aCC_ChartOfAccountLabel4.ACC_HeadTypeID.ToString();
txtChartOfAccountLabel4Text.Text = aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text;
txtExtraField1.Text = aCC_ChartOfAccountLabel4.ExtraField1;
txtExtraField2.Text = aCC_ChartOfAccountLabel4.ExtraField2;
txtExtraField3.Text = aCC_ChartOfAccountLabel4.ExtraField3;
txtAddedBy.Text = aCC_ChartOfAccountLabel4.AddedBy.ToString();
txtUpdatedBy.Text = aCC_ChartOfAccountLabel4.UpdatedBy.ToString();
//txtUpdatedDate.Text = aCC_ChartOfAccountLabel4.UpdatedDate;
ddlRowStatus.SelectedValue = aCC_ChartOfAccountLabel4.RowStatusID.ToString();
if (ddlACC_HeadType.SelectedValue == "10")
{
ddlCOAL3.Visible = true;
try
{
ddlCOAL3.SelectedValue = aCC_ChartOfAccountLabel4.ExtraField3;
}
catch (Exception ex)
{ }
txtExtraField3.Enabled = false;
}
else
{
txtExtraField3.Enabled = true;
ddlCOAL3.Visible = false;
}
}
private void loadACC_ChartOfAccountLabel4()
{
List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4s = new List <ACC_ChartOfAccountLabel4>();
aCC_ChartOfAccountLabel4s = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4sForJournalEntry();
ddlACC_ChartOfAccountLabel4.Items.Add(new ListItem("All Supplier", "0"));
ddlWorkStationForTransactionReport.Items.Add(new ListItem("All Workstation", "0"));
foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s)
{
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 6)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlACC_ChartOfAccountLabel4.Items.Add(item);
}
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 1)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlWorkStationForTransactionReport.Items.Add(item);
}
}
try
{
ddlWorkStationForTransactionReport.SelectedValue = getLogin().ExtraField5;
}
catch (Exception ex)
{ }
}
private void loadACC_ChartOfAccountLabel4()
{
List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4s = new List <ACC_ChartOfAccountLabel4>();
aCC_ChartOfAccountLabel4s = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4sForJournalEntry();
ddlReference.Items.Add(new ListItem("Select Referrence", "0"));
ddlBranch.Items.Add(new ListItem("Select Branch", "0"));
foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_HeadTypeID.ToString() + "@" + aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 4)
{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlReference.Items.Add(item);
}
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 1 && aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.Contains("Show"))
{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlBranch.Items.Add(item);
}
}
}
private void loadACC_ChartOfAccountLabel4()
{
List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4s = new List <ACC_ChartOfAccountLabel4>();
aCC_ChartOfAccountLabel4s = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4sForJournalEntry();
ddlEmployee.Items.Add(new ListItem("Select Employee", "0"));
ddlWorkSatation.Items.Add(new ListItem("Select WorkStation", "0"));
ddlProductAll.Items.Add(new ListItem("Select Product", "0"));
foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_HeadTypeID.ToString() + "@" + aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 4)
{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlEmployee.Items.Add(item);
}
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 1)
{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlWorkSatation.Items.Add(item);
}
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 3)
{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlProductAll.Items.Add(item);
}
}
}
private void loadACC_ChartOfAccountLabel4()
{
List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4s = new List <ACC_ChartOfAccountLabel4>();
aCC_ChartOfAccountLabel4s = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4sForJournalEntry();
ddlProduct.Items.Add(new ListItem("Select Product", "0"));
ddlRawMaterial.Items.Add(new ListItem("Select RawMaterial", "0"));
foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_HeadTypeID.ToString() + "@" + aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 3)
{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlProduct.Items.Add(item);
}
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 2)
{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlRawMaterial.Items.Add(item);
}
}
}
private void loadACC_ChartOfAccountLabel4()
{
List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4s = new List <ACC_ChartOfAccountLabel4>();
aCC_ChartOfAccountLabel4s = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4sForJournalEntry();
ddlProduct.Items.Add(new ListItem("Any Product", "0"));
ddlWorkStation.Items.Add(new ListItem("Select WorkStation", "0"));
ddlRefference.Items.Add(new ListItem("Select Ref", "0"));
foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_HeadTypeID.ToString() + "@" + aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 7) // share holder
{
item = new ListItem("00-" + aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlRefference.Items.Add(item);
}
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 3)
{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlProduct.Items.Add(item);
}
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 1
&&
(
aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.Contains("Head")
||
aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.Contains("Show")
)
)
{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlWorkStation.Items.Add(item);
}
}
foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s)
{
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 4
&&
aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.Contains("H1")
) //Head Office
{
ListItem item = new ListItem();
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlRefference.Items.Add(item);
}
}
//if (int.Parse(Request.QueryString["TransactionTypeID"]) == 0)
//{
// UpdatePanel2.Visible = false;
//}
}
private void loadACC_ChartOfAccountLabel4()
{
List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4s = new List <ACC_ChartOfAccountLabel4>();
aCC_ChartOfAccountLabel4s = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4sForJournalEntry();
ddlACC_ChartOfAccountLabel4.Items.Add(new ListItem("-- Any Supplier --", "0"));
ddlWorkStationID.Items.Add(new ListItem("-- Any Workstation --", "0"));
ddlWorkStationForTransactionReport.Items.Add(new ListItem("-- Any Workstation --", "0"));
foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s)
{
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 6)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlACC_ChartOfAccountLabel4.Items.Add(item);
}
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 1)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlWorkStationID.Items.Add(item);
ddlWorkStationForTransactionReport.Items.Add(item);
}
}
}
protected void lbDelete_Click(object sender, EventArgs e)
{
LinkButton linkButton = new LinkButton();
linkButton = (LinkButton)sender;
bool result = ACC_ChartOfAccountLabel4Manager.DeleteACC_ChartOfAccountLabel4(Convert.ToInt32(linkButton.CommandArgument));
showACC_ChartOfAccountLabel4Grid();
}
private void loadACC_ChartOfAccountLabel4()
{
ListItem li = new ListItem("Select ACC_ChartOfAccountLabel4...", "0");
ddlACC_ChartOfAccountLabel4.Items.Add(li);
List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4s = new List <ACC_ChartOfAccountLabel4>();
aCC_ChartOfAccountLabel4s = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4s();
foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4Name.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlACC_ChartOfAccountLabel4.Items.Add(item);
}
}
private void showACC_ChartOfAccountLabel4Data()
{
ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 = new ACC_ChartOfAccountLabel4();
aCC_ChartOfAccountLabel4 = ACC_ChartOfAccountLabel4Manager.GetACC_ChartOfAccountLabel4ByID(Int32.Parse(Request.QueryString["aCC_ChartOfAccountLabel4ID"]));
txtCode.Text = aCC_ChartOfAccountLabel4.Code;
ddlACC_HeadType.SelectedValue = aCC_ChartOfAccountLabel4.ACC_HeadTypeID.ToString();
txtChartOfAccountLabel4Text.Text = aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text;
txtExtraField1.Text = aCC_ChartOfAccountLabel4.ExtraField1;
txtExtraField2.Text = aCC_ChartOfAccountLabel4.ExtraField2;
txtExtraField3.Text = aCC_ChartOfAccountLabel4.ExtraField3;
txtAddedBy.Text = aCC_ChartOfAccountLabel4.AddedBy.ToString();
txtUpdatedBy.Text = aCC_ChartOfAccountLabel4.UpdatedBy.ToString();
txtUpdatedDate.Text = aCC_ChartOfAccountLabel4.UpdatedDate;
ddlRowStatus.SelectedValue = aCC_ChartOfAccountLabel4.RowStatusID.ToString();
}
private void loadACC_ChartOfAccountLabel4()
{
List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4s = new List <ACC_ChartOfAccountLabel4>();
aCC_ChartOfAccountLabel4s = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4sForJournalEntry();
ddlACC_ChartOfAccountLabel4.Items.Add(new ListItem("All Supplier", "0"));
ddlWorkStationForTransactionReport.Items.Add(new ListItem("All Workstation", "0"));
ddlSalesMan.Items.Add(new ListItem("All Salesman", "0"));
ddlProduct.Items.Add(new ListItem("All Product-->", "0"));
foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s)
{
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 6)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlACC_ChartOfAccountLabel4.Items.Add(item);
}
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 4)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlSalesMan.Items.Add(item);
}
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 3)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlProduct.Items.Add(item);
}
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 1
/*&&
* (
* aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.Contains("Head")
||
||aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.Contains("Show")
||)*/
)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlWorkStationForTransactionReport.Items.Add(item);
}
}
}
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 btnAdd_Click(object sender, EventArgs e)
{
ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 = new ACC_ChartOfAccountLabel4();
aCC_ChartOfAccountLabel4.Code = txtCode.Text;
aCC_ChartOfAccountLabel4.ACC_HeadTypeID = Int32.Parse(ddlACC_HeadType.SelectedValue);
aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text = txtChartOfAccountLabel4Text.Text;
aCC_ChartOfAccountLabel4.ExtraField1 = txtExtraField1.Text;
aCC_ChartOfAccountLabel4.ExtraField2 = txtExtraField2.Text;
aCC_ChartOfAccountLabel4.ExtraField3 = txtExtraField3.Text;
aCC_ChartOfAccountLabel4.AddedBy = Int32.Parse(txtAddedBy.Text);
aCC_ChartOfAccountLabel4.AddedDate = DateTime.Now;
aCC_ChartOfAccountLabel4.UpdatedBy = Int32.Parse(txtUpdatedBy.Text);
aCC_ChartOfAccountLabel4.UpdatedDate = DateTime.Now;
aCC_ChartOfAccountLabel4.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
int resutl = ACC_ChartOfAccountLabel4Manager.InsertACC_ChartOfAccountLabel4(aCC_ChartOfAccountLabel4);
Response.Redirect("AdminACC_ChartOfAccountLabel4Display.aspx");
}
private void loadACC_ChartOfAccountLabel4()
{
List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4s = new List <ACC_ChartOfAccountLabel4>();
aCC_ChartOfAccountLabel4s = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4sForJournalEntry();
ddlSuppier.Items.Add(new ListItem("Select Supplier", "0"));
foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_HeadTypeID.ToString() + "@" + aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 6)
{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlSuppier.Items.Add(item);
}
}
}
private void loadACC_ChartOfAccountLabel4()
{
List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4s = new List <ACC_ChartOfAccountLabel4>();
aCC_ChartOfAccountLabel4s = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4sForJournalEntry();
ddlShowRoom.Items.Add(new ListItem("All Show Room", "0"));
foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_HeadTypeID.ToString() + "@" + aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
if ((aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID == 1 || aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToLower().Contains("show room")) &&
aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 1)
{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlShowRoom.Items.Add(item);
}
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 = new ACC_ChartOfAccountLabel4();
aCC_ChartOfAccountLabel4.Code = txtCode.Text;
aCC_ChartOfAccountLabel4.ACC_HeadTypeID = Int32.Parse(ddlACC_HeadType.SelectedValue);
aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text = txtChartOfAccountLabel4Text.Text;
aCC_ChartOfAccountLabel4.ExtraField1 = txtExtraField1.Text;
aCC_ChartOfAccountLabel4.ExtraField2 = txtExtraField2.Text;
aCC_ChartOfAccountLabel4.ExtraField3 = ddlACC_HeadType.SelectedValue == "10" ? (ddlCOAL3.SelectedValue == "0" ? "203" : ddlCOAL3.SelectedValue) : txtExtraField3.Text;
aCC_ChartOfAccountLabel4.AddedBy = getLogin().LoginID;
aCC_ChartOfAccountLabel4.AddedDate = DateTime.Now;
aCC_ChartOfAccountLabel4.UpdatedBy = getLogin().LoginID;
aCC_ChartOfAccountLabel4.UpdatedDate = DateTime.Now;
aCC_ChartOfAccountLabel4.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
int resutl = ACC_ChartOfAccountLabel4Manager.InsertACC_ChartOfAccountLabel4(aCC_ChartOfAccountLabel4);
showACC_ChartOfAccountLabel4Grid();
btnClear_Click(this, new EventArgs());
}
private void loadACC_ChartOfAccountLabel4()
{
List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4s = new List <ACC_ChartOfAccountLabel4>();
aCC_ChartOfAccountLabel4s = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4sForJournalEntry();
ddlSuppier.Items.Add(new ListItem("Select Supplier", "0"));
ddlProduct.Items.Add(new ListItem("Any Product", "0"));
foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_HeadTypeID.ToString() + "@" + aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 2 || //2=fabric
aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 9 ||//9=accessories(productive)
aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 10) //10=accessories(non productive)
{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_HeadTypeID + "@" + aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
if (aCC_ChartOfAccountLabel4.ExtraField1 != "")
{
ddlRawMaterialAll.Items.Add(item);
}
}
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 6)
{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlSuppier.Items.Add(item);
}
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 3)
{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlProduct.Items.Add(item);
}
}
rbtnlRawmaterialsType_SelectedIndexChanged(this, new EventArgs());
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 = new ACC_ChartOfAccountLabel4();
aCC_ChartOfAccountLabel4 = ACC_ChartOfAccountLabel4Manager.GetACC_ChartOfAccountLabel4ByID(Int32.Parse(Request.QueryString["aCC_ChartOfAccountLabel4ID"]));
ACC_ChartOfAccountLabel4 tempACC_ChartOfAccountLabel4 = new ACC_ChartOfAccountLabel4();
tempACC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID = aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID;
tempACC_ChartOfAccountLabel4.Code = txtCode.Text;
tempACC_ChartOfAccountLabel4.ACC_HeadTypeID = Int32.Parse(ddlACC_HeadType.SelectedValue);
tempACC_ChartOfAccountLabel4.ChartOfAccountLabel4Text = txtChartOfAccountLabel4Text.Text;
tempACC_ChartOfAccountLabel4.ExtraField1 = txtExtraField1.Text;
tempACC_ChartOfAccountLabel4.ExtraField2 = txtExtraField2.Text;
tempACC_ChartOfAccountLabel4.ExtraField3 = txtExtraField3.Text;
tempACC_ChartOfAccountLabel4.AddedBy = Int32.Parse(txtAddedBy.Text);
tempACC_ChartOfAccountLabel4.AddedDate = DateTime.Now;
tempACC_ChartOfAccountLabel4.UpdatedBy = Int32.Parse(txtUpdatedBy.Text);
tempACC_ChartOfAccountLabel4.UpdatedDate = DateTime.Now;
tempACC_ChartOfAccountLabel4.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
bool result = ACC_ChartOfAccountLabel4Manager.UpdateACC_ChartOfAccountLabel4(tempACC_ChartOfAccountLabel4);
Response.Redirect("AdminACC_ChartOfAccountLabel4Display.aspx");
}
protected void btnLoadNewlyAddedRawmaterials_Click(object sender, EventArgs e)
{
List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4s = new List <ACC_ChartOfAccountLabel4>();
aCC_ChartOfAccountLabel4s = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4sForJournalEntry();
foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_HeadTypeID.ToString() + "@" + aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 2 || //2=fabric
aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 9 ||//9=accessories(productive)
aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 10) //10=accessories(non productive)
{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_HeadTypeID + "@" + aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
if (aCC_ChartOfAccountLabel4.ExtraField1 != "")
{
ddlRawMaterialAll.Items.Add(item);
}
}
}
rbtnlRawmaterialsType_SelectedIndexChanged(this, new EventArgs());
}
private void loadACC_ChartOfAccountLabel4()
{
List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4s = new List <ACC_ChartOfAccountLabel4>();
aCC_ChartOfAccountLabel4s = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4sForJournalEntry();
ddlProduct.Items.Add(new ListItem("Any Product", "0"));
ddlWorkStation.Items.Add(new ListItem("Select WorkStation", "0"));
foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_HeadTypeID.ToString() + "@" + aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 3)
{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlProduct.Items.Add(item);
}
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 1
&&
(
aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.Contains("Head")
||
aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.Contains("Show")
)
)
{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlWorkStation.Items.Add(item);
}
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 1
&&
(
aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.Contains("Head")
||
aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.Contains("Show")
)
)
{
//if (aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.Contains("Show"))
//{
item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlWorkStationSearch.Items.Add(item);
//}
}
}
if (int.Parse(Request.QueryString["TransactionTypeID"]) != 0)
{
if (getLogin().ExtraField5 != "1")
{
ddlWorkStationSearch.SelectedValue = getLogin().ExtraField5;
ddlWorkStationSearch.Enabled = false;
}
else
{
ddlWorkStationSearch.Enabled = true;
}
}
else
{
ddlWorkStationSearch.Enabled = true;
UpdatePanel2.Visible = false;
}
}
private void loadData()
{
try
{
ACC_JournalMaster journalMaster = ACC_JournalMasterManager.GetACC_JournalMasterByID(int.Parse(Request.QueryString["JournalMasterID"]));
List <ACC_JournalDetail> journalDetails = ACC_JournalDetailManager.GetAllACC_JournalDetailByJournalMasterID(int.Parse(Request.QueryString["JournalMasterID"]));
string journalDetailsHTML = @"<table id='tblJournalDetails' class='tdBorder' border='0' cellspacing='0' cellpadding='0' style='margin:20px 0;'>
<tr style='font-weight:bold;font-size:15px;'>
<td width='100px'>
Account Code
</td>
<td width='487px'>
Account Title
</td>
<td width='80px'>
Debit
</td>
<td width='80px'>
Credit
</td>
</tr>";
decimal totalDebit = 0;
decimal totalCredit = 0;
trAddress.Visible = false;
trCheck.Visible = false;
bool defaultJournal = false;
switch (journalMaster.JournalMasterName)
{
case "1": //Receipt Voucher
lblVoucherName.Text = "RECEIPT";
lblVoucherType.Text = "RV";
lblReceivedfromOrPayto.Text = "Received from";
trAddress.Visible = true;
trCheck.Visible = true;
//generate table
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
try
{
if (journalDetail.Credit == 0)
{
journalDetailsHTML += @"<tr>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Code + @"
</td>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Text + " - " + journalDetail.ACC_ChartOfAccountLabel4Text + " (" + journalDetail.WorkStationName + @")
</td>
<td style='text-align:right;'>
" + journalDetail.Debit.ToString("0,0.00") + @"
</td>
<td style='text-align:right;'>
" + journalDetail.Credit.ToString("0,0.00") + @"
</td>
</tr>";
totalCredit += journalDetail.Credit;
totalDebit += journalDetail.Debit;
}
}
catch (Exception ex) { }
}
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
try
{
if (journalDetail.Credit != 0)
{
journalDetailsHTML += @"<tr>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Code + @"
</td>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Text + " - " + journalDetail.ACC_ChartOfAccountLabel4Text + " (" + journalDetail.WorkStationName + @")
</td>
<td style='text-align:right;'>
" + journalDetail.Debit.ToString("0,0.00") + @"
</td>
<td style='text-align:right;'>
" + journalDetail.Credit.ToString("0,0.00") + @"
</td>
</tr>";
totalCredit += journalDetail.Credit;
totalDebit += journalDetail.Debit;
}
}
catch (Exception ex) { }
}
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
if (journalDetail.Credit == 0)
{
lblChequeDate.Text = journalDetail.ExtraField1;
lblChequeNo.Text = journalDetail.ExtraField3;
try
{
lblChequeBank.Text = journalDetail.ExtraField2.Split(',')[1];
}
catch (Exception ex) { }
try
{
lblChequeBranch.Text = journalDetail.ExtraField2.Split(',')[0];
}
catch (Exception ex) { }
break;
}
}
lblJournalDetials.Text = journalDetailsHTML + "<tr><td></td><td><b>Total:</b></td><td style='text-align:right;'>" + totalDebit.ToString("0,0.00") + "</td><td style='text-align:right;'>" + totalCredit.ToString("0,0.00") + "</td></tr><tr><td colspan='4'><b>Taka in words:</b> " + NumberToWords(int.Parse(totalCredit.ToString("0"))) + " taka only.</td></tr></table>";
break;
case "2": //Payment Voucher
lblVoucherName.Text = "PAYMENT";
lblVoucherType.Text = "PV";
lblReceivedfromOrPayto.Text = "Pay To";
trAddress.Visible = true;
trCheck.Visible = true;
//generate table
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
try
{
if (journalDetail.Credit == 0)
{
journalDetailsHTML += @"<tr>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Code + @"
</td>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Text + " - " + journalDetail.ACC_ChartOfAccountLabel4Text + " (" + journalDetail.WorkStationName + @")
</td>
<td style='text-align:right;'>
" + journalDetail.Debit.ToString("0,0.00") + @"
</td>
<td style='text-align:right;'>
" + journalDetail.Credit.ToString("0,0.00") + @"
</td>
</tr>";
totalCredit += journalDetail.Credit;
totalDebit += journalDetail.Debit;
}
}
catch (Exception ex) { }
}
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
try
{
if (journalDetail.Credit != 0)
{
journalDetailsHTML += @"<tr>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Code + @"
</td>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Text + " - " + journalDetail.ACC_ChartOfAccountLabel4Text + " (" + journalDetail.WorkStationName + @")
</td>
<td style='text-align:right;'>
" + journalDetail.Debit.ToString("0,0.00") + @"
</td>
<td style='text-align:right;'>
" + journalDetail.Credit.ToString("0,0.00") + @"
</td>
</tr>";
totalCredit += journalDetail.Credit;
totalDebit += journalDetail.Debit;
}
}
catch (Exception ex) { }
}
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
if (journalDetail.Debit == 0)
{
lblChequeDate.Text = journalDetail.ExtraField1;
lblChequeNo.Text = journalDetail.ExtraField3;
try
{
lblChequeBank.Text = journalDetail.ExtraField2.Split(',')[1];
}
catch (Exception ex) { }
try
{
lblChequeBranch.Text = journalDetail.ExtraField2.Split(',')[0];
}
catch (Exception ex) { }
break;
}
}
lblJournalDetials.Text = journalDetailsHTML + "<tr><td></td><td><b>Total:</b></td><td style='text-align:right;'>" + totalDebit.ToString("0,0.00") + "</td><td style='text-align:right;'>" + totalCredit.ToString("0,0.00") + "</td></tr><tr><td colspan='4'><b>Taka in words:</b> " + NumberToWords(int.Parse(totalDebit.ToString("0"))) + " taka only.</td></tr></table>";
break;
case "3": //Journal Voucher
lblVoucherName.Text = "JOURNAL";
lblVoucherType.Text = "JV";
defaultJournal = true;
break;
case "4": //Contra Voucher
lblVoucherName.Text = "CONTRA";
lblVoucherType.Text = "CV";
trCheck.Visible = true;
defaultJournal = true;
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
if (journalDetail.ExtraField3 != "")
{
lblChequeDate.Text = journalDetail.ExtraField1;
lblChequeNo.Text = journalDetail.ExtraField3;
try
{
lblChequeBank.Text = journalDetail.ExtraField2.Split(',')[1];
}
catch (Exception ex) { }
try
{
lblChequeBranch.Text = journalDetail.ExtraField2.Split(',')[0];
}
catch (Exception ex) { }
break;
}
}
break;
default:
break;
}
if (defaultJournal)
{
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
try
{
journalDetailsHTML += @"<tr>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Code + @"
</td>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Text + " - " + journalDetail.ACC_ChartOfAccountLabel4Text + " (" + journalDetail.WorkStationName + @")
</td>
<td style='text-align:right;'>
" + journalDetail.Debit.ToString("0,0.00") + @"
</td>
<td style='text-align:right;'>
" + journalDetail.Credit.ToString("0,0.00") + @"
</td>
</tr>";
totalCredit += journalDetail.Credit;
totalDebit += journalDetail.Debit;
}
catch (Exception ex) { }
}
lblJournalDetials.Text = journalDetailsHTML + "<tr><td></td><td><b>Total:</b></td><td style='text-align:right;'>" + totalDebit.ToString("0,0.00") + "</td><td style='text-align:right;'>" + totalCredit.ToString("0,0.00") + "</td></tr><tr><td colspan='4'><b>Taka in words:</b> " + NumberToWords(int.Parse(totalCredit.ToString("0"))) + " taka only.</td></tr></table>";
}
lblOfficeName.Text = journalDetails[0].WorkStationName;
lblJournalMasterID.Text = Request.QueryString["JournalMasterID"];
if (journalMaster.RowStatusID != 1)
{
lblJournalMasterID.BackColor = System.Drawing.Color.Red;
}
lblDate.Text = journalMaster.JournalDate.ToString("dd MMM yyyy");
lblCustomerName.Text = journalMaster.ExtraField1;
lblAddress.Text = journalMaster.ExtraField2;
if (journalMaster.Note.Contains("Inventory Purchase-"))
{
lblExplanation.Text = "<a href='../Inventory/PurchasePrint.aspx?PurchaseID=" + journalMaster.Note.Replace("Inventory Purchase-", "") + "' target='_blank'>" + journalMaster.Note + "</a>";
}
else
{
lblExplanation.Text = journalMaster.Note;
}
gvJournal.DataSource = journalDetails;
gvJournal.DataBind();
List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4s = new List <ACC_ChartOfAccountLabel4>();
aCC_ChartOfAccountLabel4s = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4sForJournalEntry();
DataSet ds = CommonManager.SQLExec(
@"
SELECT
ACC_ChartOfAccountLabel3.ChartOfAccountLabel3Text +'('+ ACC_ChartOfAccountLabel2.ChartOfAccountLabel2Text +')('+
ACC_ChartOfAccountLabel1.ChartOfAccountLabel1Text+')' as Head,
ACC_ChartOfAccountLabel3.ACC_ChartOfAccountLabel3ID
FROM ACC_ChartOfAccountLabel1 INNER JOIN
ACC_ChartOfAccountLabel2 ON
ACC_ChartOfAccountLabel1.ACC_ChartOfAccountLabel1ID = ACC_ChartOfAccountLabel2.ACC_ChartOfAccountLabel1ID INNER JOIN
ACC_ChartOfAccountLabel3 ON ACC_ChartOfAccountLabel2.ACC_ChartOfAccountLabel2ID = ACC_ChartOfAccountLabel3.ACC_ChartOfAccountLabel2ID
where ACC_ChartOfAccountLabel3.RowStatusID=1
order by ACC_ChartOfAccountLabel1.ChartOfAccountLabel1Text,ACC_ChartOfAccountLabel2.ChartOfAccountLabel2Text,ACC_ChartOfAccountLabel3.ChartOfAccountLabel3Text
"
);
ddlL4.Items.Clear();
ddlL3.Items.Clear();
ddlWorkStation.Items.Clear();
ddlL4.Items.Add(new ListItem("N/A", "0"));
ddlL3.Items.Add(new ListItem("N/A", "0"));
ddlWorkStation.Items.Add(new ListItem("N/A", "0"));
foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s)
{
ddlL4.Items.Add(new ListItem(
(
aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 9
? "Access(Prod)" :
(
aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 10
? "Access (Non-Prod)" :
(
aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 2
? "Fabrics" :
(
aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 3
? "Product" : aCC_ChartOfAccountLabel4.ACC_HeadTypeID.ToString()
)
)
)
)
+ "-" + aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString()));
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 1)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlWorkStation.Items.Add(item);
}
}
foreach (DataRow dr in ds.Tables[0].Rows)
{
ddlL3.Items.Add(new ListItem(dr["Head"].ToString(), dr["ACC_ChartOfAccountLabel3ID"].ToString()));
}
/*
* //List<ACC_ChartOfAccountLabel3> aCC_ChartOfAccountLabel3s = new List<ACC_ChartOfAccountLabel3>();
* //aCC_ChartOfAccountLabel3s = ACC_ChartOfAccountLabel3Manager.GetAllACC_ChartOfAccountLabel3sForJournalEntryForDropDownList();
*
* foreach (GridViewRow gvr in gvJournal.Rows)
* {
* HiddenField hfWorkStationID = (HiddenField)gvr.FindControl("hfWorkStationID");
* HiddenField hfACC_ChartOfAccountLabel4ID = (HiddenField)gvr.FindControl("hfACC_ChartOfAccountLabel4ID");
* HiddenField hfACC_ChartOfAccountLabel3ID = (HiddenField)gvr.FindControl("hfACC_ChartOfAccountLabel3ID");
* DropDownList ddlWorkStation = (DropDownList)gvr.FindControl("ddlWorkStation");
* DropDownList ddlL3 = (DropDownList)gvr.FindControl("ddlL3");
* DropDownList ddlL4 = (DropDownList)gvr.FindControl("ddlL4");
* foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s)
* {
* ddlL4.Items.Add(new ListItem(
* (
* aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 9
* ? "Access(Prod)" :
* (
* aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 10
* ? "Access (Non-Prod)" :
* (
* aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 2
* ? "Fabrics" : aCC_ChartOfAccountLabel4.ACC_HeadTypeID.ToString()
* )
* )
* )
+ "-" + aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString()));
+ if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 1)
+ {
+ ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
+ ddlWorkStation.Items.Add(item);
+ }
+ }
+ foreach (DataRow dr in ds.Tables[0].Rows)
+ {
+ ddlL3.Items.Add(new ListItem(dr["Head"].ToString(), dr["ACC_ChartOfAccountLabel3ID"].ToString()));
+ }
+
+ ddlL4.SelectedValue = hfACC_ChartOfAccountLabel4ID.Value;
+ ddlL3.SelectedValue = hfACC_ChartOfAccountLabel3ID.Value;
+ ddlWorkStation.SelectedValue = hfWorkStationID.Value;
+ }
*/
}
catch (Exception ex)
{ }
}
private void showACC_ChartOfAccountLabel4Grid()
{
gvACC_ChartOfAccountLabel4.DataSource = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4s();
gvACC_ChartOfAccountLabel4.DataBind();
}
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);
}
}
}
