//gvUserCreation.DataSource = null;
//List<SP_GWCGetUserForApprovalMaster_Result> getlst = new List<SP_GWCGetUserForApprovalMaster_Result>();
//if (hdnUserIDs.Value != "" || hdnUserIDs.Value != "0")
//{
// getlst = ApprovalClient.GWCGetUserForApprovalMaster(Convert.ToInt64(hdnSelectedLevel.Value), hdnUserIDs.Value, profile.DBConnection._constr).ToList();
// gvUserCreation.DataSource = getlst;
// gvUserCreation.DataBind();
//}
public void GetApproverList()
{
iApprovalLevelMasterClient ApprovalClient = new iApprovalLevelMasterClient();
try
{
CustomProfile profile = CustomProfile.GetProfile();
gvUserCreation.DataSource = null;
gvUserCreation.DataBind();
DataSet dsApproverList = new DataSet();
List <SP_GWCGetApproverListBySp_Result> getlst = new List <SP_GWCGetApproverListBySp_Result>();
//if (hdnStatus.Value == "AddNew")
//{
// getlst = ApprovalClient.GetApproverListBySp(Convert.ToInt64(hdnSelectedLevel.Value), profile.DBConnection._constr).ToList();
getlst = ApprovalClient.GetApproverListBySp(Convert.ToInt64(hdnSelectedDepartment.Value), profile.DBConnection._constr).ToList();
dsApproverList = ApprovalClient.GetApproverList(profile.DBConnection._constr);
// gvUserCreation.DataSource = dsApproverList;
gvUserCreation.DataSource = getlst;
gvUserCreation.DataBind();
//}
//else
//{
// gvUserCreation.DataSource = ApprovalClient.GWCGetApprovalDetailForEditWithZero(Convert.ToInt64(hdnApprovalID.Value), profile.DBConnection._constr);
// gvUserCreation.DataBind();
//}
}
catch (System.Exception ex)
{
Login.Profile.ErrorHandling(ex, "Approval Level Master", "GetApproverList");
}
finally
{
ApprovalClient.Close();
}
}
public void DeleteZeroDetailaproval()
{
iApprovalLevelMasterClient ApprovalClient = new iApprovalLevelMasterClient();
CustomProfile profile = CustomProfile.GetProfile();
ApprovalClient.DeleteZeroDetailaproval(profile.DBConnection._constr);
}
public static void WMRemoveUserFromUserList(string ID)
{
iApprovalLevelMasterClient ApprovalClient = new iApprovalLevelMasterClient();
CustomProfile profile = CustomProfile.GetProfile();
try
{
ApprovalClient.DeleteApproverFromGrid(Convert.ToInt64(ID), profile.DBConnection._constr);
}
catch { }
finally { }
}
public static string PMGetApprovalLevelByObjectName(string objectName, long territoryID)
{
iApprovalLevelMasterClient ApprovalClient = new iApprovalLevelMasterClient();
string NewLevel = "";
try
{
CustomProfile profile = CustomProfile.GetProfile();
NewLevel = ApprovalClient.GetApprovalLevelMax(objectName, territoryID, profile.DBConnection._constr).ToString();
}
catch (System.Exception ex)
{ Login.Profile.ErrorHandling(ex, "Approval Level Master", "PMGetApprovalLevelByObjectName"); }
finally
{ ApprovalClient.Close(); }
return(NewLevel);
}
public static string PMApprovalLevel(long CompanyID, long DeptID)
{
iApprovalLevelMasterClient ApprovalClient = new iApprovalLevelMasterClient();
string AppLevel = "";
try
{
CustomProfile profile = CustomProfile.GetProfile();
AppLevel = ApprovalClient.GetApprovalLevel(CompanyID, DeptID, profile.DBConnection._constr).ToString();
}
catch (System.Exception ex)
{ Login.Profile.ErrorHandling(ex, "Approval Level Master", "PMGetApprovalLevelByObjectName"); }
finally
{ ApprovalClient.Close(); }
return(AppLevel);
}
public void GetGWCApprovalLevel(long CompanyID, long DeptID)
{
iApprovalLevelMasterClient ApprovalClient = new iApprovalLevelMasterClient();
string AppLevel = "";
try
{
CustomProfile profile = CustomProfile.GetProfile();
AppLevel = ApprovalClient.GetApprovalLevel(CompanyID, DeptID, profile.DBConnection._constr).ToString();
lblApprovalLevel.Text = AppLevel;
}
catch (System.Exception ex)
{ Login.Profile.ErrorHandling(ex, "Approval Level Master", "GetGWCApprovalLevel"); }
finally
{ ApprovalClient.Close(); }
// return AppLevel;
}
public void GetApprovalgridList()
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
iApprovalLevelMasterClient ApprovalClient = new iApprovalLevelMasterClient();
CustomProfile profile = CustomProfile.GetProfile();
ds = ApprovalClient.GetApprovalgridList(profile.DBConnection._constr);
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
gvApprovalLevelM.DataSource = ds.Tables[0];
gvApprovalLevelM.DataBind();
}
else
{
gvApprovalLevelM.DataSource = null;
gvApprovalLevelM.DataBind();
}
}
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();
}
}
