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(); } }