예제 #1
0
 public static DataTable citizenGrevProc(NewaadherModel obj)
 {
     try
     {
         OracleCommand cmd = new OracleCommand();
         cmd.InitialLONGFetchSize = 1000;
         cmd.CommandType          = CommandType.StoredProcedure;
         cmd.CommandText          = "GSWS_GRIEVIANCE_PROC";
         cmd.Parameters.Add("REPORT_TYPE", OracleDbType.Varchar2).Value        = obj.type;
         cmd.Parameters.Add("P_UID_NUM", OracleDbType.Varchar2).Value          = obj.uidNum;
         cmd.Parameters.Add("P_NAME", OracleDbType.Varchar2).Value             = obj.citizenName;
         cmd.Parameters.Add("P_GENDER", OracleDbType.Varchar2).Value           = obj.gender;
         cmd.Parameters.Add("P_DISTRICT_NAME", OracleDbType.Varchar2).Value    = obj.districtName;
         cmd.Parameters.Add("P_DISTRICT_ID", OracleDbType.Varchar2).Value      = obj.districtId;
         cmd.Parameters.Add("P_MANDAL_NAME", OracleDbType.Varchar2).Value      = obj.mandalName;
         cmd.Parameters.Add("P_MANDAL_ID", OracleDbType.Varchar2).Value        = obj.mandalId;
         cmd.Parameters.Add("P_SECRETARIAT_ID", OracleDbType.Varchar2).Value   = obj.secId;
         cmd.Parameters.Add("P_SECRETARIAT_NAME", OracleDbType.Varchar2).Value = obj.secId;
         cmd.Parameters.Add("P_MOBILE_NUMBER", OracleDbType.Varchar2).Value    = obj.mobileNumber;
         cmd.Parameters.Add("P_CLUSTER_ID", OracleDbType.Varchar2).Value       = obj.clusterId;
         cmd.Parameters.Add("P_CLUSTER_NAME", OracleDbType.Varchar2).Value     = obj.clusterName;
         cmd.Parameters.Add("P_STATUS", OracleDbType.Varchar2).Value           = obj.status;
         cmd.Parameters.Add("P_UPDATED_BY", OracleDbType.Varchar2).Value       = obj.updatedBy;
         cmd.Parameters.Add("P_CUR", OracleDbType.RefCursor).Direction         = ParameterDirection.Output;
         DataTable dtstatus = _Hel.GetProdgswsDataAdapter(cmd);
         return(dtstatus);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
예제 #2
0
        public static dynamic citizenUpdate(NewaadherModel obj)
        {
            dynamic objdata = new ExpandoObject();

            try
            {
                obj.type = "6";
                DataTable dt = citizenGrevProc(obj);
                if (dt != null && dt.Rows.Count > 0 && dt.Rows[0][0].ToString() == "1")
                {
                    objdata.success = true;
                    objdata.result  = "Citizen Details Mapped Successfully !!!";
                }
                else
                {
                    objdata.success = false;
                    objdata.result  = "Failed to submit details, Please try again !!!";
                }
            }
            catch (Exception ex)
            {
                string message = ex.Message.ToString();
                objdata.success = false;
                objdata.result  = message;
            }


            return(objdata);
        }
예제 #3
0
        public static dynamic secList(NewaadherModel obj)
        {
            dynamic objdata = new ExpandoObject();

            try
            {
                obj.type = "3";
                DataTable dt = citizenGrevProc(obj);
                if (dt != null && dt.Rows.Count > 0)
                {
                    objdata.success = true;
                    objdata.result  = dt;
                }
                else
                {
                    objdata.success = false;
                    objdata.result  = "No Secretariats available to load, Please try again !!!";
                }
            }
            catch (Exception ex)
            {
                objdata.success = false;
                objdata.result  = ex.Message.ToString();
            }
            return(objdata);
        }
예제 #4
0
        public static dynamic citizenDetailsSub(NewaadherModel obj)
        {
            dynamic objdata = new ExpandoObject();

            try
            {
                string captchaverify = new captchahelper().GetCaptchVerify(obj);
                if (captchaverify == "Success")
                {
                    obj.type = "4";
                    DataTable dt = citizenGrevProc(obj);
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        objdata.success = true;
                        objdata.result  = dt;

                        string message = "క్లస్టర్ నందు హౌస్ హోల్డ్ మాపింగ్ చేసుకొనుటకు మీ యొక్క రిక్వెస్ట్ ను మీ సచివాలయం యొక్క పంచాయితీ సెక్రటరీ కు పంపబడినది.\n";
                        message += "మీ యొక్క రిక్వెస్ట్ ఐ డి నెంబర్ : " + dt.Rows[0]["GREVIANCE_ID"].ToString() + "\n";
                        message += "పంచాయితీ సెక్రటరీ మొబైల్ నెంబర్ : " + dt.Rows[0]["MOBILE_NUMBER"].ToString() + "\n";
                        message += "సచివాలయం పేరు : " + dt.Rows[0]["SEC_NAME"].ToString() + "\n";
                        SMSService.SMSService objSMS = new SMSService.SMSService();
                        objSMS.SendTeluguSMS(obj.mobileNumber, message);
                    }
                    else
                    {
                        objdata.success = false;
                        objdata.result  = "Failed to submit details, Please try again !!!";
                    }
                }
                else
                {
                    objdata.Status = false;
                    objdata.result = "Invalid Captcha";
                }
            }
            catch (Exception ex)
            {
                string message = ex.Message.ToString();
                if (message.Contains("ORA-00001"))
                {
                    objdata.success = false;
                    objdata.result  = "Grevenance Aleary raised, Please contact your secretariat Panchayat Secretary !!!";
                }
                else
                {
                    objdata.success = false;
                    objdata.result  = message;
                }
            }


            return(objdata);
        }
예제 #5
0
        public IHttpActionResult districtList(dynamic data)
        {
            dynamic objdata = new ExpandoObject();

            try
            {
                string         serialized_data = JsonConvert.SerializeObject(data);
                NewaadherModel rootobj         = JsonConvert.DeserializeObject <NewaadherModel>(serialized_data);
                return(Ok(KYVHelper.districtList(rootobj)));
            }
            catch (Exception ex)
            {
                objdata.status = false;
                objdata.result = ex.Message.ToString();
            }
            return(Ok(objdata));
        }
예제 #6
0
        public IHttpActionResult citizenDetails(dynamic data)
        {
            dynamic objdata = new ExpandoObject();

            try
            {
                string         serialized_data = token_gen.Authorize_aesdecrpty(data);
                NewaadherModel rootobj         = JsonConvert.DeserializeObject <NewaadherModel>(serialized_data);
                return(Ok(KYVHelper.citizenDetails(rootobj)));
            }
            catch (Exception ex)
            {
                objdata.status = false;
                objdata.result = ex.Message.ToString();
            }
            return(Ok(objdata));
        }
예제 #7
0
        public IHttpActionResult citizenUpdate(dynamic data)
        {
            dynamic objdata = new ExpandoObject();

            try
            {
                string         serialized_data = token_gen.Authorize_aesdecrpty(data);
                string         mappath2        = HttpContext.Current.Server.MapPath("citizenUpdateLogs");
                Task           WriteTask       = Task.Factory.StartNew(() => new Logdatafile().Write_Log(mappath2, serialized_data));
                NewaadherModel rootobj         = JsonConvert.DeserializeObject <NewaadherModel>(serialized_data);
                return(Ok(KYVHelper.citizenUpdate(rootobj)));
            }
            catch (Exception ex)
            {
                objdata.status = false;
                objdata.result = ex.Message.ToString();
            }
            return(Ok(objdata));
        }