public int Update(Models.MChartOfAccounts models)
{
Common.Logger l = new Common.Logger();
string ClassName = "CChartOfAccounts";
try
{
var query = from o in obj.ChartOfAccounts where Convert.ToString(o.id) == models.id select o;
foreach (var item in query)
{
item.num = models.num;
item.name = models.name;
item.type = models.type;
item.e_date = Convert.ToDateTime(models.e_date);
}
l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + models.id + "] num[" + models.num + "] name[" + models.name + "] type[" + models.type + "] e_date[" + models.e_date + "]");
obj.SubmitChanges();
l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Updated Successfully");
return(1);
}
catch (Exception ex)
{
l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString());
return(-1);
}
}
public int Save(Models.MChartOfAccounts Models)
{
Common.Logger l = new Common.Logger();
string ClassName = "CChartOfAccounts";
try
{
DB.ChartOfAccount bs = new DB.ChartOfAccount();
bs.num = Models.num;
bs.name = Models.name;
bs.type = Models.type;
bs.e_date = Convert.ToDateTime(Models.e_date);
l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values num[" + Models.num + "] name[" + Models.name + "] type[" + Models.type + "] e_date[" + Models.e_date + "] id[ " + Models.id + "]");
obj.ChartOfAccounts.InsertOnSubmit(bs);
obj.SubmitChanges();
l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Inserted Sucessfully");
return(1);
}
catch (Exception ex)
{
l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString());
return(-1);
}
}
public List <Models.MChartOfAccounts> GetAll()
{
List <Models.MChartOfAccounts> model = new List <Models.MChartOfAccounts>();
var query = from o in obj.ChartOfAccounts select o;
foreach (var item in query)
{
Models.MChartOfAccounts m = new Models.MChartOfAccounts();
m.id = Convert.ToString(item.id);
m.num = item.num;
m.name = item.name;
m.type = item.type;
m.e_date = Convert.ToString(item.e_date);
model.Add(m);
}
return(model);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
string ChartOfAccountnum = txtAccountNumber.Text;
string ChartOfAccountname = txtAccountName.Text;
string ChartOfAccounttype = txtAccounttype.Text;
Models.MChartOfAccounts mv = new Models.MChartOfAccounts();
mv.num = ChartOfAccountnum;
mv.name = ChartOfAccountname;
mv.type = ChartOfAccounttype;
Classes.CChartOfAccounts ccv = new Classes.CChartOfAccounts();
if (ccv.Save(mv) < 0)
{
ShowFailMessage();
}
else
{
ShowSuccessMessage();
}
}
}
public int Delete(Models.MChartOfAccounts model)
{
Common.Logger l = new Common.Logger();
string ClassName = "CChartOFAccount";
try
{
var query = from o in obj.ChartOfAccounts where o.id == Convert.ToInt32(model.id) select o;
foreach (var item in query)
{
obj.ChartOfAccounts.DeleteOnSubmit(item);
}
l.Print(ClassName, Common.LogPointer.Info.ToString(), "id[" + model.id + "] num[" + model.num + "] name[" + model.name + "] type[" + model.type + "] e_date[" + model.e_date + "]");
obj.SubmitChanges();
l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Deleted Successfully");
return(1);
}
catch (Exception ex)
{
l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString());
return(-1);
}
}