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