public string AddModifyAuthority(ClsAuthority ObjAuthority)
{
using (ClsAuthorityManagement_BAL obj = new ClsAuthorityManagement_BAL())
{
return(obj.AddModifyAuthority(ObjAuthority));
}
}
public string AddModifyAuthority(ClsAuthority ObjAuthority)
{
try
{
DBParameterCollection ObJParameterCOl = new DBParameterCollection();
DBParameter objDBParameter = new DBParameter("@Ref_Authority_ID", ObjAuthority.Ref_Authority_ID, DbType.Int64);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@AuthorityName", ObjAuthority.AuthorityName, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@AuthorityType", ObjAuthority.AuthorityType, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@Description", ObjAuthority.Description, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@MasterDataIDs", ObjAuthority.MasterDataIDs, DbType.String);
ObJParameterCOl.Add(objDBParameter);
Int64 Ref_Authority_ID = 0;
DBHelper objDbHelper = new DBHelper();
Ref_Authority_ID = Convert.ToInt64(objDbHelper.ExecuteScalar(Constant.AddModifyAuthority, ObJParameterCOl, CommandType.StoredProcedure));
if (Ref_Authority_ID > 0)
{
ObjAuthority.ModuleAccess.ForEach(Module =>
{
DBParameterCollection ObJParameterCOl1 = new DBParameterCollection();
DBParameter objDBParameter1 = new DBParameter("@Ref_Authority_ID", Ref_Authority_ID, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@Ref_Module_ID", Module.Ref_Module_ID, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@View", Module.View, DbType.Boolean);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@Edit", Module.Edit, DbType.Boolean);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@Delete", Module.Delete, DbType.Boolean);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@Approval", Module.Approval, DbType.Boolean);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@CreatedBy", ObjAuthority.CreatedBy, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDbHelper.ExecuteScalar(Constant.AddModifyAuthorityModuleAccess, ObJParameterCOl1, CommandType.StoredProcedure);
});
}
if (Ref_Authority_ID > 0 && ObjAuthority.Ref_Authority_ID == 0)
{
return("AUTHORITYADDED");
}
else if (Ref_Authority_ID > 0 && ObjAuthority.Ref_Authority_ID == 0)
{
return("AUTHORITYUPDATED");
}
else
{
return("AUTHORITYEXISTS");
}
}
catch (Exception ex)
{
throw ex;
}
}
