public int UpdatePaymentDetails(serviceRequest data)
{
int paymentstatusid = data.paymentstatusid;
int customerid = data.customerid;
string orderguid = data.orderguid;
DataSet dt = new DataSet();
SqlConnection conn = new SqlConnection(cs);
conn.Open();
SqlCommand cmd = new SqlCommand("spUpdatePaymentByCustomerIDOrderGUID", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@customerID", customerid);
cmd.Parameters.AddWithValue("@orderGUID", orderguid);
cmd.Parameters.AddWithValue("@paymentStatusId", paymentstatusid);
int retval = cmd.ExecuteNonQuery();
return(retval);
}
public bool InsertService(serviceRequest serviceRequest, int user_id)
{
try
{
CommanDB procConn = new CommanDB();
OracleParameter[] param =
{
new OracleParameter("@p_SERVICE_ID", serviceRequest.SERVICE_ID),
new OracleParameter("@p_SRCX", serviceRequest.SRCX),
new OracleParameter("@p_SRCY", serviceRequest.SRCY),
new OracleParameter("@p_DESTX", serviceRequest.DESTX),
new OracleParameter("@p_DESTX", serviceRequest.DESTY),
new OracleParameter("@p_USER_ID", user_id)
};
procConn.RunProc("insertService_sp", param);
return(true);
}
catch (Exception ex)
{
throw new InsertException(language, ex.Message);
}
}
public Response FinishService(serviceRequest serviceRequest)
{
try
{
if (new ServicesRepository(language).FinishServiceRequest(serviceRequest.id, serviceRequest.RATE))
{
return(new Response(true, Messages.GetMessage(language, TypeM.SERVICE, serviceM.SERVICE_CANCEL)));
}
else
{
throw new UpdateException(language);
}
}
catch (UpdateException UpdateException)
{
return(new Response(false, UpdateException.RespMessage, UpdateException.ErrorMessage));
}
catch (Exception ex)
{
return(new Response(false, Messages.GetMessage(language, TypeM.DEFAULT, defaultM.UNEXPERROR), ex.Message.ToString()));
}
}
public Response CreateService(serviceRequest serviceRequest)
{
try
{
int user_id = new UserRepository.UserRepository(language).GetUserIdByAccessToken(serviceRequest.accessToken);
if (new ServicesRepository(language).InsertService(serviceRequest, user_id))
{
return(new Response(true, Messages.GetMessage(language, TypeM.SERVICE, serviceM.SERVICE_CREATE)));
}
else
{
throw new InsertException(language);
}
}
catch (InsertException InsertException)
{
return(new Response(false, InsertException.RespMessage, InsertException.ErrorMessage));
}
catch (Exception ex)
{
return(new Response(false, Messages.GetMessage(language, TypeM.DEFAULT, defaultM.UNEXPERROR), ex.Message.ToString()));
}
}
public bool InsertService(serviceRequest serviceRequest, int user_id)
{
return(new ServicesQuery(language).InsertService(serviceRequest, user_id));
}
public ActionResult <Response> FinishService([FromQuery(Name = "lang")] string lang, [FromBody] serviceRequest serviceRequest)
{
//check AccessToken
if (new UserService(lang).CheckAccessToken(serviceRequest.accessToken))
{
return(new ServciesService(lang).FinishService(serviceRequest));
}
else
{
return(new Response(false, Messages.GetMessage(lang, TypeM.DEFAULT, defaultM.WRONG_ACCESS_TOKEN)));
}
}
