public DataTable GetJobCardDetailsbyTransIdandUID(JobCardModel Lobj)
{
try
{
cmd = new OracleCommand();
cmd.InitialLONGFetchSize = 1000;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PR_GET_GSWS_PRRD_JOB_CARD_DTLS";
cmd.Parameters.Add("P_TYPE", OracleDbType.Int32, 10).Value = 7;
cmd.Parameters.Add("P_JC_ID", OracleDbType.Varchar2, 500).Value = Lobj.P_JC_ID;
cmd.Parameters.Add("P_MANDAL_ID", OracleDbType.Varchar2, 50).Value = Lobj.P_LGD_MANDAL_CODE;
cmd.Parameters.Add("P_GP_ID", OracleDbType.Varchar2, 50).Value = Lobj.P_GP_ID;
cmd.Parameters.Add("P_SACHIVALAYAM_ID", OracleDbType.Varchar2, 50).Value = Lobj.P_SACHIVALAYAM_ID;
cmd.Parameters.Add("P_UID_NO", OracleDbType.Varchar2, 50).Value = Lobj.P_UID_NO;
cmd.Parameters.Add("P_USER_ID", OracleDbType.Varchar2, 50).Value = Lobj.P_USER_ID;
cmd.Parameters.Add("P_STATUS", OracleDbType.Varchar2, 50).Value = Lobj.P_STATUS;
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)
{
throw ex;
}
}
public DataTable UpdateStatus(JobCardModel ObjLGD)
{
try
{
cmd = new OracleCommand();
cmd.InitialLONGFetchSize = 1000;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PR_GET_GSWS_PRRD_JOB_CARD_DTLS";
cmd.Parameters.Add("P_TYPE", OracleDbType.Varchar2, 10).Value = ObjLGD.P_TYPE;
cmd.Parameters.Add("P_JC_ID", OracleDbType.Varchar2, 100).Value = ObjLGD.P_JC_ID;
cmd.Parameters.Add("P_MANDAL_ID", OracleDbType.Varchar2, 10).Value = ObjLGD.P_LGD_MANDAL_CODE;
cmd.Parameters.Add("P_GP_ID", OracleDbType.Varchar2, 10).Value = ObjLGD.P_GP_ID;
cmd.Parameters.Add("P_SACHIVALAYAM_ID", OracleDbType.Varchar2, 50).Value = ObjLGD.P_SACHIVALAYAM_ID;
cmd.Parameters.Add("P_UID_NO", OracleDbType.Varchar2, 50).Value = ObjLGD.P_UID_NO;
cmd.Parameters.Add("P_USER_ID", OracleDbType.Varchar2, 10).Value = ObjLGD.P_USER_ID;
cmd.Parameters.Add("P_STATUS", OracleDbType.Varchar2, 10).Value = ObjLGD.P_STATUS;
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 Getting Update Status:" + ex.Message.ToString()));
throw ex;
}
}
public dynamic GetJobCardDataHel(JobCardModel Lobj)
{
PRRDSPHelper spobj = new PRRDSPHelper();
dynamic objdata = new ExpandoObject();
try
{
//_log.Info("In the PRRDHelper=>GetJobCardData : " + JsonConvert.SerializeObject(Lobj));
DataTable dtLgd = spobj.GetJobCardSP(Lobj);
if (dtLgd != null && dtLgd.Rows.Count > 0)
{
objdata.Status = 100;
objdata.Reason = "Data Loaded successfully";
objdata.DataList = dtLgd;
}
else
{
objdata.Status = 102;
objdata.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, "getting error GetJobCardDataHel :" + ex.Message.ToString()));
objdata.Status = 102;
objdata.Reason = "Data not found";
}
return(objdata);
}
public dynamic UpdateJobcardStatus(JobCardModel ObjLGD)
{
dynamic obj = new ExpandoObject();
PRRDSPHelper spobj = new PRRDSPHelper();
try
{
DataTable dt = spobj.UpdateStatus(ObjLGD);
if (dt != null && dt.Rows.Count > 0)
{
obj.Status = 100;
obj.Reason = "";
obj.Jobcarddetails = 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, "getting error UpdateJobcardStatus :" + ex.Message.ToString()));
obj.Status = 102;
obj.Reason = "Error Occued While Loading Data";
return(obj);
}
return(obj);
}
public dynamic RejectJobcard(dynamic data)
{
string jsondata = token_gen.Authorize_aesdecrpty(data);
JobCardModel val = JsonConvert.DeserializeObject <JobCardModel>(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 hel = new JobCardHelper();
//_log.Info("In the PRRDController => EachJobCardData: " + jsondata.ToString());
return(Ok(hel.UpdateJobcardStatus(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 RejectJobcard :" + ex.Message.ToString()));
CatchData.Status = "Failure";
CatchData.Reason = CommonSPHel.ThirdpartyMessage;
return(Ok(CatchData));
}
}
public IHttpActionResult GetJobcardetails(dynamic data)
{
string value = token_gen.Authorize_aesdecrpty(data);
JobCardModel root = JsonConvert.DeserializeObject <JobCardModel>(value);
LogModel ologmodel = new LogModel();
ologmodel.UserId = root.UserId;
ologmodel.SacId = root.SacId;
ologmodel.DesignId = root.DesignId;
ologmodel.DeptId = ""; //Departments.Panchayati_Raj.ToString();
ologmodel.TranId = root.TranId;
//olog.WriteLogParameters(ologmodel);
JobCardHelper hlpval = new JobCardHelper();
try
{
//_log.Info("In the PRRDController => GetJobcardetails: " + value.ToString());
return(Ok(hlpval.GetJobcardetails(root)));
}
catch (Exception ex)
{
string mappath = HttpContext.Current.Server.MapPath("JobcardControllrExceptions");
Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_Log_Exception(mappath, "getting error GetJobcardetails :" + ex.Message.ToString()));
CatchData.Status = 102;
CatchData.Reason = "Error Occured While Getting Data";
return(Ok(CatchData));
}
}
public dynamic SendJobCardAPI(dynamic objdata)
{
dynamic objResponse = new ExpandoObject();
try
{
string ourtransid = objdata["data"][0]["InterfaceUniqueId"];
using (var client = new HttpClient())
{
ServicePointManager.Expect100Continue = true;
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
System.Net.ServicePointManager.ServerCertificateValidationCallback = delegate(object sender, X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors) { return(true); };
var req = (HttpWebRequest)WebRequest.Create(ConfigurationManager.AppSettings["ApiBaseAddress"].ToString() + "Rural-Development/v1/api/v1/ruralDevelopment");
req.ContentType = "application/json";
req.Method = "POST";
req.Headers.Add("Authorization", "Bearer 16cce3cd-15d5-3c19-8691-14203061b278");
req.AllowAutoRedirect = false;
string str = JsonConvert.SerializeObject(objdata);
str = str.Replace("null", "\"\"");
var _jsonObject = str;
//var _jsonObject = JsonConvert.SerializeObject(str);
string mappath = HttpContext.Current.Server.MapPath("SendJobcardAPIJSON");
Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_Log_Exception(mappath, "JSON :" + str));
if (!String.IsNullOrEmpty(_jsonObject))
{
using (System.IO.Stream s = req.GetRequestStream())
{
using (System.IO.StreamWriter sw = new System.IO.StreamWriter(s))
sw.Write(_jsonObject);
}
}
var resp = (HttpWebResponse)req.GetResponse();
var sr = new StreamReader(resp.GetResponseStream());
if ((resp.StatusCode == HttpStatusCode.Redirect) || (resp.StatusCode == HttpStatusCode.SeeOther) ||
(resp.StatusCode == HttpStatusCode.RedirectMethod))
{
objResponse.Status = "Failed";
objResponse.data = "";
}
else
{
string data = sr.ReadToEnd().Trim();
if (!data.Contains("An error has occurred"))
{
List <JobCardAPIModel> objjobcard = new List <JobCardAPIModel>();
//objResponse.Status = "Success";
objjobcard = JsonConvert.DeserializeObject <List <JobCardAPIModel> >(data);
string outputdata = string.Empty;
objResponse.data = objjobcard;
foreach (var item in objjobcard)
{
outputdata += item.Remarks + "/";
}
objResponse.REASON = outputdata.TrimEnd('/');
objResponse.Status = objjobcard[0].Transactionid;
if (objResponse.Status != "")
{
try
{
transactionModel objtrans = new transactionModel();
objtrans.TYPE = "2";
objtrans.TXN_ID = ourtransid;
objtrans.DEPT_ID = "3301";
objtrans.DEPT_TXN_ID = objjobcard[0].Transactionid;
objtrans.STATUS_CODE = "01";
objtrans.REMARKS = objjobcard[0].Remarks;
DataTable dt = new transactionHelper().transactionInsertion(objtrans);
JobCardModel updatestatus = new JobCardModel();
updatestatus.P_TYPE = "11";
updatestatus.P_JC_ID = ourtransid;
updatestatus.P_STATUS = "1";
UpdateJobcardStatus(updatestatus);
}
catch (Exception ex)
{
string mappath3 = HttpContext.Current.Server.MapPath("JobcardHelperExceptions");
Task WriteTask3 = Task.Factory.StartNew(() => new Logdatafile().Write_Log_Exception(mappath3, "Send Jobcard API Error:" + ex.Message.ToString()));
}
}
}
else
{
objResponse.Status = "428";
objResponse.REASON = CommonSPHel.ThirdpartyMessage;
}
}
}
}
catch (WebException ex)
{
string mappath = HttpContext.Current.Server.MapPath("JobcardHelperExceptions");
Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_Log_Exception(mappath, "Error Getting Send Jobcard API :" + ex.Message.ToString()));
objResponse.Status = "Failed";
objResponse.REASON = CommonSPHel.ThirdpartyMessage;
}
return(objResponse);
}