public ActionResult GetObjAppInfoMapLogicValue(string pModuleObjMapCode)
{
bool vResult = true;
string vMSG = "";
AppObjInfoMap_Logic objIAppObjInfoMap_Logic = new AppObjInfoMap_Logic();
AppLevelDefinition objAppLevelDefinition = new AppLevelDefinition();
AppLevelDefinitionDet objAppLevelDefinitionDet = new AppLevelDefinitionDet();
objIAppObjInfoMap_Logic.ModuleObjMapCode_FK = pModuleObjMapCode;
try
{
//AppLevelDefinition objAppLevelDefinition = new AppLevelDefinition();
objIAppObjInfoMap_Logic = _appObjInfoMap_Logic.GetIAppObjInfoMap_Logic(objIAppObjInfoMap_Logic);
if (objIAppObjInfoMap_Logic == null)
{
vMSG = "This object is not mapping for approval";
vResult = false;
}
else
{
if (objIAppObjInfoMap_Logic.IsFieldPolicy == 1 && objIAppObjInfoMap_Logic.AppObjInfoMap_LogicValues_List_VW != null && objIAppObjInfoMap_Logic.AppObjInfoMap_LogicValues_List_VW.Count > 0)
{
GetLogicvalues(objIAppObjInfoMap_Logic);
}
//AppLevelDefinition objAppLevelDefinition = new AppLevelDefinition();
objAppLevelDefinition.ModuleObjMapCode_FK = objIAppObjInfoMap_Logic.ModuleObjMapCode_FK;
objAppLevelDefinition = _appLevelDefinition.GetAppLevelDefinition(objAppLevelDefinition);
if (objAppLevelDefinition == null || string.IsNullOrEmpty(objAppLevelDefinition.AppLvDefinitionCode_PK))
{
objAppLevelDefinition.objIAppLevelDefinitionDetList_VW = new List <AppLevelDefinitionDet>();
objAppLevelDefinitionDet.ObjAppInfoMapLogicCode_FK = objIAppObjInfoMap_Logic.ObjAppInfoMapLogicCode_PK;
objAppLevelDefinition.ModuleObjMapCode_FK = objIAppObjInfoMap_Logic.ModuleObjMapCode_FK;
objAppLevelDefinition.AppLevelType = objIAppObjInfoMap_Logic.IsFieldPolicy;
objAppLevelDefinition.objIAppLevelDefinitionDetList_VW.Add(objAppLevelDefinitionDet);
}
if (objAppLevelDefinition.objIAppLevelDefinitionDetList_VW.Count < 1)
{
vMSG = "Approval Level Definition Data Is incorrect";
vResult = false;
}
}
}
catch (Exception ex)
{
vMSG = ex.Message;
vResult = false;
}
return(Ok(new
{
vResult,
List = objAppLevelDefinition,
LogicList = objIAppObjInfoMap_Logic,
vMSG
}));
}
public AppLevelDefinition GetAppLevelDefinition(AppLevelDefinition objI)
{
string vComTxt = @"Select DISTINCT A.AppLvDefinitionCode
,A.ModuleObjMapCode
,A.AppLevelType,B.ActiveYN
from LS_AppLevelDefinition A JOIN LS_AppLevelDefinitionDet B ON A.AppLvDefinitionCode = B.AppLvDefinitionCode
WHERE A.ModuleObjMapCode = '" + objI.ModuleObjMapCode_FK + "' "
+ " AND A.ActionType<>'DELETE' AND B.ActionType<>'DELETE' AND B.ActiveYN = 1 AND A.CompanyCode = 1";
SqlConnection connection = _supplierDbContext.GetConn();
try
{
connection.Open();
SqlDataReader dr;
SqlCommand command = new SqlCommand(vComTxt, connection);
dr = command.ExecuteReader();
//while (dr.Read())
//{
if (dr.Read())
{
objI.AppLvDefinitionCode_PK = dr["AppLvDefinitionCode"].ToString();
objI.ModuleObjMapCode_FK = dr["ModuleObjMapCode"].ToString();
objI.AppLevelType = Convert.ToInt32(dr["AppLevelType"]);
objI.ActiveYN_VW = Convert.ToInt32(dr["ActiveYN"]);
GetAppLevelDefinitionDet(objI);
}
else
{
objI = new AppLevelDefinition();
}
//}
}
catch (DbException ex)
{
throw ex;
}
finally
{
connection.Close();
}
return(objI);
}
private void GetAppLevelDefinitionDet(AppLevelDefinition objI)
{
string vComTxt = @"SELECT A.[AppLvDefinitionDetCode]
,A.[AppLvDefinitionCode]
,A.[ObjAppInfoMapLogicCode]
,A.[ValueFrom1]
,A.[ValueTo1]
,A.[ValueFrom2]
,A.[ValueTo2]
,A.[ValueFrom3]
,A.[ValueTo3]
,A.[NoOfAppLevel]
,B.OptionText AS OptionText1
,C.OptionText AS OptionText2
,D.OptionText AS OptionText3
,A.SLNo
,A.ActiveYN
FROM [LS_AppLevelDefinitionDet] A
LEFT JOIN (Select ObjAppInfoMappLogicCode,OptionText,OptionValue from LS_AppObjInfoMap_LogicValues where OptionFor = 1 AND ActionType<>'DELETE') B
on A.ObjAppInfoMapLogicCode = B.ObjAppInfoMappLogicCode AND A.ValueFrom1 = B.OptionValue
LEFT JOIN (Select ObjAppInfoMappLogicCode,OptionText,OptionValue from LS_AppObjInfoMap_LogicValues where OptionFor = 2 AND ActionType<>'DELETE') C
on A.ObjAppInfoMapLogicCode = C.ObjAppInfoMappLogicCode AND A.ValueFrom2 = C.OptionValue
LEFT JOIN (Select ObjAppInfoMappLogicCode,OptionText,OptionValue from LS_AppObjInfoMap_LogicValues where OptionFor = 3 AND ActionType<>'DELETE') D
on A.ObjAppInfoMapLogicCode = D.ObjAppInfoMappLogicCode AND A.ValueFrom3 = D.OptionValue
WHERE A.AppLvDefinitionCode = '" + objI.AppLvDefinitionCode_PK + "' AND A.ActionType<>'DELETE' AND A.ActiveYN = 1" +
" Order BY A.SLNo ";
SqlConnection connection = _supplierDbContext.GetConn();
try
{
connection.Open();
SqlDataReader dr;
SqlCommand command = new SqlCommand(vComTxt, connection);
dr = command.ExecuteReader();
objI.objIAppLevelDefinitionDetList_VW = new List <AppLevelDefinitionDet>();
while (dr.Read())
{
AppLevelDefinitionDet objAppLevelDefinitionDet = new AppLevelDefinitionDet();
objAppLevelDefinitionDet.AppLvDefinitionDetCode_PK = dr["AppLvDefinitionDetCode"].ToString();
objAppLevelDefinitionDet.AppLvDefinitionCode_FK = dr["AppLvDefinitionCode"].ToString();
objAppLevelDefinitionDet.ObjAppInfoMapLogicCode_FK = dr["ObjAppInfoMapLogicCode"].ToString();
if (!string.IsNullOrEmpty(dr["SLNo"].ToString()))
{
objAppLevelDefinitionDet.SlNo = Convert.ToInt32(dr["SLNo"]);
}
if (!string.IsNullOrEmpty(dr["ValueFrom1"].ToString()))
{
objAppLevelDefinitionDet.ValueFrom1 = Convert.ToDecimal(dr["ValueFrom1"]);
}
if (!string.IsNullOrEmpty(dr["ValueTo1"].ToString()))
{
objAppLevelDefinitionDet.ValueTo1 = Convert.ToDecimal(dr["ValueTo1"]);
}
if (!string.IsNullOrEmpty(dr["ValueFrom2"].ToString()))
{
objAppLevelDefinitionDet.ValueFrom2 = Convert.ToDecimal(dr["ValueFrom2"]);
}
if (!string.IsNullOrEmpty(dr["ValueTo2"].ToString()))
{
objAppLevelDefinitionDet.ValueTo2 = Convert.ToDecimal(dr["ValueTo2"]);
}
if (!string.IsNullOrEmpty(dr["ValueFrom3"].ToString()))
{
objAppLevelDefinitionDet.ValueFrom3 = Convert.ToDecimal(dr["ValueFrom3"]);
}
if (!string.IsNullOrEmpty(dr["ValueTo3"].ToString()))
{
objAppLevelDefinitionDet.ValueTo3 = Convert.ToDecimal(dr["ValueTo3"]);
}
if (!string.IsNullOrEmpty(dr["NoOfAppLevel"].ToString()))
{
objAppLevelDefinitionDet.NoOfAppLevel = Convert.ToInt32(dr["NoOfAppLevel"]);
}
if (!string.IsNullOrEmpty(dr["OptionText1"].ToString()))
{
objAppLevelDefinitionDet.OptionText1_VW = dr["OptionText1"].ToString();
}
if (!string.IsNullOrEmpty(dr["OptionText2"].ToString()))
{
objAppLevelDefinitionDet.OptionText2_VW = dr["OptionText2"].ToString();
}
if (!string.IsNullOrEmpty(dr["OptionText3"].ToString()))
{
objAppLevelDefinitionDet.OptionText3_VW = dr["OptionText3"].ToString();
}
if (!string.IsNullOrEmpty(dr["ActiveYN"].ToString())) //added by Tinne
{
objAppLevelDefinitionDet.ActiveYN = Convert.ToInt32(dr["ActiveYN"]);
}
objI.objIAppLevelDefinitionDetList_VW.Add(objAppLevelDefinitionDet);
}
}
catch (DbException ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
