public List <ProBindMenu> UserCode(ProBindMenu objParaProBindMenu)
{
List <ProBindMenu> objProBindMenu = new List <ProBindMenu> {
};
return(objProBindMenu);
}
public Boolean ConvertToFill(String ObjectName)
{
BrilliantWMS.BindMenuService.iBindMenuClient objiBindMenuClient = new BrilliantWMS.BindMenuService.iBindMenuClient();
Boolean flg = false;
try
{
CustomProfile profile = CustomProfile.GetProfile();
//objProBindMenu._constP = profile.DBConnection._constr;
objProBindMenu.CompanyCode = profile.Personal.CompanyID;
objProBindMenu.UserCode = profile.Personal.UserID;
List <ProBindMenu> objLstProBindMenu = new List <ProBindMenu> {
};
objProBindMenu.ObjectCode = ObjectName;
objLstProBindMenu = objiBindMenuClient.CheckOperaction(objProBindMenu).ToList();
if (objLstProBindMenu.Count > 0)
{
objProBindMenu = objLstProBindMenu[0];
flg = objProBindMenu.BtnAdd;
}
return(flg);
}
catch (Exception ex) { Login.Profile.ErrorHandling(ex, "UCToolbarHTML", "ConvertToFill"); return(flg); }
finally { objiBindMenuClient.Close(); }
}
public Boolean ConvertToFill(String ObjectName)
{
Boolean flg = false;
//objProBindMenu._constP = profile.DBConnection._constr;
objProBindMenu.CompanyCode = profile.Personal.CompanyID;
objProBindMenu.UserCode = profile.Personal.UserID;
List<ProBindMenu> objLstProBindMenu = new List<ProBindMenu> { };
objProBindMenu.ObjectCode = ObjectName;
objLstProBindMenu = objiBindMenuClient.CheckOperaction(objProBindMenu).ToList();
if (objLstProBindMenu.Count > 0)
{
objProBindMenu = objLstProBindMenu[0];
flg = objProBindMenu.BtnAdd;
}
return flg;
}
public List <ProBindMenu> BindUserMenu(ProBindMenu objParaProBindMenu)
{
List <ProBindMenu> objProBindMenu = new List <ProBindMenu> {
};
ProBindMenu objProBindMenuM = new ProBindMenu();
StringBuilder strMenuString = new StringBuilder();
string strFinalQuery = "";
SqlConnection con = new SqlConnection("Data Source=" + objParaProBindMenu._constP[0].ToString() + ";Initial Catalog=" + objParaProBindMenu._constP[1].ToString() + ";Persist Security Info=True;User ID=" + objParaProBindMenu._constP[3].ToString() + ";Password="******";");
con.Open();
SqlCommand cmd = new SqlCommand();
SqlDataReader rd;
SqlDataReader rd2;
cmd.CommandText = "Declare @Query varchar(max); Set @Query ='Select '; select @Query =@Query+ ' ( select FormUrl from sysmObjects where HeaderMenu=''YS'' and Sequence ='+CAST ( Sequence as varchar(10))+' ) + ' from sysmObjects left outer join mUserRolesDetail on mUserRolesDetail.ObjectName=sysmObjects.ObjectName where mUserRolesDetail.UserID=" + objParaProBindMenu.UserCode + " and mUserRolesDetail.CompanyID=" + objParaProBindMenu.CompanyCode + " and (mUserRolesDetail.[Add]='True' or mUserRolesDetail.Edit ='True' or mUserRolesDetail.[View] ='True' or mUserRolesDetail.[Delete]='True' or mUserRolesDetail.Approval='True' or mUserRolesDetail.AssignTask='True' ) and HeaderMenu='YS' order by Sequence Set @Query =@Query+'+'; Select replace ( @Query,'+ +','') ";
cmd.Connection = con;
rd = cmd.ExecuteReader();
strMenuString.Append("<ul id='css3menu1' class='topmenu1'>");
while (rd.Read())
{
if (rd[0].ToString() == "Select +")
{
goto brk;
}
strFinalQuery = rd[0].ToString();
cmd.CommandText = strFinalQuery;
rd.Close();
rd2 = cmd.ExecuteReader();
while (rd2.Read())
{
strMenuString.Append("" + rd2[0].ToString() + "");
goto brk;
}
}
brk:
con.Close();
strMenuString.Append("</ul>");
objProBindMenuM.MenuCode = strMenuString.ToString();
objProBindMenu.Add(objProBindMenuM);
return(objProBindMenu);
}
public ProBindMenu ToolbarAccess1(string ObjectName, String eventID)
{
//objProBindMenu._constP = profile.DBConnection._constr;
objProBindMenu.CompanyCode = profile.Personal.CompanyID;
objProBindMenu.UserCode = profile.Personal.UserID;
List<ProBindMenu> objLstProBindMenu = new List<ProBindMenu> { };
objProBindMenu.ObjectCode = ObjectName;
objLstProBindMenu = objiBindMenuClient.CheckOperaction(objProBindMenu).ToList();
if (objLstProBindMenu.Count > 0)
{
objProBindMenu = objLstProBindMenu[0];
objProBindMenu.ActiveButton = eventID;
objProBindMenu = objiBindMenuClient.ActiveButtonClickEvent(objProBindMenu);
}
return objProBindMenu;
}
public void ToolbarAccess(string ObjectName, String eventID)
{
//objProBindMenu._constP = profile.DBConnection._constr;
objProBindMenu.CompanyCode = profile.Personal.CompanyID;
objProBindMenu.UserCode = profile.Personal.UserID;
List<ProBindMenu> objLstProBindMenu = new List<ProBindMenu> { };
objProBindMenu.ObjectCode = ObjectName;
objLstProBindMenu = objiBindMenuClient.CheckOperaction(objProBindMenu).ToList();
if (objLstProBindMenu.Count > 0)
{
objProBindMenu = objLstProBindMenu[0];
objProBindMenu.ActiveButton = eventID;
objProBindMenu = objiBindMenuClient.ActiveButtonClickEvent(objProBindMenu);
btnAddNew.Enabled = objProBindMenu.BtnAdd;
btnEdit.Disabled = !(objProBindMenu.BtnEdit);
//btnExport.Enabled = objProBindMenu.BtnExport;
//btnImport.Enabled = objProBindMenu.BtnImport;
//btmMail.Enabled = objProBindMenu.BtnMail;
//btnPrint.Enabled = objProBindMenu.BtnPrint;
btnSave.Enabled = objProBindMenu.BtnSave;
btnClear.Enabled = objProBindMenu.BtnClear;
ButtonOffOn(btnAddNew); ButtonOffOn(btnEdit);
//ButtonOffOn(btnExport);
//ButtonOffOn(btnImport);
//ButtonOffOn(btmMail); ButtonOffOn(btnPrint);
ButtonOffOn(btnSave); ButtonOffOn(btnClear);
// tdConvertTo.Visible = false;
// FlybtnConvertTo.AttachTo = "";
if (objProBindMenu.ObjectCode == "Lead" || objProBindMenu.ObjectCode == "Opportunity" || objProBindMenu.ObjectCode == "Quotation" || objProBindMenu.ObjectCode == "SalesOrder" || objProBindMenu.ObjectCode == "AddNew")
{
//FlybtnConvertTo.AttachTo = "tdConvertTo";
// tdConvertTo.Visible = true;
btnSave.Visible = false;
btnEdit.Visible = false;
}
}
}
public List <ProBindMenu> CheckOperaction(ProBindMenu objParaProBindMenu)
{
List <ProBindMenu> objProBindMenu = new List <ProBindMenu> {
};
SqlConnection con = new SqlConnection("Data Source=" + objParaProBindMenu._constP[0].ToString() + ";Initial Catalog=" + objParaProBindMenu._constP[1].ToString() + ";Persist Security Info=True;User ID=" + objParaProBindMenu._constP[3].ToString() + ";Password="******";");
con.Open();
SqlCommand cmd = new SqlCommand();
SqlDataReader rd;
cmd.CommandText = "select case when [Add]=1 then 'true' else 'false' end as [Add],case when [Edit]=1 then 'true' else 'false' end as [Edit],case when [View]=1 then 'true' else 'false' end as [View],case when [Delete]=1 then 'true' else 'false' end as [Delete],case when [Approval] =1 then 'true' else 'false' end as [Approval] ,case when [AssignTask]=1 then 'true' else 'false' end as [AssignTask] ,ObjectName from mUserRolesDetail where UserID='" + objParaProBindMenu.UserCode + "' and CompanyID = '" + objParaProBindMenu.CompanyCode + "' and ObjectName='" + objParaProBindMenu.ObjectCode + "'";
cmd.Connection = con;
rd = cmd.ExecuteReader();
while (rd.Read())
{
objParaProBindMenu.BtnAdd = Convert.ToBoolean(rd["Add"].ToString());
objParaProBindMenu.BtnEdit = Convert.ToBoolean(rd["Edit"].ToString());
objParaProBindMenu.BtnView = Convert.ToBoolean(rd["View"].ToString());
objParaProBindMenu.BtnDelete = Convert.ToBoolean(rd["Delete"].ToString());
objParaProBindMenu.BtnSave = Convert.ToBoolean(rd[0].ToString());
objParaProBindMenu.BtnClear = true;
if (Convert.ToBoolean(rd["Add"].ToString()) == true || Convert.ToBoolean(rd["Edit"].ToString()) == true || Convert.ToBoolean(rd["View"].ToString()) == true)
{
objParaProBindMenu.BtnPrint = objParaProBindMenu.BtnExport = true;
}
else
{
objParaProBindMenu.BtnPrint = objParaProBindMenu.BtnExport = false;
}
objParaProBindMenu.BtnImport = Convert.ToBoolean(rd["Add"].ToString());
objParaProBindMenu.BtnMail = Convert.ToBoolean(rd["Add"].ToString());
objParaProBindMenu.BtnApproval = Convert.ToBoolean(rd["Approval"].ToString());
objParaProBindMenu.BtnAssignTask = Convert.ToBoolean(rd["AssignTask"].ToString());
objProBindMenu.Add(objParaProBindMenu);
}
return(objProBindMenu);
}
public ProBindMenu ToolbarAccess1(string ObjectName, String eventID)
{
BrilliantWMS.BindMenuService.iBindMenuClient objiBindMenuClient = new BrilliantWMS.BindMenuService.iBindMenuClient();
try
{
CustomProfile profile = CustomProfile.GetProfile();
//objProBindMenu._constP = profile.DBConnection._constr;
objProBindMenu.CompanyCode = profile.Personal.CompanyID;
objProBindMenu.UserCode = profile.Personal.UserID;
List <ProBindMenu> objLstProBindMenu = new List <ProBindMenu> {
};
objProBindMenu.ObjectCode = ObjectName;
objLstProBindMenu = objiBindMenuClient.CheckOperaction(objProBindMenu).ToList();
if (objLstProBindMenu.Count > 0)
{
objProBindMenu = objLstProBindMenu[0];
objProBindMenu.ActiveButton = eventID;
objProBindMenu = objiBindMenuClient.ActiveButtonClickEvent(objProBindMenu);
}
return(objProBindMenu);
}
catch (Exception ex) { Login.Profile.ErrorHandling(ex, "UCToolbarHTML", "ToolbarAccess1"); return(objProBindMenu); }
finally { objiBindMenuClient.Close(); }
}
public ProBindMenu ActiveButtonClickEvent(ProBindMenu objProBindMenu)
{
objProBindMenu.BtnExport = objProBindMenu.BtnImport = objProBindMenu.BtnMail = false;
switch (objProBindMenu.ActiveButton.ToString())
{
case "PageLoad":
if (objProBindMenu.BtnAdd == true)
{
objProBindMenu.BtnClear = objProBindMenu.BtnSave = objProBindMenu.BtnEdit = objProBindMenu.BtnApproval = objProBindMenu.BtnPrint = objProBindMenu.BtnAssignTask = objProBindMenu.BtnDelete = objProBindMenu.BtnView = false;
objProBindMenu.BtnConvertTo = objProBindMenu.BtnAdd = true;
}
break;
case "btnAddNew":
if (objProBindMenu.BtnAdd == true)
{
objProBindMenu.BtnPrint = objProBindMenu.BtnAdd = objProBindMenu.BtnEdit = objProBindMenu.BtnApproval = objProBindMenu.BtnAssignTask = objProBindMenu.BtnDelete = objProBindMenu.BtnView = false;
objProBindMenu.BtnClear = objProBindMenu.BtnSave = true;
}
break;
case "btnEdit":
if (objProBindMenu.BtnEdit == true)
{
objProBindMenu.BtnAdd = objProBindMenu.BtnApproval = objProBindMenu.BtnAssignTask = objProBindMenu.BtnDelete = objProBindMenu.BtnEdit = objProBindMenu.BtnView = false;
objProBindMenu.BtnClear = objProBindMenu.BtnSave = objProBindMenu.BtnPrint = true;
}
break;
case "btnSave":
if (objProBindMenu.BtnSave == true)
{
objProBindMenu.BtnPrint = objProBindMenu.BtnAdd = objProBindMenu.BtnEdit = objProBindMenu.BtnApproval = objProBindMenu.BtnAssignTask = objProBindMenu.BtnDelete = objProBindMenu.BtnView = objProBindMenu.BtnClear = objProBindMenu.BtnSave = true;
}
break;
case "btnSaveEdit":
if (objProBindMenu.BtnSave == true)
{
objProBindMenu.BtnPrint = objProBindMenu.BtnAdd = objProBindMenu.BtnEdit = objProBindMenu.BtnApproval = objProBindMenu.BtnAssignTask = objProBindMenu.BtnDelete = objProBindMenu.BtnView = objProBindMenu.BtnClear = objProBindMenu.BtnSave = true;
}
break;
case "btnClear":
if (objProBindMenu.BtnClear == true)
{
List <ProBindMenu> objListProBindMenu = new List <ProBindMenu> {
};
objListProBindMenu = CheckOperaction(objProBindMenu);
objProBindMenu = objListProBindMenu[0];
}
break;
case "btnExport":
if (objProBindMenu.BtnExport == true)
{
}
break;
case "btnImport":
if (objProBindMenu.BtnImport == true)
{
}
break;
case "btnMail":
if (objProBindMenu.BtnMail == true)
{
}
break;
case "SelectRecord":
objProBindMenu.BtnApproval = objProBindMenu.BtnAssignTask = objProBindMenu.BtnDelete = objProBindMenu.BtnClear = objProBindMenu.BtnSave = false;
objProBindMenu.BtnPrint = objProBindMenu.BtnAdd = objProBindMenu.BtnEdit = objProBindMenu.BtnView = objProBindMenu.BtnPrint = true;
break;
case "btnPrint":
if (objProBindMenu.BtnPrint == true)
{
}
break;
case "btnConvertTo":
if (objProBindMenu.BtnAdd == true)
{
}
break;
default:
objProBindMenu.BtnEdit = objProBindMenu.BtnClear = objProBindMenu.BtnSave = false;
break;
}
//objProBindMenu.BtnConvertTo = objProBindMenu.BtnAdd = objProBindMenu.BtnClear = objProBindMenu.BtnSave = objProBindMenu.BtnEdit = objProBindMenu.BtnApproval = objProBindMenu.BtnPrint = objProBindMenu.BtnAssignTask = objProBindMenu.BtnDelete = objProBindMenu.BtnView = true;
return(objProBindMenu);
}