public DataTable GetHabitationCode_SP(LGDMasterModel ObjLGD)
{
try
{
cmd = new OracleCommand();
cmd.InitialLONGFetchSize = 1000;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PR_GET_GSWS_PRRD_HAB_CODES";
cmd.Parameters.Add("P_TYPE", OracleDbType.Int32, 10).Value = ObjLGD.FTYPE;
cmd.Parameters.Add("P_LGD_DISTRICT_CODE", OracleDbType.Int32, 50).Value = ObjLGD.DISTCODE;
cmd.Parameters.Add("P_LGD_MANDAL_CODE", OracleDbType.Int32, 50).Value = ObjLGD.MandalCode;
cmd.Parameters.Add("P_PANCHAYAT_ID", OracleDbType.Varchar2, 50).Value = ObjLGD.GPCODE;
cmd.Parameters.Add("P_CUR", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
DataTable dtLogin = GetgswsDataAdapter(cmd);
if (dtLogin != null)
{
return(dtLogin);
}
else
{
return(null);
}
}
catch (Exception ex)
{
string mappath = HttpContext.Current.Server.MapPath("JobCardExceptions");
Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_Log_Exception(mappath, "Error GetHabitationCode_SP" + ex.Message.ToString()));
throw ex;
}
}
public dynamic LoadHabitationCode(LGDMasterModel oj)
{
dynamic obj = new ExpandoObject();
PRRDSPHelper spobj = new PRRDSPHelper();
try
{
DataTable dt = spobj.GetHabitationCode_SP(oj);
if (dt != null && dt.Rows.Count > 0)
{
obj.Status = 100;
obj.Reason = "";
obj.Details = dt;
}
else
{
obj.Status = 101;
obj.Reason = "No Data Found";
}
}
catch (Exception ex)
{
string mappath = HttpContext.Current.Server.MapPath("JobcardHelperExceptions");
Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_Log_Exception(mappath, "Error Getting LoadHabitationCode:" + ex.ToString()));
obj.Status = 102;
obj.Reason = "Error Occued While Loading Data";
return(obj);
}
return(obj);
}
public DataTable GetGSWS_SecretariatMaster_LGD_SP(LGDMasterModel ObjLGD) //type=6 and secc code to lgd code
{
try
{
cmd = new OracleCommand();
cmd.InitialLONGFetchSize = 1000;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GSWS_GET_SECRETARIAT_MASTER";
cmd.Parameters.Add("ftype", OracleDbType.Varchar2, 10).Value = ObjLGD.FTYPE;
cmd.Parameters.Add("FDIST_ID", OracleDbType.Varchar2, 50).Value = ObjLGD.DISTCODE;
cmd.Parameters.Add("FMANDAL_ID", OracleDbType.Varchar2, 50).Value = ObjLGD.MCODE;
cmd.Parameters.Add("P_CUR", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
DataTable dtLogin = GetProdgswsDataAdapter(cmd);
if (dtLogin != null && dtLogin.Rows.Count > 0)
{
return(dtLogin); //dtreturn dtLogin.Rows[0]["GP_CODE"].ToString();
}
else
{
return(null);
}
}
catch (Exception ex)
{
string mappath = HttpContext.Current.Server.MapPath("LoginSPExceptionLogs");
Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, "Error From GetLogin_SP:" + ex.Message.ToString()));
throw ex;
}
}
public dynamic GetHabitationCode(dynamic data)
{
string jsondata = token_gen.Authorize_aesdecrpty(data);
LGDMasterModel val = JsonConvert.DeserializeObject <LGDMasterModel>(jsondata);
LogModel ologmodel = new LogModel();
ologmodel.UserId = val.UserId;
ologmodel.SacId = val.SacId;
ologmodel.DesignId = val.DesignId;
ologmodel.DeptId = string.Empty;
ologmodel.TranId = val.TranId;
//olog.WriteLogParameters(ologmodel);
try
{
JobCardHelper hlpval = new JobCardHelper();
//_log.Info("In the RevenueController => GetRevenueMaster: " + jsondata.ToString());
return(Ok(hlpval.LoadHabitationCode(val)));
// return "SuccessEncryptDataModel
}
catch (Exception ex)
{
string mappath = HttpContext.Current.Server.MapPath("JobcardControllrExceptions");
Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_Log_Exception(mappath, "getting error GetHabitationCode :" + ex.Message.ToString()));
CatchData.Status = "Failure";
CatchData.Reason = CommonSPHel.ThirdpartyMessage;
return(Ok(CatchData));
}
}
public dynamic GetSecretariatVolunteerData(dynamic data)
{
string jsondata = token_gen.Authorize_aesdecrpty(data);
try
{
LGDMasterModel val = JsonConvert.DeserializeObject <LGDMasterModel>(jsondata);
return(Ok(_Loginhel.GetSeccVolunteerData(val)));
}
catch (Exception ex)
{
_response.Status = 102;
_response.Reason = ex.Message.ToString();
return(Ok(_response));
}
}
public dynamic GetGSWSSecretariatMaster(dynamic data)
{
string jsondata = token_gen.Authorize_aesdecrpty(data);
try
{
LGDMasterModel val = JsonConvert.DeserializeObject <LGDMasterModel>(jsondata);
return(Ok(_Loginhel.GetLgdmaster(val)));
// return "SuccessEncryptDataModel
}
catch (Exception ex)
{
_response.Status = 102;
_response.Reason = ex.Message.ToString();
return(Ok(_response));
}
}
public dynamic GetAllURLList(dynamic data)
{
string jsondata = token_gen.Authorize_aesdecrpty(data);
//string jsondata = JsonConvert.SerializeObject(data); //token_gen.Authorize_aesdecrpty(data);
try
{
LGDMasterModel val = JsonConvert.DeserializeObject <LGDMasterModel>(jsondata);
return(Ok(_Loginhel.getAllUrlData(val)));
// return "SuccessEncryptDataModel
}
catch (Exception ex)
{
_response.Status = 102;
_response.Reason = _Loginhel.ErrorMessage;
return(Ok(_response));
}
}
public dynamic GVDashboardData(dynamic data)
{
string jsondata = token_gen.Authorize_aesdecrpty(data);
//string jsondata = JsonConvert.SerializeObject(data);
try
{
LGDMasterModel val = JsonConvert.DeserializeObject <LGDMasterModel>(jsondata);
return(Ok(_Loginhel.getGVDashboard(val)));
// return "Success";
}
catch (Exception ex)
{
_response.Status = 102;
_response.Reason = ex.Message.ToString();
return(Ok(_response));
}
}
public dynamic LoadNICPanchayats_helper(dynamic objdata)
{
try
{
PRRDSPHelper spobj = new PRRDSPHelper();
LGDMasterModel objl = new LGDMasterModel();
objl.FTYPE = "6";
objl.DISTCODE = objdata.seccode;
var data = spobj.GetGSWS_SecretariatMaster_LGD_SP(objl);
objResponse.Status = "Success";
objResponse.data = data;
}
catch (Exception ex)
{
objResponse.Status = "Failed";
objResponse.data = CommonSPHel.ThirdpartyMessage;
}
return(objResponse);
}
public dynamic AuthentiateCall(dynamic jsonData)
{
dynamic responsedata = new ExpandoObject();
try
{
PRRDSPHelper spobj = new PRRDSPHelper();
LGDMasterModel objl = new LGDMasterModel();
var random = new Random();
int randomnumber = random.Next();
ServicePointManager.Expect100Continue = true;
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
System.Net.ServicePointManager.ServerCertificateValidationCallback = delegate(object sender, X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors) { return(true); };
string url = "https://mpanchayat.ap.gov.in/PIM/authenticateGs.do";
HttpClient client = new HttpClient();
client.BaseAddress = new Uri(url);
client.DefaultRequestHeaders.Accept.Clear();
MultipartFormDataContent content = new MultipartFormDataContent();
StringContent username = new StringContent("APITECGS", Encoding.UTF8, "multipart/form-data");
StringContent password = new StringContent(sha256_hash(sha256_hash("GSCPRRD#@2020") + randomnumber + Convert.ToString(jsonData.granttype) + Convert.ToString(jsonData.servicetype)), Encoding.UTF8, "multipart/form-data");
//StringContent password = new StringContent("GSCPRRD#@2020", Encoding.UTF8, "multipart/form-data");
StringContent gs_applid = new StringContent(randomnumber.ToString(), Encoding.UTF8, "multipart/form-data");
StringContent granttype = new StringContent(Convert.ToString(jsonData.granttype), Encoding.UTF8, "multipart/form-data");
StringContent servicetype = new StringContent(Convert.ToString(jsonData.servicetype), Encoding.UTF8, "multipart/form-data");
content.Add(username, "username");
content.Add(password, "password");
content.Add(gs_applid, "gs_applid");
content.Add(granttype, "granttype");
content.Add(servicetype, "servicetype");
HttpResponseMessage resp = client.PostAsync(url, content).Result;
string returnString = resp.Content.ReadAsStringAsync().Result;
if ((resp.StatusCode == HttpStatusCode.Redirect) || (resp.StatusCode == HttpStatusCode.SeeOther) ||
(resp.StatusCode == HttpStatusCode.RedirectMethod))
{
responsedata.Status = "Failed";
responsedata.data = "";
responsedata.Reason = "Invalid request Service is not Respond";
}
else
{
string data = returnString;
responsedata.Status = "Success";
responsedata.username = "******";
responsedata.servicetype = Convert.ToString(jsonData.servicetype);
responsedata.gs_applid = randomnumber;
//PRRDSPHelper spobj = new PRRDSPHelper();
//LGDMasterModel objl = new LGDMasterModel();
objl.FTYPE = "6";
objl.DISTCODE = jsonData.seccode;
//DataTable dt1=spobj.GetGSWS_SecretariatMaster_LGD_SP(objl);
//responsedata.lgdgpcode = spobj.GetGSWS_SecretariatMaster_LGD_SP(objl);
responsedata.data = JsonConvert.DeserializeObject <List <AuthenticateNOCMarriage> >(data);
}
}
catch (Exception ex)
{
string mappath = HttpContext.Current.Server.MapPath("PRRDExceptionLogs");
Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_Log_Exception(mappath, "Error Getting AuthentiateCall NOC Application Data API:" + ex.Message.ToString()));
//Logfile("Program:AuthentiateCall::Exception:CPID:" + cpkid, ex.Message, strPath);
responsedata.Status = "Failed";
responsedata.data = "";
responsedata.Reason = "Department Service is not Working.Please Try Again.";
Common_PRRD_Error(ex.Message.ToString(), "https://mpanchayat.ap.gov.in/PIM/authenticateGs.do", "2");
//return ex;
}
return(responsedata);
}
