/// <summary>
/// Initialize an instance of the Doc - endode as a jose string and add a signature
/// </summary>
/// <param name="json"> is a json string</param>
/// <param name="maxage"></param>
public async Task <string[]> SignCDR(ICredStoreSvc kss)
{
string[] jsonOut = new string[2];
try
{
CrRequest grq = new CrRequest {
request = encodedFirst2, action = Acts.sign
};
CrResponse grs = await kss.Proc(grq);
// CrResponse grOut = await kss.gClient.SimpleRequestAsync(
// new CrRequest { Request = encodedFirst2, Action = grqAct.Sign });
jsonOut[1] = grs.request; // the public key in json format
jsonOut[0] = encodedFirst2 + "." + grs.data; // TODO null
}
catch (Exception ex)
{
Base.JsonError jerr = new Base.JsonError
{
operation = "SignCDR in CredentialDocResult",
error = "Exeception on Client.SimpleRequestAsync " + ex.Message,
error_description = "TargetSite: " + ex.TargetSite.Name + " Source: " + ex.Source + " InnerEx: " + ex.InnerException
};
jsonOut[0] = JsonSerializer.Serialize(jerr);
}
return(jsonOut);
}
public static string SaveRequest(int slcObj, int IndId_, int Lg, string em, string Pdate, string Ptime, int spId, string Rt, List <ProductService_> prs, string Rc, List <REQUEST_COMMENT> Cf, string NUMBER, string opl, string phn, int HReq, int dId, int sid) //int Tc,
{
Rt = HttpUtility.UrlDecode(Rt);
Rt.Replace("\\", "");
Rc = HttpUtility.UrlDecode(Rc);
Rc = Rc.Replace(@"\", string.Empty);
int CrRequest;
if (IndId_ == 0)
{
//string files = "";
//if (Cf.Count != 0)
//{
// string domainName = HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority);
// files = domainName;
// for (int i = 0; i < Cf.Count; i++)
// {
// if (i == Cf.Count - 1)
// {
// files += Cf[i].COMMENT_FILE;
// }
// else
// {
// files += Cf[i].COMMENT_FILE + ",";
// }
// }
//}
// object MobileNumber = Mydb.ExecuteScalar("TestDB.dbo.sp_QUICK_API_new_request_add_autopilot2mobile", new SqlParameter[] {
// new SqlParameter("@object_id",slcObj),
// new SqlParameter("@number",NUMBER),
// new SqlParameter("@phone_number",phn),
// new SqlParameter("@request_text",Rt),
// new SqlParameter("@work_kind","490F9FEA-DB91-A9A4-4325-80F9006E94CC"),
// new SqlParameter("@files",files),
// new SqlParameter("@workdate",Pdate),
// new SqlParameter("@workbegin",Ptime),
// new SqlParameter("@workend",Ptime),
// new SqlParameter("@destination","")
//}, CommandType.StoredProcedure);
//int mn = Convert.ToInt32(MobileNumber);
int mn = 0;// Convert.ToInt32(MobileNumber);
Mydb.ExecuteNoNQuery("insert into REQUEST_SUPPLIERS (EMERGENCY_TREATMENT,PLAN_END_DATE,PLAN_END_TIME,SPECIALIS_ID,LOG_IN_ID,REQUEST_TEXT,CR_DATE,STATUS_ID,NUMBER,PAYMENT,SERVICE_GROUP_ID,MOBILE_NUMBER)values(@em,CAST(@Pdate as date),CAST(@Ptime as time(0) ),@spId,@lg,@Rt,GETDATE ( ),1,@NUMBER,@opl,@gs,@MOBILE_NUMBER)", new SqlParameter[] {
new SqlParameter("@em", Convert.ToBoolean(em)),
// new SqlParameter("@Adr",Adr),
// new SqlParameter("@indId",LastIndId),
// new SqlParameter("@DId",0),
new SqlParameter("@Pdate", Pdate),
new SqlParameter("@Ptime", Ptime),
new SqlParameter("@spId", spId),
new SqlParameter("@lg", Lg),
new SqlParameter("@Rt", Rt),
// new SqlParameter("@Tc",Tc),
// new SqlParameter("@CId",ClientId),
// new SqlParameter("@roomT",RoomT),
new SqlParameter("@NUMBER", NUMBER),
new SqlParameter("@opl", Convert.ToBoolean(opl)),
new SqlParameter("@gs", sid),
new SqlParameter("@MOBILE_NUMBER", mn)
}, CommandType.Text);
int LastReqId = (int)Mydb.ExecuteScalar("select top 1 REQUEST_ID from REQUEST_SUPPLIERS order by REQUEST_ID desc", new SqlParameter[] { }, CommandType.Text);
CrRequest = LastReqId;
foreach (ProductService_ item in prs)
{
Mydb.ExecuteNoNQuery("insert into REQUEST_SERVICE_SUPPLIERS (REQUEST_ID,P_SERVICE_ID,QUANTITY,COST,[LEVEL]) values (@Rid,@PId,@Q,@C,3)", new SqlParameter[] {
new SqlParameter("@Rid", LastReqId),
new SqlParameter("@PId", item.SERVICE_ID),
new SqlParameter("@Q", item.QUANTITY),
new SqlParameter("@C", item.COST),
},
CommandType.Text);
}
Mydb.ExecuteNoNQuery("insert into REQUEST_COMMENT_SUPPLIERS (REQUEST_COMMENT,REQUEST_ID) values(@RC,@Rid)", new SqlParameter[] { new SqlParameter("@Rc", Rc), new SqlParameter("@Rid", LastReqId)
//,new SqlParameter("@Cf",Cf)
}, CommandType.Text);
foreach (REQUEST_COMMENT item in Cf)
{
if (item.COMMENT_FILE != "0")
{
Mydb.ExecuteNoNQuery("insert into REQUEST_COMMENT_SUPPLIERS (COMMENT_FILE,REQUEST_ID) values (@Cf,@Rid)", new SqlParameter[] { new SqlParameter("@Cf", item.COMMENT_FILE), new SqlParameter("@Rid", LastReqId) }, CommandType.Text);
}
}
return("{\"RequestId\" : \"" + CrRequest.ToString() + "\"}");;
}
else
{
//string files = "";
//string domainName = HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority);
//if (Cf.Count != 0)
//{
// files = domainName;
// for (int i = 0; i < Cf.Count; i++)
// {
// if (i == Cf.Count - 1)
// {
// files += Cf[i].COMMENT_FILE;
// Cf[i].COMMENT_FILE = domainName + Cf[i].COMMENT_FILE;
// }
// else
// {
// files += Cf[i].COMMENT_FILE + ",";
// Cf[i].COMMENT_FILE = domainName + Cf[i].COMMENT_FILE;
// }
// }
//}
// object MobileNumber = Mydb.ExecuteScalar("TestDB.dbo.sp_QUICK_API_new_request_add_autopilot2mobile", new SqlParameter[] {
// new SqlParameter("@object_id",slcObj),
// new SqlParameter("@number",NUMBER),
// new SqlParameter("@phone_number",phn),
// new SqlParameter("@request_text",Rt),
// new SqlParameter("@work_kind","490F9FEA-DB91-A9A4-4325-80F9006E94CC"),
// new SqlParameter("@files",files),
// new SqlParameter("@workdate",Pdate),
// new SqlParameter("@workbegin",Ptime),
// new SqlParameter("@workend",Ptime),
// new SqlParameter("@destination","")
//}, CommandType.StoredProcedure);
int mn = 0;//Convert.ToInt32(MobileNumber);
Mydb.ExecuteNoNQuery("insert into REQUEST_SUPPLIERS (EMERGENCY_TREATMENT,INDIVIDUAL_ID,PLAN_END_DATE,PLAN_END_TIME,SPECIALIS_ID,LOG_IN_ID,REQUEST_TEXT,CR_DATE,STATUS_ID,NUMBER,PAYMENT,PHONE_NUMBER,SERVICE_GROUP_ID,MOBILE_NUMBER)values(@em,@indId,CAST(@Pdate as date),CAST(@Ptime as time(0) ),@spId,@lg,@Rt,GETDATE ( ),1,@NUMBER,@opl,@phn,@gs,@MOBILE_NUMBER )", new SqlParameter[] {
new SqlParameter("@em", Convert.ToBoolean(em)),
// new SqlParameter("@Adr",Adr),
new SqlParameter("@indId", IndId_),
//new SqlParameter("@DId",0),
new SqlParameter("@Pdate", Pdate),
new SqlParameter("@Ptime", Ptime),
new SqlParameter("@spId", spId),
new SqlParameter("@lg", Lg),
new SqlParameter("@Rt", Rt),
//new SqlParameter("@roomT",RoomT),
new SqlParameter("@NUMBER", NUMBER),
new SqlParameter("@opl", Convert.ToBoolean(opl)),
new SqlParameter("@phn", phn),
new SqlParameter("@gs", sid),
// new SqlParameter("@CId",ClientId),
new SqlParameter("@MOBILE_NUMBER", mn),
}, CommandType.Text);
int LastReqId = (int)Mydb.ExecuteScalar("select top 1 REQUEST_ID from REQUEST_SUPPLIERS order by REQUEST_ID desc", new SqlParameter[] { }, CommandType.Text);
CrRequest = LastReqId;
foreach (ProductService_ item in prs)
{
Mydb.ExecuteNoNQuery("insert into REQUEST_SERVICE_SUPPLIERS (REQUEST_ID,P_SERVICE_ID,QUANTITY,COST,[LEVEL]) values (@Rid,@PId,@Q,@C,3)", new SqlParameter[] {
new SqlParameter("@Rid", LastReqId),
new SqlParameter("@PId", item.SERVICE_ID),
new SqlParameter("@Q", item.QUANTITY),
new SqlParameter("@C", item.COST)
}, CommandType.Text);
}
if (Rc.Trim().Length != 0)
{
Mydb.ExecuteNoNQuery("insert into REQUEST_COMMENT_SUPPLIERS (REQUEST_COMMENT,REQUEST_ID) values(@RC,@Rid)", new SqlParameter[] {
new SqlParameter("@Rc", Rc),
new SqlParameter("@Rid", LastReqId)
//, new SqlParameter("@Cf",Cf)
}, CommandType.Text);
}
foreach (REQUEST_COMMENT item in Cf)
{
if (item.COMMENT_FILE != "0")
{
Mydb.ExecuteNoNQuery("insert into REQUEST_COMMENT_SUPPLIERS (COMMENT_FILE,REQUEST_ID) values (@Cf,@Rid)", new SqlParameter[] { new SqlParameter("@Cf", item.COMMENT_FILE), new SqlParameter("@Rid", LastReqId) }, CommandType.Text);
}
}
}
return("{\"RequestId\" : \"" + CrRequest.ToString() + "\"}");
}
