public static dynamic inChargesList(clusterMappingModel obj) { dynamic objdata = new ExpandoObject(); try { obj.type = "22"; DataTable dt = clusterMappingProc(obj); if (dt != null && dt.Rows.Count > 0) { objdata.success = true; objdata.result = dt; } else { objdata.success = false; objdata.result = "Clusters Not available for this secretariat"; } } catch (Exception ex) { objdata.success = false; objdata.result = ex.Message.ToString(); } return(objdata); }
public static DataTable clusterMappingProc(clusterMappingModel obj) { try { OracleCommand cmd = new OracleCommand(); cmd.InitialLONGFetchSize = 1000; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GSWS_VOLUNTEER_DATA_UPDATE"; cmd.Parameters.Add("P_TYPE", OracleDbType.Varchar2).Value = obj.type; cmd.Parameters.Add("P_DISTRICT_ID", OracleDbType.Varchar2).Value = obj.districtId; cmd.Parameters.Add("P_MANDAL_ID", OracleDbType.Varchar2).Value = obj.mandalId; cmd.Parameters.Add("P_SEC_ID", OracleDbType.Varchar2).Value = obj.secId; cmd.Parameters.Add("P_CLUSTER_ID", OracleDbType.Varchar2).Value = obj.clusterId; cmd.Parameters.Add("P_FLAG_U_R", OracleDbType.Varchar2).Value = obj.ruralUrbanFlag; cmd.Parameters.Add("P_CLUSTER_NAME", OracleDbType.Varchar2).Value = obj.clusterName; cmd.Parameters.Add("P_VOL_NAME", OracleDbType.Varchar2).Value = obj.volName; cmd.Parameters.Add("P_VOL_UID", OracleDbType.Varchar2).Value = obj.volUid; cmd.Parameters.Add("P_VOL_MOBILE", OracleDbType.Varchar2).Value = obj.volMobile; cmd.Parameters.Add("P_VOL_CFMS_ID", OracleDbType.Varchar2).Value = obj.volCfmsId; cmd.Parameters.Add("P_VOL_TYPE", OracleDbType.Varchar2).Value = obj.volType; cmd.Parameters.Add("P_USER_ID", OracleDbType.Varchar2).Value = obj.userId; cmd.Parameters.Add("P_PWD", OracleDbType.Varchar2).Value = obj.password; cmd.Parameters.Add("P_REASON", OracleDbType.Varchar2).Value = obj.reason; cmd.Parameters.Add("P_REMARKS", OracleDbType.Varchar2).Value = obj.remarks; cmd.Parameters.Add("p_cur", OracleDbType.RefCursor).Direction = ParameterDirection.Output; DataTable dtstatus = _Hel.GetgswsDataAdapter(cmd); return(dtstatus); } catch (Exception ex) { throw ex; } }
public IHttpActionResult inChargeUpdate(dynamic data) { string serialized_data = token_gen.Authorize_aesdecrpty(data); clusterMappingModel rootobj = JsonConvert.DeserializeObject <clusterMappingModel>(serialized_data); return(Ok(clusterMappingHelper.inChargeUpdate(rootobj))); }
public static dynamic inChargeUpdate(clusterMappingModel obj) { dynamic objdata = new ExpandoObject(); try { obj.type = "23"; DataTable dt = clusterMappingProc(obj); if (dt != null && dt.Rows.Count > 0 && dt.Rows[0][0].ToString() == "1") { objdata.success = true; objdata.result = dt; } else { objdata.success = false; objdata.result = "Failed to update Incharge, Please try again !!!"; } } catch (Exception ex) { objdata.success = false; objdata.result = ex.Message.ToString(); } return(objdata); }