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);
