protected string GetMajorAccounts(int mjid)
{
List <MajorAccounttbl> lstMajor = new List <MajorAccounttbl>();
MajorAccounttbl MC = new MajorAccounttbl();
MajorAccountBL objMajorAccountBL = new MajorAccountBL();
MC.Status = 1;
lstMajor = objMajorAccountBL.GetAccountsByStatus(MC).ToList();
ListItem ma = new ListItem();
ma.Text = "--Select--";
ma.Value = 0.ToString();
ddlMAccountList.Items.Add(ma);
foreach (var mt in lstMajor)
{
ListItem lb = new ListItem();
lb.Text = mt.MajorAccountName;
lb.Value = mt.MajorAccountID.ToString();
ddlMAccountList.Items.Add(lb);
}
var major = lstMajor.OfType <MajorAccounttbl>().Where(a => a.MajorAccountID == mjid);
//return major.First().MajorAccountName;
return(major.Count() > 0 ? major.First().MajorAccountName : "");
}
protected void GetAccounts()
{
MajorAccounttbl ma = new MajorAccounttbl();
List <MajorAccounttbl> lst = new List <MajorAccounttbl>();
lst = objAccountBL.GetAllAccounts(ma).ToList();
gdvAccount.DataSource = lst;
gdvAccount.DataBind();
btnSave.Visible = true;
btnUpdate.Visible = false;
}
protected string GetMajorAccounts(int mjid)
{
List <MajorAccounttbl> lstMajor = new List <MajorAccounttbl>();
MajorAccounttbl MC = new MajorAccounttbl();
MajorAccountBL objMajorAccountBL = new MajorAccountBL();
lstMajor = objMajorAccountBL.GetAllAccounts(MC).ToList();
var major = lstMajor.OfType <MajorAccounttbl>().Where(c => c.MajorAccountID == mjid);
//return major.First().MajorAccountName;
return(major.Count() > 0 ? major.First().MajorAccountName : "");
}
protected void InsertAccounts()
{
MajorAccounttbl ma = new MajorAccounttbl();
ma.MajorAccountName = TxtMAName.Text;
// dr["UserID"] == DBNull.Value ? 0 : Convert.ToInt32(dr["UserID"]),
ma.MajorAccountCode = txtMACode.Text == ""? 0 : Convert.ToInt32(txtMACode.Text);
// ma.Status = 1;
ma.CreatedBy = 1;
ma.CreatedDate = DateTime.Now.ToString();
ma.UpdatedBy = 1;
ma.UpdatedDate = DateTime.Now.ToString();
lma = objAccountBL.InsertAccounts(ma).ToList();
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "alertMessage('Data Inserted Successfully');", true);
btnSave.Visible = true;
GetAccounts();
Reset();
}
protected void GetAccountsById(int id)
{
MajorAccounttbl ma = new MajorAccounttbl();
ma.MajorAccountID = Convert.ToInt32(id.ToString());
List <MajorAccounttbl> lma = new List <MajorAccounttbl>();
lma = objAccountBL.GetAccountsbyId(ma).ToList();
foreach (var el in lma)
{
hdnMajorAccountID.Value = Convert.ToString(el.MajorAccountID);
hdnStatus.Value = el.Status.ToString();
TxtMAName.Text = el.MajorAccountName;
txtMACode.Text = el.MajorAccountCode.ToString();
}
btnSave.Visible = false;
btnUpdate.Visible = true;
}
protected void lbtnLMarkAsActive_Click(object sender, EventArgs e)
{
LinkButton lbtn = (LinkButton)sender;
GridViewRow gvr = (GridViewRow)lbtn.NamingContainer;
var val = gvr.DataItemIndex;
var id = gvr.Cells[3].Text;
MajorAccounttbl ma = new MajorAccounttbl();
ma.MajorAccountID = Convert.ToInt32(gvr.Cells[0].Text);
if (id == "Active")
{
ma.Status = 0;
}
else if (id == "InActive")
{
ma.Status = 1;
}
objAccountBL.UpdateAccountIsActive(ma);
GetAccounts();
}
protected void GetMajorAccounts()
{
List <MajorAccounttbl> lstMajor = new List <MajorAccounttbl>();
MajorAccounttbl MC = new MajorAccounttbl();
MajorAccountBL objMajorAccountBL = new MajorAccountBL();
MC.Status = 1;
lstMajor = objMajorAccountBL.GetAccountsByStatus(MC).ToList();
ListItem ma = new ListItem();
ma.Text = "--Select--";
ma.Value = 0.ToString();
ddlMAccountList.Items.Add(ma);
foreach (var mt in lstMajor)
{
ListItem lb = new ListItem();
lb.Text = mt.MajorAccountName;
lb.Value = mt.MajorAccountID.ToString();
ddlMAccountList.Items.Add(lb);
}
}
protected void GetAllAccounts()
{
MajorAccounttbl matl = new MajorAccounttbl();
MajorAccountBL objMajorAccountBL = new MajorAccountBL();
//matl.Status = 1;
lstMajorAccount = objMajorAccountBL.GetAllAccounts(matl).ToList();
DdlMajorAccount.Items.Clear();
ListItem l = new ListItem();
l.Text = "--Select--";
l.Value = 0.ToString();
DdlMajorAccount.Items.Add(l);
foreach (var cnt in lstMajorAccount)
{
ListItem li = new ListItem();
li.Text = cnt.MajorAccountName.ToString();
li.Value = cnt.MajorAccountID.ToString();
DdlMajorAccount.Items.Add(li);
}
}
protected void updateAccounts()
{
MajorAccounttbl ma = new MajorAccounttbl();
ma.MajorAccountID = Convert.ToInt32(hdnMajorAccountID.Value);
ma.MajorAccountName = TxtMAName.Text;
ma.MajorAccountCode = Convert.ToInt32(txtMACode.Text);
ma.Status = Convert.ToInt32(hdnStatus.Value);
ma.CreatedBy = 1;
ma.CreatedDate = DateTime.Now.ToString();
ma.UpdatedBy = 1;
ma.UpdatedDate = DateTime.Now.ToString();
lma = objAccountBL.UpdateAccounts(ma).ToList();
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "alertMessage('Accounts Updated Successfully');", true);
GetAccounts();
Reset();
btnUpdate.Visible = false;
btnSave.Visible = true;
}
public IEnumerable <MajorAccounttbl> GetAccountsByStatus(MajorAccounttbl ma)
{
return(objAccountsDA.MajorAccountAll(7, ma));
}
public IEnumerable <MajorAccounttbl> UpdateAccountIsActive(MajorAccounttbl ma)
{
return(objAccountsDA.MajorAccountAll(6, ma));
}
public IEnumerable <MajorAccounttbl> DeleteAccounts(MajorAccounttbl ma)
{
return(objAccountsDA.MajorAccountAll(5, ma));
}
public IEnumerable <MajorAccounttbl> UpdateAccounts(MajorAccounttbl ma)
{
return(objAccountsDA.MajorAccountAll(4, ma));
}
public IEnumerable <MajorAccounttbl> InsertAccounts(MajorAccounttbl ma)
{
return(objAccountsDA.MajorAccountAll(3, ma));
}
public IEnumerable <MajorAccounttbl> GetAccountsbyId(MajorAccounttbl ma)
{
return(objAccountsDA.MajorAccountAll(2, ma));
}
public IEnumerable <MajorAccounttbl> GetAllAccounts(MajorAccounttbl ma)
{
return(objAccountsDA.MajorAccountAll(1, ma));
}
