public void InsertGWCApprovalDetails(mApprovalLevelDetail ApprovalDetails, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
try
{
ce.mApprovalLevelDetails.AddObject(ApprovalDetails);
ce.SaveChanges();
}
catch { }
}
protected void gvUserCreation_OnRebind(object sender, EventArgs e)
{
iApprovalLevelMasterClient ApprovalClient = new iApprovalLevelMasterClient();
CustomProfile profile = CustomProfile.GetProfile();
try
{
string insertgata = Session["InsertData"].ToString();
if (hdnStatus.Value == "Edit" && Session["InsertData"].ToString() == "")
{
//List<vGWCGetApprovalDetailsForEdit> getlst = new List<vGWCGetApprovalDetailsForEdit>();
//DataSet ds = new DataSet();
gvUserCreation.DataSource = ApprovalClient.GWCGetApprovalDetailsForEdit(Convert.ToInt64(hdnApprovalID.Value), profile.DBConnection._constr);
//getlst = ApprovalClient.GWCGetApprovalDetailsForEdit(Convert.ToInt64(hdnApprovalID.Value), profile.DBConnection._constr).ToList();
//gvUserCreation.DataSource = getlst;
gvUserCreation.DataBind();
// getlst = ApprovalClient.GWCGetUserForApprovalMaster(Convert.ToInt64(hdnSelectedLevel.Value), stringss[i], profile.DBConnection._constr).ToList();
GetApproverList();
}
else if (hdnStatus.Value == "AddNew" && Hdn1.Value == "1" && Session["InsertData"].ToString() == "")
{
GetApproverList();
}
else if (Session["InsertData"].ToString() == "Insert")
{
/*Add By Suresh*/
int AvailableApprovalLevel = ApprovalClient.GetApprovalRecordByApvrlLevelID(Convert.ToInt16(hdnSelectedLevel.Value), Convert.ToInt64(hdnSelectedDepartment.Value), profile.DBConnection._constr);
if (AvailableApprovalLevel > 0)
{
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "showAlert('Approval For This Level Are Already Available','Error','#')", true);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Approval For This Level Are Already Available')", true);
}
else
{
mApprovalLevel ObjApproval = new mApprovalLevel();
ObjApproval.ObjectName = "MaterialRequest";
ObjApproval.ApprovalLevel = Convert.ToByte(hdnSelectedLevel.Value);
ObjApproval.NoOfApprovers = Convert.ToByte(txtnoapprovar.Text);
ObjApproval.Active = "Y";
ObjApproval.TerritoryID = Convert.ToInt64(hdnSelectedDepartment.Value);
ObjApproval.MinApprovalReq = 0;
ObjApproval.MinApprovalReq = 0;
ObjApproval.MaxAmount = 0;
ObjApproval.IsLowerLevelApprovalReq = true;
if (hdnSelectedDepartment.Value != "" || hdnSelectedDepartment.Value != "0")
{
ObjApproval.OrderCancelInDays = ApprovalClient.GetCancelDays(Convert.ToInt64(hdnSelectedDepartment.Value), profile.DBConnection._constr);
}
int result = 0;
//if (hdnStatus.Value != "Edit")
//{
ObjApproval.CreatedBy = profile.Personal.UserID.ToString();
ObjApproval.CreationDate = DateTime.Now;
result = ApprovalClient.InsertmApprovalLevel(ObjApproval, profile.DBConnection._constr);
// ObjApprovalDetail.ApprovalLevelID = result;
// ApprovalClient.UpdateApprovallevelID(result, profile.DBConnection._constr);
if (result != 0)
{
// WebMsgBox.MsgBox.Show("Record saved successfully");
}
//}
//else if (hdnStatus.Value == "Edit")
//{
// ObjApproval.LastModifiedBy = profile.Personal.UserID.ToString();
// ObjApproval.LastModifiedDate = DateTime.Now;
// result= Convert.ToInt32(hdnApprovalID.Value);
//}
/*Add By Suresh*/
mApprovalLevelDetail ObjApprovalDetail = new mApprovalLevelDetail();
string[] stringss = new string[] { };
hdnUserIDs.Value = Session["Userlist"].ToString();
stringss = hdnUserIDs.Value.Split(',');
ObjApprovalDetail.ApprovalLevelID = result; //ObjApprovalDetail.ApprovalLevelID = 0;
ObjApprovalDetail.Active = "Y";
ObjApprovalDetail.CreatedBy = profile.Personal.UserID.ToString();
ObjApprovalDetail.CreationDate = DateTime.Now;
ObjApprovalDetail.CompanyID = Convert.ToInt64(hdnSelectedCompany.Value);
ObjApprovalDetail.DepartmentID = Convert.ToInt64(hdnSelectedDepartment.Value);
if (chkand.Checked == true)
{
ObjApprovalDetail.ApproverLogic = "AND";
}
else
{
ObjApprovalDetail.ApproverLogic = "OR";
}
for (int i = 0; i < stringss.Length; i++)
{
ObjApprovalDetail.UserID = Convert.ToInt64(stringss[i].ToString());
ApprovalClient.InsertGWCApprovalDetails(ObjApprovalDetail, profile.DBConnection._constr);
}
}
GetApproverList();
Session["InsertData"] = "";
}
}
catch (System.Exception ex)
{
Login.Profile.ErrorHandling(ex, "Approval Level Master", "gvUserCreation_OnRebind");
}
finally {
ApprovalClient.Close();
}
}
/// <summary>
/// Save SaveApprovalLevelDetail To DataBase
/// </summary>
/// <param name="paraObjectName"></param>
/// <param name="paraReferenceIDs"></param>
/// <param name="paraInput"></param>
/// <param name="paraUserID"></param>
/// <returns></returns>
public bool SaveApprovalLevelDetail(string paraUserIDs, long paraApprovalLevelID, mApprovalLevelDetail paraInput, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
bool result = false;
try
{
string[] strings = new string[] { };
strings = paraUserIDs.Split(',');
long[] arrayIDs = strings.Select(x => long.Parse(x)).ToArray();
List <mApprovalLevelDetail> objtApprovalDetail = new List <mApprovalLevelDetail>();
var ListofID = from a in arrayIDs.AsEnumerable()
select new { NewID = a };
XElement xmlApprovalDetail = new XElement("ApprovalDetailList", from a in ListofID
join m in objtApprovalDetail on a.NewID equals m.UserID into newTaskList
from newList in newTaskList.DefaultIfEmpty()
select new XElement("ApprovalList",
new XElement("ApprovalLevelID", paraInput.ApprovalLevelID),
new XElement("UserID", a.NewID),
new XElement("Active", paraInput.Active == null ? "Y" : paraInput.Active),
new XElement("CreatedBy", paraInput.CreatedBy == null ? "Admin" : paraInput.CreatedBy),
new XElement("CreationDate", paraInput.CreationDate == null ? DateTime.Now : paraInput.CreationDate),
new XElement("LastModifiedBy", paraInput.LastModifiedBy == null ? null : paraInput.LastModifiedBy),
new XElement("LastModifiedDate", paraInput.LastModifiedDate == null ? null : paraInput.LastModifiedDate),
new XElement("CompanyID", paraInput.CompanyID)
));
ObjectParameter _paraXML = new ObjectParameter("xmlData", typeof(string));
_paraXML.Value = xmlApprovalDetail.ToString();
ObjectParameter _paraApprovalLevelID = new ObjectParameter("paraApprovalLevelID", typeof(long));
_paraApprovalLevelID.Value = paraApprovalLevelID;
//ObjectParameter _paraUserIDs = new ObjectParameter("paraUserIDs", typeof(string));
//_paraUserIDs.Value = paraUserIDs;
ObjectParameter[] obj = new ObjectParameter[] { _paraXML, _paraApprovalLevelID };
ce.ExecuteFunction("SP_InsetIntoApprovalLevelDetail", obj);
ce.SaveChanges();
result = true;
}
catch (Exception ex)
{
result = false;
// uc.ErrorTracking(ex, UserID, ConnectionStr);
}
return(result);
}
