public static string getServiceType() { DataTable dt = Mydb.ExecuteReadertoDataTable("select * from SERVICE_TYPE where IS_DELETED=0", new SqlParameter[] { }, CommandType.Text); List <RequestTenant> rts = new List <RequestTenant>(); foreach (DataRow item in dt.Rows) { RequestTenant rt = new RequestTenant(); rt.ACCOUNT_NAME = item["SERVICE_TYPE_NAME"].ToString(); rt.NUMBER = item["SERVICE_TYPE_ID"].ToString(); rts.Add(rt); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(rts)); }
public static string Makefilter(List <TenantRFilter> flt, string score) { try { string STATUS_ID = null; string SERVICE_TYPE_ID = null; string REQUEST_ID = null; string Cr_S = null; string Cr_E = null; foreach (TenantRFilter item in flt) { STATUS_ID = (item.STATUS_ID.ToString() != "0") ? item.STATUS_ID.ToString() : null; SERVICE_TYPE_ID = (item.SERVICE_TYPE_ID == "0") ? null : item.SERVICE_TYPE_ID; REQUEST_ID = (item.REQUEST_ID == "") ? null : item.REQUEST_ID; Cr_E = (item.Cr_E == "") ? null : item.Cr_E; Cr_S = (item.Cr_S == "") ? null : item.Cr_S; } DataTable dt = Mydb.ExecuteReadertoDataTable("uspo_TenantRFiltering", new SqlParameter[] { new SqlParameter("@score", score), new SqlParameter("@STATUS_ID", STATUS_ID), new SqlParameter("@SERVICE_TYPE_ID", SERVICE_TYPE_ID), new SqlParameter("@REQUEST_ID", REQUEST_ID), new SqlParameter("@Cr_S", Cr_S), new SqlParameter("@Cr_E", Cr_E) }, CommandType.StoredProcedure); List <RequestTenant> rts = new List <RequestTenant>(); foreach (DataRow item in dt.Rows) { RequestTenant rt = new RequestTenant(); rt.FIRST_NAME = item["FIRST_NAME"].ToString(); rt.ROOM_T = item["REQUEST_ID"].ToString(); rt.ACCOUNT_NAME = item["CR_DATE"].ToString(); rt.ROOM_NUMBER = item["STATUS"].ToString(); rt.PHONE = item["STATUS_ID"].ToString(); rt.INDIVIDUAL_ID = item["DONE_DATE"].ToString(); rts.Add(rt); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(rts)); } catch (Exception ex) { return("{\"result\" : \"" + ex.ToString() + "\"}"); } }
public static string GetTenantRequestTable(string Score) { DataTable dt = Mydb.ExecuteReadertoDataTable("select * from VW_TENANT_REQUEST where OBJECT_ID=(select OBJECT_ID from ROOM where ROOM_ID=(select ROOM_ID from PER_SCORE where SCORE_ID=@s)) order by REQUEST_ID desc", new SqlParameter[] { new SqlParameter("@s", Score) }, CommandType.Text); List <RequestTenant> rts = new List <RequestTenant>(); foreach (DataRow item in dt.Rows) { RequestTenant rt = new RequestTenant(); rt.FIRST_NAME = item["FIRST_NAME"].ToString(); rt.ROOM_T = item["REQUEST_ID"].ToString(); rt.ACCOUNT_NAME = item["CR_DATE"].ToString(); rt.ROOM_NUMBER = item["STATUS"].ToString(); rt.PHONE = item["STATUS_ID"].ToString(); rt.INDIVIDUAL_ID = item["DONE_DATE"].ToString(); rts.Add(rt); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(rts)); }
public static string GetTRequestById(int rid) { DataTable dt = Mydb.ExecuteReadertoDataTable("select * from REQUEST where REQUEST_ID=@rid", new SqlParameter[] { new SqlParameter("@rid", rid) }, CommandType.Text); List <RequestTenant> rts = new List <RequestTenant>(); foreach (DataRow item in dt.Rows) { RequestTenant rt = new RequestTenant(); rt.ACCOUNT_NAME = item["STATUS_ID"].ToString(); rt.INDIVIDUAL_ID = item["INDIVIDUAL_ID"].ToString(); rt.NUMBER = item["COMFORDATE"].ToString(); rt.OBJECT_ID = item["COM_TIME_FROM"].ToString(); rt.ROOM_NUMBER = item["COM_TIME_TO"].ToString(); rt.PHONE = (item["OFFERED_DATE_FROM"].ToString() != "") ? (item["PLAN_END_TIME"].ToString() + "|" + item["PLAN_END_DATE"].ToString() + "|" + item["OFFERED_DATE_FROM"].ToString() + "|" + item["OFFERED_DATE_TO"].ToString() + "|" + item["OFFERED_TIME_FROM1"].ToString() + "|" + item["OFFERED_TIME_FROM2"].ToString() + "|" + item["OFFERED_TIME_TO1"].ToString() + "|" + item["OFFERED_TIME_TO2"].ToString()) : ""; rt.ROOM_T = item["CR_DATE"].ToString(); rt.FIRST_NAME = item["DONE_DATE"].ToString(); // rt.PHONE = + "|" + item["OFFERED_DATE_TO"].ToString() + "|" + item["OFFERED_TIME_FROM1"].ToString() + "|" + item["OFFERED_TIME_FROM2"].ToString() + "|" + item["OFFERED_TIME_TO1"].ToString() + "|" + item["OFFERED_TIME_TO1"].ToString(); rts.Add(rt); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(rts)); }
public static string GetRequestbyId(int Rid) { DataTable dt = Mydb.ExecuteReadertoDataTable("getRequest_SUPPLIER_byId", new SqlParameter[] { new SqlParameter("@R", Rid) }, CommandType.StoredProcedure); List <Request> rs = new List <Request>(); if (dt.Rows.Count != 0) { foreach (DataRow item in dt.Rows) { Request r = new Request(); //EMERGENCY_TREATMENT,PAYMENT,PLAN_END_DATE,PLAN_END_TIME r.EMERGENCY_TREATMENT = Convert.ToBoolean(item["EMERGENCY_TREATMENT"]); // r.PAYMENT = Convert.ToBoolean(item["PAYMENT"]); // r.ADRESS = item["ADRESS"].ToString(); // r.i_IND_PHONE_NUMBER = item["IND_PHONE_NUMBER"].ToString(); // r.im_FIRST_NAME = item["FIRST_NAME"].ToString(); // r.ROOM_T = item["ROOM_T"].ToString(); r.TOTAL_COST = item["TOTAL_COST"].ToString(); // r.PLAN_END_DATE = item["PLAN_END_DATE"].ToString(); // r.PLAN_END_TIME = item["PLAN_END_TIME"].ToString(); // // r.DELIVERY_TYPE_ID = Convert.ToInt32(item["DELIVERY_TYPE_ID"]);// r.SPECIALIS_ID = Convert.ToInt32(item["SPECIALIS_ID"]); // r.REQUEST_TEXT = item["REQUEST_TEXT"].ToString(); // // r.REQUEST_COMMENT = item["REQUEST_COMMENT"].ToString();// // r.COMMENT_FILE = item["COMMENT_FILE"].ToString();// r.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]); // r.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString(); // r.STATUS = item["STATUS_ID"].ToString(); // r.REQUEST_ID = Convert.ToInt32(item["REQUEST_ID"]); // r.ATRIBUTE = item["SPECIALIST_NAME"].ToString(); string ind = (item["INDIVIDUAL_ID"].ToString().Length == 0) ? "0" : item["INDIVIDUAL_ID"].ToString(); if (ind == "") { r.INDIVIDUAL_ID = 0; } else { r.INDIVIDUAL_ID = (item["INDIVIDUAL_ID"].ToString().Length == 0) ? 0 : Convert.ToInt32(item["INDIVIDUAL_ID"].ToString()); } r.SERVICE_NAME = item["NUMBER"].ToString(); r.TOTAL_COST = item["PHONE_NUMBER"].ToString(); r.SERVICE_GROUP_ID = (int)item["SERVICE_GROUP_ID"];// service Set r.ADRESS = item["OBJECT_ID"].ToString(); // r.ROOM_COUNT = Convert.ToInt32(item["ROOM_COUNT"]); r.ROOM_COUNT = Mydb.ExecuteReadertoDataTableAsJson("GetServices_SUPPLIERS_ByLevel", new SqlParameter[] { new SqlParameter("@R", r.REQUEST_ID) }, CommandType.StoredProcedure); rs.Add(r); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(rs)); } else { DataTable dt2 = Mydb.ExecuteReadertoDataTable("GetTenantRequest", new SqlParameter[] { new SqlParameter("@R", Rid) }, CommandType.StoredProcedure); List <RequestTenant> rsts = new List <RequestTenant>(); foreach (DataRow item in dt2.Rows) { RequestTenant rst = new RequestTenant(); rst.ROOM_T = item["ROOM_T"].ToString(); rst.ACCOUNT_NAME = "~"; rst.FIRST_NAME = item["FIRST_NAME"].ToString(); rst.NUMBER = item["NUMBER"].ToString(); rst.OBJECT_ID = item["OBJECT_ID"].ToString(); rst.PHONE = item["PHONE_NUMBER"].ToString(); rst.ROOM_NUMBER = item["ROOM_NUMBER"].ToString(); rst.INDIVIDUAL_ID = (item["INDIVIDUAL_ID"].ToString().Length == 0) ? "0" : item["INDIVIDUAL_ID"].ToString(); rst.SERVICE_GROUP_ID = (int)item["SERVICE_GROUP_ID"]; string comf = (item["COMFORDATE"].ToString().Length != 0) ? "|" + "Желаемая дата: (" + item["COMFORDATE"].ToString().Substring(0, item["COMFORDATE"].ToString().LastIndexOf(' ')) + ")\n Желаемое время : c (" + item["COM_TIME_FROM"].ToString().Substring(0, item["COM_TIME_FROM"].ToString().LastIndexOf(':')).Replace(':', '-') + ") по (" + item["COM_TIME_TO"].ToString().Substring(0, item["COM_TIME_TO"].ToString().LastIndexOf(':')).Replace(':', '-') + ")" : ""; rst.REQUEST_TEXT = (item["COMFORDATE"].ToString().Length == 0) ? item["REQUEST_TEXT"].ToString() : item["REQUEST_TEXT"].ToString() + comf; rst.EMERGENCY_TREATMENT = Convert.ToBoolean(item["EMERGENCY_TREATMENT"]); rst.PAYMENT = (item["PAYMENT"].ToString().Length == 0) ? false : Convert.ToBoolean(item["PAYMENT"]); rst.PLAN_END_DATE = item["PLAN_END_DATE"].ToString();; rst.PLAN_END_TIME = item["PLAN_END_TIME"].ToString(); rst.SPECIALIST_ID = (item["SPECIALIS_ID"].ToString().Length != 0) ? (int)item["SPECIALIS_ID"] : 0; rsts.Add(rst); } JavaScriptSerializer js2 = new JavaScriptSerializer(); return(js2.Serialize(rsts)); } }