public bool menu_accessrights_iud(int role_id, int menu_id, bool isdelete)
{
Command = new SqlCommand("usp_menu_accessrights_iud", Connection);
Command.CommandType = CommandType.StoredProcedure;
SqlParameter prmrole_id = new SqlParameter("@role_id", SqlDbType.Int);
SqlParameter prmmenu_id = new SqlParameter("@menu_id", SqlDbType.Int);
SqlParameter prmlmby = new SqlParameter("@lmby", SqlDbType.Int);
prmrole_id.Value = role_id;
prmmenu_id.Value = menu_id;
prmlmby.Value = ContentSession.USERID;
Command.Parameters.Add(prmrole_id);
Command.Parameters.Add(prmmenu_id);
Command.Parameters.Add(prmlmby);
if (isdelete)
{
SqlParameter prmisDelete = new SqlParameter("@isDelete", SqlDbType.Bit);
prmisDelete.Value = isdelete;
Command.Parameters.Add(prmisDelete);
}
return(CustomExecuteCommand.ExecuteNonQuery(Command, Connection, "MasterDataAccess:menu_accessrights_iud", "usp_menu_accessrights_iud"));
}
public bool master_sow_iud(int scope_type_id, string general_sow, string detail_sow, string master_sow_id, bool isdelete)
{
Command = new SqlCommand("usp_master_sow_iud", Connection);
Command.CommandType = CommandType.StoredProcedure;
SqlParameter prmscope_type_id = new SqlParameter("@scope_type_id", SqlDbType.Int);
SqlParameter prmgeneral_sow = new SqlParameter("@general_sow", SqlDbType.VarChar, 200);
SqlParameter prmdetail_sow = new SqlParameter("@detail_sow", SqlDbType.VarChar, 200);
SqlParameter prmlmby = new SqlParameter("@LMBY", SqlDbType.Int);
prmscope_type_id.Value = scope_type_id;
prmgeneral_sow.Value = general_sow;
prmdetail_sow.Value = detail_sow;
prmlmby.Value = ContentSession.USERID;
Command.Parameters.Add(prmscope_type_id);
Command.Parameters.Add(prmgeneral_sow);
Command.Parameters.Add(prmdetail_sow);
Command.Parameters.Add(prmlmby);
if (!string.IsNullOrEmpty(master_sow_id))
{
SqlParameter prmmaster_sow_id = new SqlParameter("@master_sow_id", SqlDbType.Int);
prmmaster_sow_id.Value = int.Parse(master_sow_id);
Command.Parameters.Add(prmmaster_sow_id);
}
if (isdelete)
{
SqlParameter prmisDelete = new SqlParameter("@isDelete", SqlDbType.Bit);
prmisDelete.Value = isdelete;
Command.Parameters.Add(prmisDelete);
}
return(CustomExecuteCommand.ExecuteNonQuery(Command, Connection, "MasterDataAccess:master_sow_iud", "usp_master_sow_iud"));
}
public bool Role_Grouping_iud(int LOI_RoleID, int RoleID, string CTName, string Role_Grouping_ID, bool isdelete)
{
Command = new SqlCommand("usp_Role_Grouping_iud", Connection);
Command.CommandType = CommandType.StoredProcedure;
SqlParameter prmLOI_RoleID = new SqlParameter("@LOI_RoleID", SqlDbType.Int);
SqlParameter prmRoleID = new SqlParameter("@RoleID", SqlDbType.Int);
SqlParameter prmCTName = new SqlParameter("@CTName", SqlDbType.VarChar, 50);
SqlParameter prmlmby = new SqlParameter("@lmby", SqlDbType.Int);
prmLOI_RoleID.Value = LOI_RoleID;
prmRoleID.Value = RoleID;
prmCTName.Value = CTName;
prmlmby.Value = ContentSession.USERID;
Command.Parameters.Add(prmLOI_RoleID);
Command.Parameters.Add(prmRoleID);
Command.Parameters.Add(prmCTName);
Command.Parameters.Add(prmlmby);
if (!string.IsNullOrEmpty(Role_Grouping_ID))
{
SqlParameter prmRole_Grouping_ID = new SqlParameter("@Role_Grouping_ID", SqlDbType.Int);
prmRole_Grouping_ID.Value = int.Parse(Role_Grouping_ID);
Command.Parameters.Add(prmRole_Grouping_ID);
}
if (isdelete)
{
SqlParameter prmisDelete = new SqlParameter("@isDelete", SqlDbType.Bit);
prmisDelete.Value = isdelete;
Command.Parameters.Add(prmisDelete);
}
return(CustomExecuteCommand.ExecuteNonQuery(Command, Connection, "MasterDataAccess:Role_Grouping_iud", "usp_Role_Grouping_iud"));
}
public bool WFDef_IU(Int32 wfdefid, int roleid, int wfid, int seqno, int lmby, int taskid)
{
Command = new SqlCommand("uspWFDef_IU", Connection);
Command.CommandType = CommandType.StoredProcedure;
SqlParameter prmWFDefID = new SqlParameter("@wfdefid", SqlDbType.BigInt);
SqlParameter prmWFID = new SqlParameter("@wfid", SqlDbType.Int);
SqlParameter prmRoleID = new SqlParameter("@roleid", SqlDbType.Int);
SqlParameter prmLMBY = new SqlParameter("@lmby", SqlDbType.Int);
SqlParameter prmSeqno = new SqlParameter("@seqno", SqlDbType.Int);
SqlParameter prmTaskID = new SqlParameter("@taskid", SqlDbType.Int);
prmWFDefID.Value = wfdefid;
prmWFID.Value = wfid;
prmRoleID.Value = roleid;
prmLMBY.Value = lmby;
prmSeqno.Value = seqno;
prmTaskID.Value = taskid;
Command.Parameters.Add(prmWFDefID);
Command.Parameters.Add(prmWFID);
Command.Parameters.Add(prmRoleID);
Command.Parameters.Add(prmLMBY);
Command.Parameters.Add(prmSeqno);
Command.Parameters.Add(prmTaskID);
return(CustomExecuteCommand.ExecuteNonQuery(Command, Connection, "MasterDataAccess:WFDef_IU", "uspWFDef_IU"));
}
public bool checking_loi_overdue()
{
Command = new SqlCommand("usp_checking_loi_overdue", Connection);
Command.CommandType = CommandType.StoredProcedure;
return(CustomExecuteCommand.ExecuteNonQuery(Command, Connection, "GeneralSchedDataAccess:checking_loi_overdue", "usp_checking_loi_overdue"));
}
public bool mapping_subcon_phone_iud(int EPM_Vendor_ID, string SCon_Phone, string SCon_Fax, string mapping_subcon_phone_ID, bool isDelete)
{
Command = new SqlCommand("usp_mapping_subcon_phone_iud", Connection);
Command.CommandType = CommandType.StoredProcedure;
SqlParameter prmEPM_Vendor_ID = new SqlParameter("@EPM_Vendor_ID", SqlDbType.Int);
SqlParameter prmSCon_Phone = new SqlParameter("@SCon_Phone", SqlDbType.VarChar, 200);
SqlParameter prmSCon_Fax = new SqlParameter("@SCon_Fax", SqlDbType.VarChar, 200);
SqlParameter prmlmby = new SqlParameter("@lmby", SqlDbType.Int);
prmEPM_Vendor_ID.Value = EPM_Vendor_ID;
prmSCon_Phone.Value = SCon_Phone;
prmSCon_Fax.Value = SCon_Fax;
prmlmby.Value = ContentSession.USERID;
Command.Parameters.Add(prmEPM_Vendor_ID);
Command.Parameters.Add(prmSCon_Phone);
Command.Parameters.Add(prmSCon_Fax);
Command.Parameters.Add(prmlmby);
if (!string.IsNullOrEmpty(mapping_subcon_phone_ID))
{
SqlParameter prmmapping_subcon_phone_ID = new SqlParameter("@mapping_subcon_phone_ID", SqlDbType.Int);
prmmapping_subcon_phone_ID.Value = mapping_subcon_phone_ID;
Command.Parameters.Add(prmmapping_subcon_phone_ID);
}
if (isDelete)
{
SqlParameter prmisDelete = new SqlParameter("@isDelete", SqlDbType.Bit);
prmisDelete.Value = isDelete;
Command.Parameters.Add(prmisDelete);
}
return(CustomExecuteCommand.ExecuteNonQuery(Command, Connection, "MasterDataAccess:mapping_subcon_phone_iud", "usp_mapping_subcon_phone_iud"));
}
public bool grouping_scope_Flow_iud(int scope_type_id, int wf_id, string CTName, string groupingid, bool isdelete)
{
Command = new SqlCommand("usp_grouping_scope_Flow_iud", Connection);
Command.CommandType = CommandType.StoredProcedure;
SqlParameter prmscope_type_id = new SqlParameter("@scope_type_id", SqlDbType.Int);
SqlParameter prmwf_id = new SqlParameter("@wf_id", SqlDbType.Int);
SqlParameter prmlmby = new SqlParameter("@lmby", SqlDbType.Int);
SqlParameter prmCTName = new SqlParameter("@CTName", SqlDbType.VarChar, 50);
prmscope_type_id.Value = scope_type_id;
prmwf_id.Value = wf_id;
prmlmby.Value = ContentSession.USERID;
prmCTName.Value = CTName;
Command.Parameters.Add(prmscope_type_id);
Command.Parameters.Add(prmwf_id);
Command.Parameters.Add(prmlmby);
Command.Parameters.Add(prmCTName);
if (!string.IsNullOrEmpty(groupingid))
{
SqlParameter prmgrouping_scope_Flow_id = new SqlParameter("@grouping_scope_Flow_id", SqlDbType.Int);
prmgrouping_scope_Flow_id.Value = int.Parse(groupingid);
Command.Parameters.Add(prmgrouping_scope_Flow_id);
}
if (isdelete)
{
SqlParameter prmisDelete = new SqlParameter("@isDelete", SqlDbType.Bit);
prmisDelete.Value = isdelete;
Command.Parameters.Add(prmisDelete);
}
return(CustomExecuteCommand.ExecuteNonQuery(Command, Connection, "MasterDataAccess:grouping_scope_Flow_iud", "usp_grouping_scope_Flow_iud"));
}
public bool TRole_iud(string LVLCode, string Rolecode, string RoleDesc, string roleid, bool isdelete)
{
Command = new SqlCommand("usp_TRole_iud", Connection);
Command.CommandType = CommandType.StoredProcedure;
SqlParameter prmLVLCode = new SqlParameter("@LVLCode", SqlDbType.VarChar, 2);
SqlParameter prmRolecode = new SqlParameter("@Rolecode", SqlDbType.VarChar, 2);
SqlParameter prmRoleDesc = new SqlParameter("@RoleDesc", SqlDbType.VarChar, 50);
SqlParameter prmlmby = new SqlParameter("@lmby", SqlDbType.Int);
prmLVLCode.Value = LVLCode;
prmRolecode.Value = Rolecode;
prmRoleDesc.Value = RoleDesc;
prmlmby.Value = ContentSession.USERID;
Command.Parameters.Add(prmLVLCode);
Command.Parameters.Add(prmRolecode);
Command.Parameters.Add(prmRoleDesc);
Command.Parameters.Add(prmlmby);
if (!string.IsNullOrEmpty(roleid))
{
SqlParameter prmRoleID = new SqlParameter("@RoleID", SqlDbType.Int);
prmRoleID.Value = int.Parse(roleid);
Command.Parameters.Add(prmRoleID);
}
if (isdelete)
{
SqlParameter prmisDelete = new SqlParameter("@isDelete", SqlDbType.Bit);
prmisDelete.Value = isdelete;
Command.Parameters.Add(prmisDelete);
}
return(CustomExecuteCommand.ExecuteNonQuery(Command, Connection, "MasterDataAccess:TRole_iud", "usp_TRole_iud"));
}
public bool scope_type_iud(string scope_type, string scope_type_id, bool isdelete)
{
Command = new SqlCommand("usp_scope_type_iud", Connection);
Command.CommandType = CommandType.StoredProcedure;
SqlParameter prmscope_type = new SqlParameter("@scope_type", SqlDbType.VarChar, 50);
SqlParameter prmlmby = new SqlParameter("@LMBY", SqlDbType.Int);
prmscope_type.Value = scope_type;
prmlmby.Value = ContentSession.USERID;
Command.Parameters.Add(prmscope_type);
Command.Parameters.Add(prmlmby);
if (!string.IsNullOrEmpty(scope_type_id))
{
SqlParameter prmscope_type_id = new SqlParameter("@scope_type_id", SqlDbType.Int);
prmscope_type_id.Value = int.Parse(scope_type_id);
Command.Parameters.Add(prmscope_type_id);
}
if (isdelete)
{
SqlParameter prmisDelete = new SqlParameter("@isDelete", SqlDbType.Bit);
prmisDelete.Value = isdelete;
Command.Parameters.Add(prmisDelete);
}
return(CustomExecuteCommand.ExecuteNonQuery(Command, Connection, "MasterDataAccess:scope_type_iud", "usp_scope_type_iud"));
}
public bool ebastusers_changepassword(string usr_login, string oldPassword, string newPassword)
{
Command = new SqlCommand("usp_ebastusers_changepassword", Connection);
Command.CommandType = CommandType.StoredProcedure;
SqlParameter prmusr_login = new SqlParameter("@USRLogin", SqlDbType.VarChar, 30);
SqlParameter prmoldPassword = new SqlParameter("@oldPassword", SqlDbType.VarChar, 100);
SqlParameter prmnewPassword = new SqlParameter("@newPassword", SqlDbType.VarChar, 100);
SqlParameter prmCTName = new SqlParameter("@CTName", SqlDbType.VarChar, 50);
SqlParameter prmlmby = new SqlParameter("@lmby", SqlDbType.Int);
prmusr_login.Value = usr_login;
prmoldPassword.Value = oldPassword;
prmnewPassword.Value = newPassword;
prmCTName.Value = ContentSession.CTName;
prmlmby.Value = ContentSession.USERID;
Command.Parameters.Add(prmusr_login);
Command.Parameters.Add(prmoldPassword);
Command.Parameters.Add(prmnewPassword);
Command.Parameters.Add(prmCTName);
Command.Parameters.Add(prmlmby);
return(CustomExecuteCommand.ExecuteNonQuery(Command, Connection, "MasterDataAccess:ebastusers_changepassword", "usp_ebastusers_changepassword"));
}
public bool ebastusers_loi_iud(string USRType, string Name, int USRRole, string USRLogin, string Email, string PhoneNo, string SignTitle, string CTName, string USRPassword, string USR_ID, bool isDelete)
{
Command = new SqlCommand("usp_ebastusers_loi_iud", Connection);
Command.CommandType = CommandType.StoredProcedure;
SqlParameter prmUSRType = new SqlParameter("@USRType", SqlDbType.VarChar, 1);
SqlParameter prmName = new SqlParameter("@Name", SqlDbType.VarChar, 30);
SqlParameter prmUSRRole = new SqlParameter("@USRRole", SqlDbType.BigInt);
SqlParameter prmUSRLogin = new SqlParameter("@USRLogin", SqlDbType.VarChar, 30);
SqlParameter prmUSRPassword = new SqlParameter("@USRPassword", SqlDbType.VarChar, 100);
SqlParameter prmEmail = new SqlParameter("@Email", SqlDbType.VarChar, 50);
SqlParameter prmPhoneNo = new SqlParameter("@PhoneNo", SqlDbType.VarChar, 20);
SqlParameter prmLMBY = new SqlParameter("@LMBY", SqlDbType.VarChar, 50);
SqlParameter prmSignTitle = new SqlParameter("@SignTitle", SqlDbType.VarChar, 100);
SqlParameter prmCTName = new SqlParameter("@CTName", SqlDbType.VarChar, 50);
prmUSRType.Value = USRType;
prmName.Value = Name;
prmUSRRole.Value = USRRole;
prmUSRLogin.Value = USRLogin;
prmUSRPassword.Value = USRPassword;
prmEmail.Value = Email;
prmPhoneNo.Value = PhoneNo;
prmLMBY.Value = ContentSession.FULLNAME;
prmSignTitle.Value = SignTitle;
prmCTName.Value = CTName;
Command.Parameters.Add(prmUSRType);
Command.Parameters.Add(prmName);
Command.Parameters.Add(prmUSRRole);
Command.Parameters.Add(prmUSRLogin);
Command.Parameters.Add(prmUSRPassword);
Command.Parameters.Add(prmEmail);
Command.Parameters.Add(prmPhoneNo);
Command.Parameters.Add(prmLMBY);
Command.Parameters.Add(prmSignTitle);
Command.Parameters.Add(prmCTName);
if (!string.IsNullOrEmpty(USR_ID))
{
SqlParameter prmUSR_ID = new SqlParameter("@USR_ID", SqlDbType.BigInt);
prmUSR_ID.Value = int.Parse(USR_ID);
Command.Parameters.Add(prmUSR_ID);
}
if (isDelete)
{
SqlParameter prmisDelete = new SqlParameter("@isDelete", SqlDbType.Bit);
prmisDelete.Value = isDelete;
Command.Parameters.Add(prmisDelete);
}
return(CustomExecuteCommand.ExecuteNonQuery(Command, Connection, "MasterDataAccess:ebastusers_loi_iud", "usp_ebastusers_loi_iud"));
}
public bool WFDef_D(Int32 wfdefid)
{
Command = new SqlCommand("uspWFDef_D", Connection);
Command.CommandType = CommandType.StoredProcedure;
SqlParameter prmWFDefID = new SqlParameter("@wfdefid", SqlDbType.BigInt);
SqlParameter prmLMBY = new SqlParameter("@lmby", SqlDbType.Int);
prmWFDefID.Value = wfdefid;
prmLMBY.Value = ContentSession.USERID;
Command.Parameters.Add(prmWFDefID);
Command.Parameters.Add(prmLMBY);
return(CustomExecuteCommand.ExecuteNonQuery(Command, Connection, "MasterDataAccess:WFDef_D", "uspWFDef_D"));
}
public bool WF_WFDefinedStatus_U(int wfid, int lmby, string definedstatus)
{
Command = new SqlCommand("uspWF_WFDefinedStatus_U", Connection);
Command.CommandType = CommandType.StoredProcedure;
SqlParameter prmWFID = new SqlParameter("@wfid", SqlDbType.Int);
SqlParameter prmDefinedStatus = new SqlParameter("@wfdefinedstatus", SqlDbType.VarChar, 20);
SqlParameter prmLMBY = new SqlParameter("@lmby", SqlDbType.Int);
prmWFID.Value = wfid;
prmDefinedStatus.Value = definedstatus;
prmLMBY.Value = lmby;
Command.Parameters.Add(prmWFID);
Command.Parameters.Add(prmDefinedStatus);
Command.Parameters.Add(prmLMBY);
return(CustomExecuteCommand.ExecuteNonQuery(Command, Connection, "MasterDataAccess:WF_WFDefinedStatus_U", "uspWF_WFDefinedStatus_U"));
}
public bool WFDef_Seqno_U(int wfdefid, string stepflag)
{
Command = new SqlCommand("uspWFDef_Seqno_U", Connection);
Command.CommandType = CommandType.StoredProcedure;
SqlParameter prmWFDefID = new SqlParameter("@wfdefid", SqlDbType.BigInt);
SqlParameter prmStepFlag = new SqlParameter("@stepflag", SqlDbType.VarChar, 10);
SqlParameter prmLMBY = new SqlParameter("@lmby", SqlDbType.Int);
prmWFDefID.Value = wfdefid;
prmStepFlag.Value = stepflag;
prmLMBY.Value = ContentSession.USERID;
Command.Parameters.Add(prmWFDefID);
Command.Parameters.Add(prmStepFlag);
Command.Parameters.Add(prmLMBY);
return(CustomExecuteCommand.ExecuteNonQuery(Command, Connection, "MasterDataAccess:WFDef_Seqno_U", "uspWFDef_Seqno_U"));
}
public bool LOI_Update_Document_GeneratedLink(string LOI_Document, int RequestId)
{
Command = new SqlCommand("usp_LOI_Update_Document_GeneratedLink", Connection);
Command.CommandType = CommandType.StoredProcedure;
SqlParameter prm_RequestId = new SqlParameter("@RequestId", SqlDbType.BigInt);
prm_RequestId.Value = RequestId;
Command.Parameters.Add(prm_RequestId);
SqlParameter prm_LOI_Document = new SqlParameter("@LOI_Document", SqlDbType.VarChar, 1000);
prm_LOI_Document.Value = LOI_Document;
Command.Parameters.Add(prm_LOI_Document);
return(CustomExecuteCommand.ExecuteNonQuery(Command, Connection, "LOIDataAccess:LOI_Update_Document_GeneratedLink", "usp_LOI_Update_Document_GeneratedLink"));
}
public bool role_dashboard_access_iu(int role_id, int dashboard_id)
{
Command = new SqlCommand("usp_role_dashboard_access_iu", Connection);
Command.CommandType = CommandType.StoredProcedure;
SqlParameter prmrole_id = new SqlParameter("@role_id", SqlDbType.Int);
SqlParameter prmdashboard_id = new SqlParameter("@dashboard_id", SqlDbType.Int);
SqlParameter prmlmby = new SqlParameter("@lmby", SqlDbType.Int);
prmrole_id.Value = role_id;
prmdashboard_id.Value = dashboard_id;
prmlmby.Value = ContentSession.USERID;
Command.Parameters.Add(prmrole_id);
Command.Parameters.Add(prmdashboard_id);
Command.Parameters.Add(prmlmby);
return(CustomExecuteCommand.ExecuteNonQuery(Command, Connection, "MasterDataAccess:role_dashboard_access_iu", "usp_role_dashboard_access_iu"));
}
public bool mapping_scope_role_iud(int scope_type_id, int roleid)
{
Command = new SqlCommand("usp_mapping_scope_role_iud", Connection);
Command.CommandType = CommandType.StoredProcedure;
SqlParameter prmscope_type_id = new SqlParameter("@scope_type_id", SqlDbType.Int);
SqlParameter prmRoleID = new SqlParameter("@RoleID", SqlDbType.Int);
SqlParameter prmlmby = new SqlParameter("@lmby", SqlDbType.Int);
prmscope_type_id.Value = scope_type_id;
prmRoleID.Value = roleid;
prmlmby.Value = ContentSession.USERID;
Command.Parameters.Add(prmscope_type_id);
Command.Parameters.Add(prmRoleID);
Command.Parameters.Add(prmlmby);
return(CustomExecuteCommand.ExecuteNonQuery(Command, Connection, "MasterDataAccess:ebastusers_changepassword", "usp_ebastusers_changepassword"));
}
public bool reset_password_all_ct(int USR_ID, string USRPassword, string CTName)
{
Command = new SqlCommand("usp_reset_password_all_ct", Connection);
Command.CommandType = CommandType.StoredProcedure;
SqlParameter prmUSR_ID = new SqlParameter("@USR_ID", SqlDbType.BigInt);
SqlParameter prmUSRPassword = new SqlParameter("@USRPassword", SqlDbType.VarChar, 100);
SqlParameter prmCTName = new SqlParameter("@CTName", SqlDbType.VarChar, 50);
SqlParameter prmlmby = new SqlParameter("@lmby", SqlDbType.VarChar, 50);
prmUSR_ID.Value = USR_ID;
prmUSRPassword.Value = USRPassword;
prmCTName.Value = CTName;
prmlmby.Value = ContentSession.FULLNAME;
Command.Parameters.Add(prmUSR_ID);
Command.Parameters.Add(prmUSRPassword);
Command.Parameters.Add(prmCTName);
Command.Parameters.Add(prmlmby);
return(CustomExecuteCommand.ExecuteNonQuery(Command, Connection, "MasterDataAccess:reset_password_all_ct", "usp_reset_password_all_ct"));
}
public bool master_workflow_iud(string wf_name, string wf_desc, string wf_id, bool isDelete)
{
Command = new SqlCommand("usp_master_workflow_iud", Connection);
Command.CommandType = CommandType.StoredProcedure;
SqlParameter prm_wf_name = new SqlParameter("@wf_name", SqlDbType.VarChar, 100);
prm_wf_name.Value = wf_name;
Command.Parameters.Add(prm_wf_name);
SqlParameter prm_wf_desc = new SqlParameter("@wf_desc", SqlDbType.VarChar, 200);
prm_wf_desc.Value = wf_desc;
Command.Parameters.Add(prm_wf_desc);
if (!string.IsNullOrEmpty(wf_id))
{
SqlParameter prm_wf_id = new SqlParameter("@wf_id", SqlDbType.Int);
prm_wf_id.Value = int.Parse(wf_id);
Command.Parameters.Add(prm_wf_id);
}
if (isDelete)
{
SqlParameter prm_isDelete = new SqlParameter("@isDelete", SqlDbType.Bit);
prm_isDelete.Value = isDelete;
Command.Parameters.Add(prm_isDelete);
}
SqlParameter prm_lmby = new SqlParameter("@lmby", SqlDbType.Int);
prm_lmby.Value = ContentSession.USERID;
Command.Parameters.Add(prm_lmby);
return(CustomExecuteCommand.ExecuteNonQuery(Command, Connection, "MasterDataAccess:master_workflow_iud", "usp_master_workflow_iud"));
}