public dynamic SearchRiceCard(RationInputs obj) { dynamic objdata = new ExpandoObject(); try { obj.ptype = "15"; obj.pration_id = obj.user_data[0].EXISTING_RC_NUMBER; DataTable dt = _RSP.RationVolunteerMappingProc(obj); if (dt != null && dt.Rows.Count > 0) { if (dt.Rows[0]["STATUS"].ToString() == "0") { objdata.status = 200; objdata.result = dt; } else { objdata.status = 400; objdata.result = "Rice card already assigned to " + dt.Rows[0]["DISTRICT_NAME"].ToString() + " District, " + dt.Rows[0]["MANDAL_NAME"].ToString() + " Mandal, " + dt.Rows[0]["SECRETARIAT_NAME"].ToString() + " Sachivalayam, " + dt.Rows[0]["CLUSTER_NAME"].ToString() + " cluster"; } } else { objdata.status = 400; objdata.result = "No Data Available"; } } catch (Exception ex) { objdata.status = 500; objdata.result = ex.Message.ToString(); } return(objdata); }
public dynamic loadClusters(RationInputs obj) { dynamic objdata = new ExpandoObject(); try { obj.ptype = "2"; DataTable dt = _RSP.RationVolunteerMappingProc(obj); if (dt != null && dt.Rows.Count > 0) { objdata.status = 200; objdata.result = dt; } else { objdata.status = 400; objdata.result = "No Data Available"; } } catch (Exception ex) { objdata.status = 500; objdata.result = ex.Message.ToString(); } return(objdata); }
public dynamic unassignRationToCluster(RationInputs obj) { dynamic objdata = new ExpandoObject(); try { obj.ptype = "8"; int count = _RSP.RationVolunteerMappingProc1(obj); if (count > 0) { objdata.status = 200; objdata.result = "Records Updated Successfully !!!"; } else { objdata.status = 400; objdata.result = "Failed to update records, Please try again !!!"; } } catch (Exception ex) { objdata.status = 500; objdata.result = ex.Message.ToString(); } return(objdata); }
public dynamic loadRationMembers(RationInputs obj) { dynamic objdata = new ExpandoObject(); try { obj.ptype = "1"; DataTable dt = _RSP.RationVolunteerMappingProc(obj); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { string rationId = dr["EXISTING_RC_NUMBER"].ToString(); if (rationIdChecker(rationId)) { rationIds.Add(rationId); } } for (int i = 0; i < rationIds.Count; i++) { rationMembersModel objrationMembersModel = new rationMembersModel(); List <memberData> listMemberData = new List <memberData>(); foreach (DataRow dr in dt.Rows) { string rationId = dr["EXISTING_RC_NUMBER"].ToString(); if (rationIds[i] == rationId) { memberData objMemberData = new memberData(); objMemberData.GT_GENDER = dr["GT_GENDER"].ToString(); objMemberData.MEMBER_NAME_EN = dr["MEMBER_NAME_EN"].ToString(); objMemberData.RS_NAME_EN = dr["RS_NAME_EN"].ToString(); objMemberData.SEC_ID = dr["SEC_ID"].ToString(); objMemberData.MOBILE_NUMBER = dr["MOBILENO"].ToString(); listMemberData.Add(objMemberData); } } objrationMembersModel.EXISTING_RC_NUMBER = rationIds[i]; objrationMembersModel.memberDatas = listMemberData; listrationMembersModel.Add(objrationMembersModel); } objdata.status = 200; objdata.result = listrationMembersModel; } else { objdata.status = 400; objdata.result = "Rice cards not Available for this secretariat or all rice cards in this secretariat are mapped !!!"; } } catch (Exception ex) { objdata.status = 500; objdata.result = ex.Message.ToString(); } return(objdata); }
public dynamic reqRiceCardToCluster(RationInputs obj) { dynamic objdata = new ExpandoObject(); try { obj.ptype = "12"; obj.pration_id = obj.user_data[0].EXISTING_RC_NUMBER; DataTable dt = _RSP.RationVolunteerMappingProc(obj); if (dt != null && dt.Rows.Count > 0 && dt.Rows[0][0].ToString() == "1") { objdata.status = 200; objdata.result = "Rice card adding request submitted Successfully !!!,Rice card added to cluster after approved by the JOINT COLLECTOR"; } else { objdata.status = 400; objdata.result = "Failed to submit request, Please try again !!!"; } } catch (Exception ex) { objdata.status = 500; objdata.result = ex.Message.ToString(); } return(objdata); }
public int RationVolunteerMappingProc1(RationInputs obj) { int count = 0; for (int i = 0; i < obj.user_data.Count; i++) { try { List <inputModel> listInputObj = new List <inputModel>(); inputModel inputObj = new inputModel(); inputObj.paramName = "ptype"; inputObj.value = obj.ptype; inputObj.dataType = "Varchar2"; listInputObj.Add(inputObj); inputModel inputObj1 = new inputModel(); inputObj1.paramName = "psec_id"; inputObj1.value = obj.psec_id.ToString(); inputObj1.dataType = "Varchar2"; listInputObj.Add(inputObj1); inputModel inputObj2 = new inputModel(); inputObj2.paramName = "pration_id"; inputObj2.value = obj.user_data[i].EXISTING_RC_NUMBER; inputObj2.dataType = "Varchar2"; listInputObj.Add(inputObj2); inputModel inputObj3 = new inputModel(); inputObj3.paramName = "pvv_id"; inputObj3.value = obj.pvv_id; inputObj3.dataType = "Varchar2"; listInputObj.Add(inputObj3); inputModel inputObj5 = new inputModel(); inputObj5.paramName = "pUPDATED_BY"; inputObj5.value = obj.pUPDATED_BY; inputObj5.dataType = "Varchar2"; listInputObj.Add(inputObj5); inputModel inputObj6 = new inputModel(); inputObj6.paramName = "pvv_name"; inputObj6.value = obj.pvv_name; inputObj6.dataType = "Varchar2"; listInputObj.Add(inputObj6); inputModel inputObj7 = new inputModel(); inputObj7.paramName = "pCLUSTER_ID"; inputObj7.value = obj.pCLUSTER_ID; inputObj7.dataType = "Varchar2"; listInputObj.Add(inputObj7); inputModel inputObj8 = new inputModel(); inputObj8.paramName = "pCLUSTER_NAME"; inputObj8.value = obj.pCLUSTER_NAME; inputObj8.dataType = "Varchar2"; listInputObj.Add(inputObj8); requestModel procObj = new requestModel(); procObj.refcursorName = "pcur"; procObj.procedureName = "GSWS_RATION_VV_MAPPING_PROC"; procObj.inputs = listInputObj; procObj.key = key; string json = JsonConvert.SerializeObject(procObj); DataTable dt = dbRouter.POST_Request(gswsTestUrl, json); if (dt != null && dt.Rows.Count > 0 && dt.Rows[0][0].ToString() == "1") { count = count + 1; } } catch (Exception ex) { string mappath = HttpContext.Current.Server.MapPath("rationVolunteerMappingProcedure"); string serialized_data = JsonConvert.SerializeObject(obj); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, serialized_data)); } } return(count); }
public DataTable RationVolunteerMappingProc(RationInputs obj) { try { List <inputModel> listInputObj = new List <inputModel>(); inputModel inputObj = new inputModel(); inputObj.paramName = "ptype"; inputObj.value = obj.ptype; inputObj.dataType = "Varchar2"; listInputObj.Add(inputObj); inputModel inputObj1 = new inputModel(); inputObj1.paramName = "psec_id"; inputObj1.value = obj.psec_id.ToString(); inputObj1.dataType = "Varchar2"; listInputObj.Add(inputObj1); inputModel inputObj2 = new inputModel(); inputObj2.paramName = "pration_id"; inputObj2.value = obj.pration_id; inputObj2.dataType = "Varchar2"; listInputObj.Add(inputObj2); inputModel inputObj3 = new inputModel(); inputObj3.paramName = "pvv_id"; inputObj3.value = obj.pvv_id; inputObj3.dataType = "Varchar2"; listInputObj.Add(inputObj3); inputModel inputObj5 = new inputModel(); inputObj5.paramName = "pUPDATED_BY"; inputObj5.value = obj.pUPDATED_BY; inputObj5.dataType = "Varchar2"; listInputObj.Add(inputObj5); inputModel inputObj6 = new inputModel(); inputObj6.paramName = "pvv_name"; inputObj6.value = obj.pvv_name; inputObj6.dataType = "Varchar2"; listInputObj.Add(inputObj6); inputModel inputObj7 = new inputModel(); inputObj7.paramName = "pCLUSTER_ID"; inputObj7.value = obj.pCLUSTER_ID; inputObj7.dataType = "Varchar2"; listInputObj.Add(inputObj7); inputModel inputObj8 = new inputModel(); inputObj8.paramName = "pCLUSTER_NAME"; inputObj8.value = obj.pCLUSTER_NAME; inputObj8.dataType = "Varchar2"; listInputObj.Add(inputObj8); requestModel procObj = new requestModel(); procObj.refcursorName = "pcur"; procObj.procedureName = "GSWS_RATION_VV_MAPPING_PROC"; procObj.inputs = listInputObj; procObj.key = key; string json = JsonConvert.SerializeObject(procObj); return(dbRouter.POST_Request(gswsTestUrl, json)); } catch (Exception ex) { string mappath = HttpContext.Current.Server.MapPath("rationVolunteerMappingProcedure"); string serialized_data = JsonConvert.SerializeObject(obj); Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, serialized_data)); throw ex; } }