public HttpResponseMessage getTN([FromBody] DTOParams dtoParams) { TableName tn = new TableName(); tn.city = dtoParams.params0; tn.setNewTableName(); return(Request.CreateResponse(HttpStatusCode.OK, "{\"TN\": \"" + tn.table + "\"}")); }
protected List <ArrayList> readMethod(string SQL, DTOParams dto) { init(SQL, dto); List <ArrayList> result = new ResultBinding(cmd).bindResult(); close(); return(result); }
public HttpResponseMessage vendorRegistration([FromBody] DTOParams dtoParams) /* * Creates vendor account * * params: * { * params0: (string) email, * params1: (string) contact, * params2: (string) name, * params3: (string) gender, * params4: (date) birthday, * params5: (integer) region id, * params6: (integer) province id, * params7: (integer) municipality id, * params8: (integer) barangay id, * params9: (string) address, * params10: (string) zip code, * params11: (integer) security question 1 id, * params12: (string) security question 1 answer, * params13: (integer) security question 2 id, * params14: (string) security question 2 answer, * params15: (string) password, * params16: (string) image, * params17: (string) store email, * params18: (string) store contact, * params19: (string) store name, * params20: (integer) store province id, * params21: (string) store address, * params22: (string) store zipcode, * params23: (string) store facebook, * params24: (string) store instagram, * params25: (string) store twitter, * params26: (boolean) store is always open?, * params27: (time) store opens, * params28: (time) store closes, * params29: (decimal) store longitude, * params30: (decimal) store latitude, * params31: (string) store image * count: 32 * } * * return: * { * message: Successful! * } */ { try { return(Request.CreateResponse(HttpStatusCode.OK, "{\"message\": \"Successful!\"}")); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message)); } }
protected void init(string SQL, DTOParams dto) { DBConf.openConnection(); cmd.Connection = DBConf.getConnection(); cmd.CommandText = SQL; StatementBinding stb = new StatementBinding(cmd); stb.bindStatement(dto); cmd = stb.getPreparedCommand(); }
public void setNewTableName() { DAOFactory factory = new DAOSeqTbl(); DTOParams dto = new DTOParams(); dto.params0 = city; dto.count = 1; List <ArrayList> result = factory.read(Constants.GETSEQUENCE, dto); table = "user_" + result[0][3].ToString() + "_" + DateTime.Now.Year; }
public HttpResponseMessage update([FromBody] DTOParams dtoParams) { try { model.update(dtoParams); return(Request.CreateResponse(HttpStatusCode.OK, "update ok! ")); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message)); } }
public List <DTOBarangay> getBarangays(DTOParams dtoParams) { List <DTOBarangay> listDTO = new List <DTOBarangay>(); List <ArrayList> result = dao.read(Constants.GETBARANGAYS, dtoParams); for (int x = 0; x < result.Count; x++) { DTOBarangay dto = new DTOBarangay(); dto.id = result[x][0].ToString(); dto.name = result[x][1].ToString(); listDTO.Add(dto); } return(listDTO); }
public List <DTOMunicipality> getMunicipalities(DTOParams dtoParams) { List <DTOMunicipality> listDTO = new List <DTOMunicipality>(); List <ArrayList> result = dao.read(Constants.GETMUNICIPALITIES, dtoParams); for (int x = 0; x < result.Count; x++) { DTOMunicipality dto = new DTOMunicipality(); dto.id = result[x][0].ToString(); dto.name = result[x][1].ToString(); listDTO.Add(dto); } return(listDTO); }
public List <DTOProvince> getProvinces(DTOParams dtoParams) { List <DTOProvince> listDTO = new List <DTOProvince>(); List <ArrayList> result = dao.read(Constants.GETPROVINCES, dtoParams); for (int x = 0; x < result.Count; x++) { DTOProvince dto = new DTOProvince(); dto.id = result[x][0].ToString(); dto.name = result[x][1].ToString(); listDTO.Add(dto); } return(listDTO); }
public void createLogin(DTOParams dtoParams) { DTOParams dtoLogin = new DTOParams(); dtoLogin.params0 = dtoParams.params0; dtoLogin.params1 = SaltString.RandomString(10, true); dtoLogin.params2 = Cipher.Encrypt(dtoParams.params1, dtoLogin.params1); TableName tn = new TableName(); tn.city = "1";//dtoParams.params4; tn.setNewTableName(); Console.Write(tn.table); //dtoLogin.params2 = }
public HttpResponseMessage riderRegistration([FromBody] DTOParams dtoParams) /* * Creates rider account * * params: * { * params0: (string) email, * params1: (string) contact, * params2: (string) name, * params3: (string) gender, * params4: (date) birthday, * params5: (integer) region id, * params6: (integer) province id, * params7: (integer) municipality id, * params8: (integer) barangay id, * params9: (string) address, * params10: (string) zip code, * params11: (integer) security question 1 id, * params12: (string) security question 1 answer, * params13: (integer) security question 2 id, * params14: (string) security question 2 answer, * params15: (string) password, * params16: (string) image, * params17: (string) motor model, * params18: (string) motor year, * params19: (string) moror color, * params20: (string) motor plate number, * params21: (string) motor image * count: 22 * } * * return: * { * message: Successful! * } */ { try { return(Request.CreateResponse(HttpStatusCode.OK, "{\"message\": \"Successful!\"}")); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message)); } }
public HttpResponseMessage barangays([FromBody] DTOParams dtoParams) /* * Gets all barangays by municipality id * * params: * { * params0: (integer) municipality id, * count: 1 * } * * return: * { * regions: [ * { * id: 1, * name: Poblacion I * }, * { * id: 2, * name: Poblacion II * }, * ] * } */ { try { List <DTOBarangay> listDTO = model.getBarangays(dtoParams); string response = JsonConvert.SerializeObject(listDTO); return(Request.CreateResponse(HttpStatusCode.OK, "{\"barangays\": " + response + "}")); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message)); } }
public HttpResponseMessage provinces([FromBody] DTOParams dtoParams) /* * Gets all provinces by region id * * params: * { * params0: (integer) region id, * count: 1 * } * * return: * { * regions: [ * { * id: 1, * name: Ilocos Norte * }, * { * id: 2, * name: Ilocos Sur * }, * ] * } */ { try { List <DTOProvince> listDTO = model.getProvinces(dtoParams); string response = JsonConvert.SerializeObject(listDTO); return(Request.CreateResponse(HttpStatusCode.OK, "{\"provinces\": " + response + "}")); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message)); } }
public HttpResponseMessage municipalities([FromBody] DTOParams dtoParams) /* * Gets all municipalities by province id * * params: * { * params0: (integer) province id, * count: 1 * } * * return: * { * regions: [ * { * id: 1, * name: Paco * }, * { * id: 2, * name: Pandacan * }, * ] * } */ { try { List <DTOMunicipality> listDTO = model.getMunicipalities(dtoParams); string response = JsonConvert.SerializeObject(listDTO); return(Request.CreateResponse(HttpStatusCode.OK, "{\"municipalities\": " + response + "}")); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message)); } }
public abstract void upsert(string SQL, DTOParams dto);
public void bindStatement(DTOParams dto) { switch (dto.count) { case 1: cmd.Parameters.AddWithValue("@params0", dto.params0); break; case 2: cmd.Parameters.AddWithValue("@params0", dto.params0); cmd.Parameters.AddWithValue("@params1", dto.params1); break; case 3: cmd.Parameters.AddWithValue("@params0", dto.params0); cmd.Parameters.AddWithValue("@params1", dto.params1); cmd.Parameters.AddWithValue("@params2", dto.params2); break; case 4: cmd.Parameters.AddWithValue("@params0", dto.params0); cmd.Parameters.AddWithValue("@params1", dto.params1); cmd.Parameters.AddWithValue("@params2", dto.params2); cmd.Parameters.AddWithValue("@params3", dto.params3); break; case 5: cmd.Parameters.AddWithValue("@params0", dto.params0); cmd.Parameters.AddWithValue("@params1", dto.params1); cmd.Parameters.AddWithValue("@params2", dto.params2); cmd.Parameters.AddWithValue("@params3", dto.params3); cmd.Parameters.AddWithValue("@params4", dto.params4); break; case 6: cmd.Parameters.AddWithValue("@params0", dto.params0); cmd.Parameters.AddWithValue("@params1", dto.params1); cmd.Parameters.AddWithValue("@params2", dto.params2); cmd.Parameters.AddWithValue("@params3", dto.params3); cmd.Parameters.AddWithValue("@params4", dto.params4); cmd.Parameters.AddWithValue("@params5", dto.params5); break; case 7: cmd.Parameters.AddWithValue("@params0", dto.params0); cmd.Parameters.AddWithValue("@params1", dto.params1); cmd.Parameters.AddWithValue("@params2", dto.params2); cmd.Parameters.AddWithValue("@params3", dto.params3); cmd.Parameters.AddWithValue("@params4", dto.params4); cmd.Parameters.AddWithValue("@params5", dto.params5); cmd.Parameters.AddWithValue("@params6", dto.params6); break; case 8: cmd.Parameters.AddWithValue("@params0", dto.params0); cmd.Parameters.AddWithValue("@params1", dto.params1); cmd.Parameters.AddWithValue("@params2", dto.params2); cmd.Parameters.AddWithValue("@params3", dto.params3); cmd.Parameters.AddWithValue("@params4", dto.params4); cmd.Parameters.AddWithValue("@params5", dto.params5); cmd.Parameters.AddWithValue("@params6", dto.params6); cmd.Parameters.AddWithValue("@params7", dto.params7); break; case 9: cmd.Parameters.AddWithValue("@params0", dto.params0); cmd.Parameters.AddWithValue("@params1", dto.params1); cmd.Parameters.AddWithValue("@params2", dto.params2); cmd.Parameters.AddWithValue("@params3", dto.params3); cmd.Parameters.AddWithValue("@params4", dto.params4); cmd.Parameters.AddWithValue("@params5", dto.params5); cmd.Parameters.AddWithValue("@params6", dto.params6); cmd.Parameters.AddWithValue("@params7", dto.params7); cmd.Parameters.AddWithValue("@params8", dto.params8); break; case 10: cmd.Parameters.AddWithValue("@params0", dto.params0); cmd.Parameters.AddWithValue("@params1", dto.params1); cmd.Parameters.AddWithValue("@params2", dto.params2); cmd.Parameters.AddWithValue("@params3", dto.params3); cmd.Parameters.AddWithValue("@params4", dto.params4); cmd.Parameters.AddWithValue("@params5", dto.params5); cmd.Parameters.AddWithValue("@params6", dto.params6); cmd.Parameters.AddWithValue("@params7", dto.params7); cmd.Parameters.AddWithValue("@params8", dto.params8); cmd.Parameters.AddWithValue("@params9", dto.params9); break; case 11: cmd.Parameters.AddWithValue("@params0", dto.params0); cmd.Parameters.AddWithValue("@params1", dto.params1); cmd.Parameters.AddWithValue("@params2", dto.params2); cmd.Parameters.AddWithValue("@params3", dto.params3); cmd.Parameters.AddWithValue("@params4", dto.params4); cmd.Parameters.AddWithValue("@params5", dto.params5); cmd.Parameters.AddWithValue("@params6", dto.params6); cmd.Parameters.AddWithValue("@params7", dto.params7); cmd.Parameters.AddWithValue("@params8", dto.params8); cmd.Parameters.AddWithValue("@params9", dto.params9); cmd.Parameters.AddWithValue("@params10", dto.params10); break; case 12: cmd.Parameters.AddWithValue("@params0", dto.params0); cmd.Parameters.AddWithValue("@params1", dto.params1); cmd.Parameters.AddWithValue("@params2", dto.params2); cmd.Parameters.AddWithValue("@params3", dto.params3); cmd.Parameters.AddWithValue("@params4", dto.params4); cmd.Parameters.AddWithValue("@params5", dto.params5); cmd.Parameters.AddWithValue("@params6", dto.params6); cmd.Parameters.AddWithValue("@params7", dto.params7); cmd.Parameters.AddWithValue("@params8", dto.params8); cmd.Parameters.AddWithValue("@params9", dto.params9); cmd.Parameters.AddWithValue("@params10", dto.params10); cmd.Parameters.AddWithValue("@params11", dto.params11); break; case 13: cmd.Parameters.AddWithValue("@params0", dto.params0); cmd.Parameters.AddWithValue("@params1", dto.params1); cmd.Parameters.AddWithValue("@params2", dto.params2); cmd.Parameters.AddWithValue("@params3", dto.params3); cmd.Parameters.AddWithValue("@params4", dto.params4); cmd.Parameters.AddWithValue("@params5", dto.params5); cmd.Parameters.AddWithValue("@params6", dto.params6); cmd.Parameters.AddWithValue("@params7", dto.params7); cmd.Parameters.AddWithValue("@params8", dto.params8); cmd.Parameters.AddWithValue("@params9", dto.params9); cmd.Parameters.AddWithValue("@params10", dto.params10); cmd.Parameters.AddWithValue("@params11", dto.params11); cmd.Parameters.AddWithValue("@params12", dto.params12); break; case 14: break; case 15: break; case 16: break; case 17: break; case 18: break; case 19: break; case 20: break; case 21: break; case 22: break; case 23: break; case 24: break; case 25: break; case 26: break; case 27: break; case 28: break; case 29: break; case 30: break; case 31: break; case 32: break; case 33: break; case 34: break; case 35: break; case 36: break; case 37: break; case 38: break; case 39: break; default: break; } }
public void update(DTOParams dto) { dao.upsert(Constants.TESTUPDATE, dto); }
public void insert(DTOParams dto) { dao.upsert(Constants.TESTINSERT, dto); }
public abstract List <ArrayList> read(string SQL, DTOParams dto);
public override void upsert(string SQL, DTOParams dto) { upsertMethod(SQL, dto); }
public override List <ArrayList> read(string SQL, DTOParams dto) { throw new NotImplementedException(); }
public override void delete(string SQL, DTOParams dto) { }
protected void upsertMethod(string SQL, DTOParams dto) { init(SQL, dto); cmd.ExecuteNonQuery(); close(); }
public override List <ArrayList> read(string SQL, DTOParams dto) { return(readMethod(SQL, dto)); }
protected void deleteMethod(string SQL, DTOParams dto) { }
public override void upsert(string SQL, DTOParams dto) { throw new NotImplementedException(); }
public abstract void delete(string SQL, DTOParams dto);