public int InsertmTaxSetup(mTaxSetup tax, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ce.mTaxSetups.AddObject(tax);
ce.SaveChanges();
return(1);
}
public int updatemTaxSetup(mTaxSetup updateTax, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ce.mTaxSetups.Attach(updateTax);
ce.ObjectStateManager.ChangeObjectState(updateTax, EntityState.Modified);
ce.SaveChanges();
return(1);
}
/// <summary>
/// GetTaxListByID is providing List of Tax By ID
/// </summary>
/// <returns></returns>
///
public mTaxSetup GetTaxListByID(int taxId, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
mTaxSetup TaxID = new mTaxSetup();
TaxID = (from p in ce.mTaxSetups
where p.ID == taxId
select p).FirstOrDefault();
ce.Detach(TaxID);
return(TaxID);
}
protected void pageSave(Object sender, ToolbarService.iUCToolbarClient e)
{
if (checkDuplicate() == "")
{
try
{
CustomProfile profile = CustomProfile.GetProfile();
mTaxSetup ObjTax = new mTaxSetup();
if (hdnTaxID.Value == string.Empty)
{
if (ddlTaxType.SelectedValue == "Tax On Tax" && hdnTaxIDs.Value.ToString() == "")
{
WebMsgBox.MsgBox.Show("Please select Tax from list for Tax on Principal"); ddlTaxType.SelectedIndex = 0;
}
else
{
ObjTax.Name = txtTaxName.Text;
ObjTax.Description = txtDescription.Text;
ObjTax.Type = ddlTaxType.SelectedValue;
if (txtSequence.Text != string.Empty)
{
ObjTax.Sequence = Convert.ToInt64(txtSequence.Text);
}
else
{
ObjTax.Sequence = 0;
}
if (rbtnYes.Checked == true)
{
ObjTax.Active = "Y";
}
else
{
ObjTax.Active = "N";
}
ObjTax.CreatedBy = profile.Personal.UserID.ToString();
ObjTax.CreatedDate = DateTime.Now;
ObjTax.Percent = Convert.ToDecimal(txtTaxPercent.Text);
ObjTax.TaxMappingID = hdnTaxIDs.Value.ToString();
// ObjTax.CompanyID = profile.Personal.CompanyID;
ObjTax.CompanyID = long.Parse(ddlcompanymain.SelectedItem.Value);
ObjTax.CustomerID = long.Parse(hdncustomerid.Value);
int result = TaxClient.InsertmTaxSetup(ObjTax, profile.DBConnection._constr);
if (result == 1)
{
WebMsgBox.MsgBox.Show("Record saved successfully");
}
BindGrid();
clear();
}
}
else
{
ObjTax = TaxClient.GetTaxListByID(Convert.ToInt32(hdnTaxID.Value), profile.DBConnection._constr);
ObjTax.Name = txtTaxName.Text;
ObjTax.Description = txtDescription.Text;
ObjTax.Type = ddlTaxType.SelectedValue;
if (txtSequence.Text != string.Empty)
{
ObjTax.Sequence = Convert.ToInt64(txtSequence.Text);
}
else
{
ObjTax.Sequence = 0;
}
if (rbtnYes.Checked == true)
{
ObjTax.Active = "Y";
}
else
{
ObjTax.Active = "N";
}
ObjTax.LastEditBy = profile.Personal.UserID.ToString();
ObjTax.Description = txtDescription.Text;
ObjTax.LastEditDate = DateTime.Now;
ObjTax.Percent = Convert.ToDecimal(txtTaxPercent.Text);
ObjTax.CustomerID = long.Parse(hdncustomerid.Value);
int result = TaxClient.updatemTaxSetup(ObjTax, profile.DBConnection._constr);
if (result == 1)
{
WebMsgBox.MsgBox.Show("Record updated successfully");
}
BindGrid();
clear();
}
//}
}
catch (System.Exception ex)
{
Login.Profile.ErrorHandling(ex, this, "Tax Master", "pageSave");
}
finally
{
}
}
}
