public int InsertmTermsCondition(mTermsCondition term, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ce.mTermsConditions.AddObject(term);
ce.SaveChanges();
return(1);
}
public int updatemTermsCondition(mTermsCondition updateTerm, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ce.mTermsConditions.Attach(updateTerm);
ce.ObjectStateManager.ChangeObjectState(updateTerm, EntityState.Modified);
ce.SaveChanges();
return(1);
}
/// <summary>
/// GetTermConditionListByID is providing List of TermCondition By ID
/// </summary>
/// <returns></returns>
///
public mTermsCondition GetTermConditionListByID(int termId, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
mTermsCondition DesignationID = new mTermsCondition();
DesignationID = (from p in ce.mTermsConditions
where p.ID == termId
select p).FirstOrDefault();
ce.Detach(DesignationID);
return(DesignationID);
}
protected void pageSave(Object sender, ToolbarService.iUCToolbarClient e)
{
iTermConditionMasterClient TermsClient = new iTermConditionMasterClient();
try
{
CustomProfile profile = CustomProfile.GetProfile();
mTermsCondition objTerms = new mTermsCondition();
if (hdnTermID.Value == string.Empty)
{
if (chkBLstGroupname.SelectedIndex >= 0)
{
for (int i = 0; i <= chkBLstGroupname.Items.Count - 1; i++)
{
if (chkBLstGroupname.Items[i].Selected == true)
{
objTerms.Term = txtTermName.Text.Trim();
objTerms.Condition = txtCondition.Text;
objTerms.TCGroupID = Convert.ToInt64(chkBLstGroupname.Items[i].Value);
objTerms.Sequence = 0;
if (rbtnYes.Checked == true)
{
objTerms.Active = "Y";
}
else
{
objTerms.Active = "N";
}
objTerms.CreatedBy = profile.Personal.UserID.ToString();
objTerms.CreationDate = DateTime.Now;
objTerms.CompanyID = profile.Personal.CompanyID;
objTerms.CompanyID = long.Parse(ddlCompany.SelectedItem.Value);
objTerms.CustomerID = long.Parse(hdncustomerid.Value);
int result = TermsClient.InsertmTermsCondition(objTerms, profile.DBConnection._constr);
}
}
WebMsgBox.MsgBox.Show("Record saved successfully");
BindGrid();
clear();
}
else
{
WebMsgBox.MsgBox.Show("Please select Group");
}
}
else
{
if (chkBLstGroupname.SelectedIndex >= 0)
{
for (int i = 0; i <= chkBLstGroupname.Items.Count - 1; i++)
{
if (chkBLstGroupname.Items[i].Selected == true)
{
objTerms = TermsClient.GetTermConditionListByID(Convert.ToInt32(hdnTermID.Value), profile.DBConnection._constr);
objTerms.Term = txtTermName.Text.Trim();
objTerms.Condition = txtCondition.Text;
objTerms.TCGroupID = Convert.ToInt64(chkBLstGroupname.Items[i].Value);
objTerms.Sequence = 0;
if (rbtnYes.Checked == true)
{
objTerms.Active = "Y";
}
else
{
objTerms.Active = "N";
}
objTerms.LastModifiedBy = profile.Personal.UserID.ToString();
objTerms.LastModifiedDate = DateTime.Now;
objTerms.CompanyID = long.Parse(ddlCompany.SelectedItem.Value);
int result = TermsClient.updatemTermsCondition(objTerms, profile.DBConnection._constr);
}
}
WebMsgBox.MsgBox.Show("Record updated successfully");
BindGrid();
clear();
}
else
{
WebMsgBox.MsgBox.Show("Please select Group");
}
}
}
//}
catch (System.Exception ex)
{
Login.Profile.ErrorHandling(ex, this, "Terms & Conditions Master", "pageSave");
}
finally
{
}
}
