public static string UpdateMeter(int METERS_ID, int ROOM_TYPE_ID, string ROOM_NUMBER, string SCORE_ID, string METERS_NUMBER, int TYPE_ID, int AMUNT_TARIF, string PREVIOUS_DATE, string NEXT_DATE, string IS_AUTO)
{
//Mydb.ExecuteNoNQuery("UPDATE METERS SET ROOM_TYPE_ID=@ROOM_TYPE_ID,SCORE_ID=@SCORE_ID,METERS_NUMBER=@METERS_NUMBER,TYPE_ID=@TYPE_ID,AMUNT_TARIF=@AMUNT_TARIF,PREVIOUS_DATE=@PREVIOUS_DATE,NEXT_DATE=@NEXT_DATE WHERE METERS_ID=@METERS_ID", new SqlParameter[] {new SqlParameter("@ROOM_TYPE_ID",ROOM_TYPE_ID),
// new SqlParameter("@SCORE_ID",SCORE_ID),
// new SqlParameter("@METERS_NUMBER",METERS_NUMBER),
// new SqlParameter("@AMUNT_TARIF",AMUNT_TARIF),
// new SqlParameter("@PREVIOUS_DATE",PREVIOUS_DATE),
// new SqlParameter("@NEXT_DATE",NEXT_DATE),
// new SqlParameter("@TYPE_ID",TYPE_ID),
// new SqlParameter("@ROOM_NUMBER",ROOM_NUMBER),new SqlParameter("@METERS_ID",METERS_ID)
// }, CommandType.Text);
//string historyText = "Данные счетчика были изменены";
//Mydb.ExecuteNoNQuery("insert into METERS_HISTORY(DATETIME,EVENT,AUTHOR,FILE_,METERS_ID) values( CONVERT(date, getdate()),@historyText,(select ACCOUNT_NAME from ACCOUNT where LOG_IN_ID = (select LOG_IN_ID from VW_METERS where METERS_ID=@mid)),'-',@METERS_ID)", new SqlParameter[] { new SqlParameter("@historyText", historyText), new SqlParameter("@mid", METERS_ID), new SqlParameter("@METERS_ID", METERS_ID) }, CommandType.Text);
Mydb.ExecuteNoNQuery("UpdateMeter", new SqlParameter[] { new SqlParameter("@ROOM_TYPE_ID", ROOM_TYPE_ID),
new SqlParameter("@SCORE_ID", SCORE_ID),
new SqlParameter("@METERS_NUMBER", METERS_NUMBER),
new SqlParameter("@AMUNT_TARIF", AMUNT_TARIF),
new SqlParameter("@PREVIOUS_DATE", PREVIOUS_DATE),
new SqlParameter("@NEXT_DATE", NEXT_DATE),
new SqlParameter("@TYPE_ID", TYPE_ID),
new SqlParameter("@ROOM_NUMBER", ROOM_NUMBER),
new SqlParameter("@METERS_ID", METERS_ID),
new SqlParameter("@IS_AUTO", IS_AUTO) }, CommandType.StoredProcedure);
return("");
}
public static string GetAccDetail(int LogId_)
{
DataTable dtAcc = Mydb.ExecuteReadertoDataTable("select * from ACCOUNT where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", LogId_) }, CommandType.Text);
List <Account_> accs = new List <Account_>();
foreach (DataRow item in dtAcc.Rows)
{
Account_ acc = new Account_();
acc.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
acc.E_MAIL = item["E_MAIL"].ToString();
acc.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
// acc.MODULE_ROLES = item["MODULE_ROLES"].ToString();
acc.PASSWORD = item["PASSWORD"].ToString();
acc.PHONE_NUMBER = item["PHONE_NUMBER"].ToString();
acc.LOGIN = item["LOGIN"].ToString();
accs.Add(acc);
}
JavaScriptSerializer js_accs = new JavaScriptSerializer();
int COuntOf_Mr = (int)Mydb.ExecuteScalar("select COUNT(*)from ACCOUNT_ROLE where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", LogId_) }, CommandType.Text);
return(js_accs.Serialize(accs));
}
public string GetDailInf(int rfpId, int obj)
{
//DataTable dt = Mydb.ExecuteReadertoDataTable("select dt.ACCURED_SUMM,dt.PAYED,dt.PAY_GUID,rs.SERVICE_NAME from DETAIL_INF dt inner join RFP_SERVICES rs on rs.RFP_SERVICE_ID=dt.RFP_SERVICE_ID and dt.RECIEPT_FOR_PAYMENT_ID=@rfpId", new SqlParameter[] { new SqlParameter("@rfpId", rfpId) }, CommandType.Text);
DataTable dt = Mydb.ExecuteReadertoDataTable("GetDailInf", new SqlParameter[] { new SqlParameter("@rfpId", rfpId) }, CommandType.StoredProcedure);
List <Payment_Details> pds = new List <Payment_Details>();
Payment_Details p_d = new Payment_Details();
p_d.PAYMENT_SUM = Mydb.ExecuteScalar("TestDB.dbo.sp_QUICK_API_get_shopId", new SqlParameter[] { new SqlParameter("@tokenid", ""), new SqlParameter("@login", ""), new SqlParameter("@obj", obj) }, CommandType.StoredProcedure).ToString();
pds.Add(p_d);
foreach (DataRow item in dt.Rows)
{
Payment_Details pd = new Payment_Details();
pd.ACCURED_SUMM = item["ACCURED_SUMM"].ToString();
pd.SERVICE_NAME = item["SERVICE_NAME"].ToString();
pd.PAYMENT_SUM = item["PAYED"].ToString();
pd.PAY_GUID = item["PAY_GUID"].ToString();
pd.VOLUME = item["VOLUME"].ToString();
pd.EDIZM = item["EDIZM"].ToString();
pd.TARIF = item["TARIF"].ToString();
pd.PRIVILEGES = item["PRIVILEGES"].ToString();
pd.RECALCULATIONS = item["RECALCULATIONS"].ToString();
pds.Add(pd);
}
return(JsonConvert.SerializeObject(pds));
}
public static string GetTexniksAndothers(int lg)
{
int DispId = (int)Mydb.ExecuteScalar("select DISP_ID from DISP_ACC where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", lg) }, CommandType.Text);
DataTable dt = Mydb.ExecuteReadertoDataTable("select a.LOG_IN_ID,a.ACCOUNT_NAME,da.ROLE_ID from ACCOUNT a , DISP_ACC da where da.DISP_ID=@d and(da.ROLE_ID=6 or ROLE_ID=2 or ROLE_ID=15) and da.LOG_IN_ID=a.LOG_IN_ID", new SqlParameter[] { new SqlParameter("@d", DispId) }, CommandType.Text);
List <Account_> accs = new List <Account_>();
//string currdispname = Mydb.ExecuteScalar("select ACCOUNT_NAME from ACCOUNT where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", lg) }, CommandType.Text).ToString();
//Account_ ac_c = new Account_();
//ac_c.LOG_IN_ID = lg;
//ac_c.ACCOUNT_NAME = currdispname;
//ac_c.RS = "3";
//accs.Add(ac_c);
foreach (DataRow item in dt.Rows)
{
Account_ acc = new Account_();
acc.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
acc.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
acc.RS = item["ROLE_ID"].ToString();
accs.Add(acc);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(accs));
}
public static string Super_Supplier_Requests()
{
System.Data.DataTable dt = Mydb.ExecuteReadertoDataTable("Super_Supplier_Requests", new SqlParameter[] {}, CommandType.StoredProcedure);
List <Request> rs = new List <Request>();
foreach (DataRow item in dt.Rows)
{
Request r = new Request();
r.ACCOUNT_NAME = item["SUPPLIER"].ToString();
// r.ROOM_TYPE = item["ROOM_TYPE"].ToString();
r.CR_DATE = item["CRDATE"].ToString();
r.REQUEST_ID = Convert.ToInt32(item["ID"]);
r.REQUEST_TEXT = item["COMMENT"].ToString();
// r.SERVICE_NAME = item["SERVICE_NAME"].ToString();
r.STATUS = item["STATUS"].ToString();
r.PLAN_END_DATE = item["WORKDATE"].ToString();
r.ATRIBUTE = item["GUID"].ToString();
r.FIRST_NAME = item["CLIENT"].ToString();
r.STATUS_ID = item["STATUS_ID"].ToString();
r.REQUEST_COMMENT = item["PAYED"].ToString();
// r.EMERGENCY_TREATMENT = (item["ORDER"].ToString() == "1") ? true : false; //(bool)item["EMERGENCY_TREATMENT"];
r.ADRESS = item["OBJECT"].ToString();
rs.Add(r);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(rs));
}
public static string DeleteDirection(string d_guid)
{
//Mydb.ExecuteNoNQuery("delete from SELECTED_SERVICE_SET_ICON where SSS_ID=@sid and PROJECT_ID=@prj", new SqlParameter[] { new SqlParameter("@sid",sid),
// new SqlParameter("@prj",prj) }, CommandType.Text);
Mydb.ExecuteNoNQuery("DeleteDirection", new SqlParameter[] { new SqlParameter("@d_guid", d_guid) }, CommandType.StoredProcedure);
return("");
}
public string getMetersValues(int mid)
{
return(Mydb.ExecuteAsJson("GetLastValueAndAVG_of_Meters", new SqlParameter[] { new SqlParameter("@id", mid) }, CommandType.StoredProcedure));
//DataTable dt = Mydb.ExecuteReadertoDataTable("select top 1 * from METER_VALUE where METERS_ID=@mid order by DATE_ desc", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.Text);
//List<METERS> ms = new List<METERS>();
//METERS m2 = new METERS();
//m2.AMUNT_TARIF = Mydb.ExecuteScalar("select AMUNT_TARIF from METERS where METERS_ID=@mid", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.Text).ToString();
//ms.Add(m2);
//foreach (DataRow item in dt.Rows)
//{
// // AMUNT_TARIF/VALUE_
// // LOG_IN_ID/VALUE_2
// // METERS_ID/VALUE_3
// // NEXT_DATE/DATE_
// METERS m = new METERS();
// m.AMUNT_TARIF = item["VALUE_"].ToString();
// m.LOG_IN_ID = item["VALUE_2"].ToString();
// m.METERS_ID = item["VALUE_3"].ToString();
// m.NEXT_DATE = item["DATE_"].ToString();
// ms.Add(m);
//}
//return JsonConvert.SerializeObject(ms);
}
public static string SearchLog(int l_g, string Stext, int Cl)
{
if (Stext.Contains("|"))
{
Stext.Replace("|", ":");
}
DataTable dt = Mydb.ExecuteReadertoDataTable("Orx_Search_Log", new SqlParameter[] { new SqlParameter("@C", l_g), new SqlParameter("@Stext", Stext) }, CommandType.StoredProcedure);
List <LOG_GLOBAL> lgs = new List <LOG_GLOBAL>();
foreach (DataRow item in dt.Rows)
{
LOG_GLOBAL lg = new LOG_GLOBAL();
lg.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
lg.DATESTAMP = item["DATESTAMP"].ToString();
lg.EVENT_MAKER = item["EVENT_MAKER"].ToString();
lg.EVENT_MESSAGE = item["EVENT_MESSAGE"].ToString();
lg.EVENT_MODULE = item["EVENT_MODULE"].ToString();
lg.EVENT_ROLE = item["EVENT_ROLE"].ToString();
lg.EVENT_STATUS = item["EVENT_STATUS"].ToString();
lg.EVENT_TYPE = item["EVENT_TYPE"].ToString();
lg.E_MAIL = item["E_MAIL"].ToString();
lg.id = item["id"].ToString();
lgs.Add(lg);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(lgs));
}
public static string GetNotDispAcc(int ClId, int DD)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("select LOG_IN_ID,ACCOUNT_NAME from ACCOUNT where CLIENT_ID=@c and LOGIN is not null and LOG_IN_ID in (select LOG_IN_ID from ACCOUNT_ROLE where MR_ID in (select MR_ID from MODUL_ROLE where ROLE_ID=6 or ROLE_ID=2 or ROLE_ID=3))", new SqlParameter[] { new SqlParameter("@c", ClId) }, CommandType.Text);
//List<Account_> ass = new List<Account_>();
List <Account_Disp> ads = new List <Account_Disp>();
foreach (DataRow item in dt.Rows)
{
// Account_ a = new Account_();//
Account_Disp ad = new Account_Disp();
int Countlog = (int)Mydb.ExecuteScalar("select count(*) from DISP_ACC where LOG_IN_ID=@lg ", new SqlParameter[] { new SqlParameter("@lg", Convert.ToInt32(item["LOG_IN_ID"])) }, CommandType.Text);//, new SqlParameter("@d", DD) and DISP_ID=@d
if (Countlog == 0)
{
//a.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
//a.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
//a.ENTITY_TYPE_ID = (int)Mydb.ExecuteScalar("select ROLE_ID from MODUL_ROLE where MR_ID=(select MR_ID from ACCOUNT_ROLE where LOG_IN_ID=@lg)", new SqlParameter[] { new SqlParameter("@lg", a.LOG_IN_ID) }, CommandType.Text);
//ass.Add(a);
ad.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
ad.LOG_IN_ID = item["LOG_IN_ID"].ToString();
DataTable dtRoles = Mydb.ExecuteReadertoDataTable("select ROLE_ID from MODUL_ROLE where MR_ID in (select MR_ID from ACCOUNT_ROLE where LOG_IN_ID=@lg)", new SqlParameter[] { new SqlParameter("@lg", Convert.ToInt32(ad.LOG_IN_ID)) }, CommandType.Text);
List <Roles> rls = new List <Roles>();
foreach (DataRow itemrls in dtRoles.Rows)
{
Roles rl = new Roles();
rl.ROLE_ID = Convert.ToInt32(itemrls["ROLE_ID"]);
rls.Add(rl);
}
ad.roles = rls;
ads.Add(ad);
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(ads));
}
public static string GetDispsRequests(int lg, int role, int all)
{
//
//DataTable dt = Mydb.ExecuteReadertoDataTable("GetRequests_by_Role", new SqlParameter[] { new SqlParameter("@lg", lg), new SqlParameter("@role", role), new SqlParameter("@all", all) }, CommandType.StoredProcedure);
//List<Kvorum_App.Super_Disp.Helpers.Request> reqs = new List<Helpers.Request>();
//foreach (DataRow item in dt.Rows)
//{
// Helpers.Request req = new Helpers.Request();
// req.MOBILE_NUMBER = item["MOBILE_NUMBER"].ToString();
// req.FIRST_NAME = item["FIRST_NAME"].ToString();
// req.OBJECT_ADRESS = item["OBJECT_ADRESS"].ToString();
// req.ROOM_NUMBER = item["ROOM_NUMBER"].ToString();
// req.CR_DATE = item["CR_DATE"].ToString();
// req.CR_DATE = req.CR_DATE.Substring(0, 10);
// req.REQUEST_TEXT = item["REQUEST_TEXT"].ToString();
// req.PLAN_END_DATE = item["PLAN_END_DATE"].ToString();
// req.REQUEST_TYPE = item["REQUEST_TYPE"].ToString();
// req.STATUS = item["STATUS"].ToString();
// req.RESPONSIBLE_NAME = item["RESPONSIBLE_NAME"].ToString();
// req.PAYMENT = item["PAYMENT"].ToString();
// req.RREQUEST_ID = item["REQUEST_ID"].ToString();
// req.STATUS_ID = item["STATUS_ID"].ToString();
// reqs.Add(req);
//}
//JavaScriptSerializer js = new JavaScriptSerializer(); js.Serialize(reqs);
return(Mydb.ExecuteAsJson("GetRequests_by_Role", new SqlParameter[] { new SqlParameter("@lg", lg), new SqlParameter("@role", role), new SqlParameter("@all", all) }, CommandType.StoredProcedure));//GetDispsRequests;//
}
void CheckGuid()
{
int Id = Convert.ToInt32(Request.QueryString["Id"]);
string g_url = Request.QueryString["g"];
if (g_url != null)
{
string g_client = Mydb.ExecuteScalar("select GUID from CLIENT where CLIENT_ID=@Id", new SqlParameter[] { new SqlParameter("@Id", Id) }, CommandType.Text).ToString();
if (g_client != g_url)
{
//Response.Redirect("Client_Admin/AlertingError.aspx?reason=g&chp=notC");
string redirc = "../Client_Admin/AlertingError.aspx?reason=g&chp=notC";
Response.Redirect(redirc);
}
else
{
Mydb.ExecuteNoNQuery("update CLIENT set VERIFICATION_=1,GUID=NEWID() where CLIENT_ID=@Id", new SqlParameter[] { new SqlParameter("@Id", Id) }, CommandType.Text);
int Acc_Id = (int)Mydb.ExecuteScalar("select LOG_IN_ID from ACCOUNT where CLIENT_ID=@Id", new SqlParameter[] { new SqlParameter("@Id", Id) }, CommandType.Text);
Mydb.ExecuteNoNQuery("insert into MODUL_ROLE (ROLE_ID,MODUL_ID) values(4,3)", new SqlParameter[] { }, CommandType.Text);
int Last_Mr = (int)Mydb.ExecuteScalar("SELECT TOP 1 MR_ID FROM MODUL_ROLE ORDER BY MR_ID DESC", new SqlParameter[] { }, CommandType.Text);
Mydb.ExecuteNoNQuery("insert into ACCOUNT_ROLE (LOG_IN_ID, MR_ID) VALUES(@A,@mr)", new SqlParameter[] { new SqlParameter("@A", Acc_Id), new SqlParameter("@mr", Last_Mr) }, CommandType.Text);
}
}
}
public string getObjectId(string adr, string loc)
{
int prjId = 0;
if (loc.Contains("/Fili/LoginF.aspx"))
{
prjId = 3;
}
if (loc.Contains("/Symbol/LoginS.aspx"))
{
prjId = 2;
}
int count = (int)Mydb.ExecuteScalar("select COUNT(*) from OBJECT where OBJECT_ADRESS = @adr and PROJECT_ID=@prj", new SqlParameter[] { new SqlParameter("@adr", adr), new SqlParameter("@prj", prjId) }, CommandType.Text);
string result = "";
if (count != 0)
{
int objId = (int)Mydb.ExecuteScalar("select [OBJECT_ID] from OBJECT where OBJECT_ADRESS = @adr and PROJECT_ID=@prj", new SqlParameter[] { new SqlParameter("@adr", adr), new SqlParameter("@prj", prjId) }, CommandType.Text);
result = "{\"result\" : \"1\",\"objId\":\"" + objId.ToString() + "\"}";
}
else
{
result = "{\"result\" : \"0\"}";
}
return(result);
}
public string GetStreetsBytext(string txt, string loc)
{
int prjId = 0;
if (loc.Contains("/Fili/LoginF.aspx"))
{
prjId = 3;
}
if (loc.Contains("/Symbol/LoginS.aspx"))
{
prjId = 2;
}
DataTable dt = Mydb.ExecuteReadertoDataTable("select OBJECT_ID,OBJECT_ADRESS from OBJECT where OBJECT_ADRESS like '%'+@txt+'%' and PROJECT_ID=@prj", new SqlParameter[] { new SqlParameter("@txt", txt), new SqlParameter("prj", prjId) }, CommandType.Text);
List <ObjectS> objs = new List <ObjectS>();
foreach (DataRow item in dt.Rows)
{
ObjectS obj = new ObjectS();
obj.ObjectAdress = item["OBJECT_ADRESS"].ToString();
obj.Object_Id = Convert.ToInt32(item["OBJECT_ID"]);
objs.Add(obj);
}
return(JsonConvert.SerializeObject(objs));
}
public static string GetMeterDetail(int mid)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("GetMeterDetail ", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.StoredProcedure);
List <METERS> ms = new List <METERS>();
foreach (DataRow item in dt.Rows)
{
METERS m = new METERS();
m.AMUNT_TARIF = item["AMUNT_TARIF"].ToString();
m.LOG_IN_ID = item["ARXIV"].ToString() + "|" + item["SUSBEND"].ToString();
m.METERS_ID = item["METERS_ID"].ToString();
m.METERS_NUMBER = item["METERS_NUMBER"].ToString();
m.NEXT_DATE = item["NEXT_DATE"].ToString();
m.OBJECT_ID = item["OBJECT_ID"].ToString();
m.PREVIOUS_DATE = item["PREVIOUS_DATE"].ToString();
m.ROOM_NUMBER = item["ROOM_NUMBER2"].ToString();
m.ROOM_TYPE = item["ROOM_TYPE"].ToString();
m.ROOM_TYPE_ID = item["ROOM_TYPE_ID2"].ToString();
m.SCORE_ID = item["SCORE_ID"].ToString();
m.TYPE = item["TYPE"].ToString();
m.TYPE_ID = item["TYPE_ID"].ToString();
m.IS_AUTO = item["IS_AUTO"].ToString();
ms.Add(m);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(ms));
}
public static string UpdatingService(string sname, string quantity, int unit, int servId, int prj, string cost)
{
Mydb.ExecuteNoNQuery("update PRODUCT_SERVICE set SERVICE_NAME=@sname ,QUANTITY_IS=@quantity ,UNIT_OF_MEASURE_ID=@unit where SERVICE_ID=@servId", new SqlParameter[] { new SqlParameter("@sname", sname), new SqlParameter("@quantity", quantity), new SqlParameter("@unit", unit), new SqlParameter("@servId", servId) }, CommandType.Text);
Mydb.ExecuteNoNQuery("insert into PROJECT_PRODUCT_SERVICE (PRODUCT_SERVICE_ID,PROJECT_ID,COST) values(@servId,@prj,@cost)", new SqlParameter[] { new SqlParameter("@servId", servId), new SqlParameter("@prj", prj), new SqlParameter("@cost", cost) }, CommandType.Text);
return("");
}
public static string GetCheckedObjects(int DD, string Cl_Id)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("select * from OBJECT where ISNULL(IS_DELETED,0)<>1 and CLIENT_ID=@C", new SqlParameter[] { new SqlParameter("@C", Cl_Id) }, CommandType.Text);
List <ObjectS> os = new List <ObjectS>();
foreach (DataRow item in dt.Rows)
{
ObjectS o = new ObjectS();
int COuntCHecked = (int)Mydb.ExecuteScalar("select COUNT(*) from DISP_OBJECT where DISP_ID=@d and OBJECT_ID=@o", new SqlParameter[] { new SqlParameter("@d", DD), new SqlParameter("@o", Convert.ToInt32(item["OBJECT_ID"])) }, CommandType.Text);
if (COuntCHecked == 1)
{
o.Object_Id = Convert.ToInt32(item["Object_Id"]);
o.ObjectAdress = item["OBJECT_ADRESS"].ToString();
o.ObjectPhoto = "1";
}
if (COuntCHecked == 0)
{
int IsOtherDispObj = (int)Mydb.ExecuteScalar("select COUNT(*) from DISP_OBJECT where OBJECT_ID=@o", new SqlParameter[] { new SqlParameter("@o", Convert.ToInt32(item["Object_Id"])) }, CommandType.Text);
if (IsOtherDispObj == 0)
{
o.Object_Id = Convert.ToInt32(item["Object_Id"]);
o.ObjectAdress = item["OBJECT_ADRESS"].ToString();
o.ObjectPhoto = "0";
}
}
os.Add(o);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(os));
}
public static string GetExistServices(int prj, int dId)
{/*select ps.SERVICE_ID,ps.SERVICE_NAME,ps.QUANTITY_IS,ps.UNIT_OF_MEASURE_ID from PRODUCT_SERVICE ps inner join PROJECT_PRODUCT_SERVICE pps on pps.PRODUCT_SERVICE_ID=ps.SERVICE_ID and pps.PROJECT_ID=@prj and ps.DIRECTION_ID=@d*/
return(Mydb.ExecuteReadertoDataTableAsJson(@"select
ps.SERVICE_ID,
ps.SERVICE_NAME,
ps.QUANTITY_IS,
ps.UNIT_OF_MEASURE_ID,
pps.COST,
pps.DATE_START
from PRODUCT_SERVICE ps
inner join
(
SELECT *
FROM
PROJECT_PRODUCT_SERVICE AS [data]
WHERE
DATE_START = (SELECT max(DATE_START)
FROM
PROJECT_PRODUCT_SERVICE
WHERE
PRODUCT_SERVICE_ID = [data].PRODUCT_SERVICE_ID)
OR DATE_START is NULL
)
pps on
pps.PRODUCT_SERVICE_ID=ps.SERVICE_ID and pps.PROJECT_ID=@prj and ps.DIRECTION_ID=@d", new SqlParameter[] { new SqlParameter("@prj", prj), new SqlParameter("@d", dId) }, CommandType.Text));
}
public static string getDispsENgsTexs(int DD, int R)
{
//DataTable dt = Mydb.ExecuteReadertoDataTable("GetDispEngTex", new SqlParameter[] { new SqlParameter("@d",DD),new SqlParameter("@R",R) }, CommandType.StoredProcedure);
//
//foreach (DataRow item in dt.Rows)
//{
// Account_ ac = new Account_();
// ac.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
// ac.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
// ass.Add(ac);
//}
//JavaScriptSerializer js = new JavaScriptSerializer();
//return js.Serialize(ass);
DataTable dt = Mydb.ExecuteReadertoDataTable("select LOG_IN_ID from DISP_ACC where DISP_ID=@d and ROLE_ID=@r", new SqlParameter[] { new SqlParameter("@d", DD), new SqlParameter("@r", R) }, CommandType.Text);
List <Account_> ass = new List <Account_>();
foreach (DataRow item in dt.Rows)
{
Account_ a = new Account_();
a.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
a.ACCOUNT_NAME = Mydb.ExecuteScalar("select ACCOUNT_NAME from ACCOUNT where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", Convert.ToInt32(item["LOG_IN_ID"])) }, CommandType.Text).ToString();
ass.Add(a);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(ass));
}
// GET: Meters_Fili
public string GetMeters(string s)
{
/*
* toke id 5501800 (0367076C-AE6D-E0F7-4325-818E00396984)
*/
//int o = (int)Mydb.ExecuteScalar("select top 1 OBJECT_ID from VW_ROOMS where NUMBER=@s", new SqlParameter[] { new SqlParameter("@s", s) }, CommandType.Text);
//DataTable dt = Mydb.ExecuteReadertoDataTable("select * from VW_METERS where SUSBEND=0 and ARXIV=0 and OBJECT_ID=@o and ROOM_NUMBER=(select ROOM_NUMBER from ROOM where ROOM_ID=(select ROOM_ID from PER_SCORE where SCORE_ID=@s2)) and SCORE_ID=@s1", new SqlParameter[] { new SqlParameter("@o", o), new SqlParameter("@s1",s), new SqlParameter("@s2", s) }, CommandType.Text);
// DataTable dt = Mydb.ExecuteReadertoDataTable("GetMeters", new SqlParameter[] { new SqlParameter("@sc",s) }, CommandType.StoredProcedure);
//List<METERS> ms = new List<METERS>();
//foreach (DataRow item in dt.Rows)
//{
// METERS m = new METERS();
// m.AMUNT_TARIF = item["AMUNT_TARIF"].ToString();
// m.LOG_IN_ID = item["LOG_IN_ID"].ToString();
// m.METERS_ID = item["METERS_ID"].ToString();
// m.METERS_NUMBER = item["METERS_NUMBER"].ToString();
// m.NEXT_DATE = item["NEXT_DATE"].ToString();
// m.OBJECT_ID = item["OBJECT_ID"].ToString();
// m.PREVIOUS_DATE = item["PREVIOUS_DATE"].ToString();
// m.ROOM_NUMBER = item["ROOM_NUMBER"].ToString();
// m.ROOM_TYPE = item["ROOM_TYPE"].ToString();
// m.ROOM_TYPE_ID = item["ROOM_TYPE_ID"].ToString();
// m.SCORE_ID = item["SCORE_ID"].ToString();
// m.TYPE = item["TYPE"].ToString();
// m.TYPE_ID = item["TYPE"].ToString();
// m.IS_AUTO = item["IS_AUTO"].ToString();
// ms.Add(m);
//}
// string result = Android_sendPush(s); JsonConvert.SerializeObject(ms);
return(Mydb.ExecuteAsJson("GetMeters", new SqlParameter[] { new SqlParameter("@sc", s) }, CommandType.StoredProcedure));
}
public static string AllSearch1(int dd, string txt, int lg)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("uspo_AllSearchRequest", new SqlParameter[] { new SqlParameter("@dd", dd), new SqlParameter("@Stext", txt) }, CommandType.StoredProcedure);
List <Request> rs = new List <Utilities.Request>();
foreach (DataRow item in dt.Rows)
{
Request r = new Utilities.Request();
r.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
r.ROOM_TYPE = item["ROOM_TYPE"].ToString();
r.ROOM_NUMBER = item["ROOM_NUMBER"].ToString();
r.CR_DATE = item["CR_DATE"].ToString();
r.REQUEST_ID = Convert.ToInt32(item["REQUEST_ID"]);
r.REQUEST_TEXT = item["REQUEST_TEXT"].ToString();
// r.SERVICE_NAME = item["SERVICE_NAME"].ToString();
r.STATUS = item["STATUS"].ToString();
r.PLAN_END_DATE = item["PLAN_END_DATE"].ToString();
r.INDIVIDUAL_ID = Convert.ToInt32(item["INDIVIDUAL_ID"]);
r.FIRST_NAME = item["FIRST_NAME"].ToString();
r.STATUS_ID = item["STATUS_ID"].ToString();
r.ATRIBUTE = (item["LOG_IN_ID"] != lg.ToString() || item["LOG_IN_ID"] == null) ? "NotC" : "Curr";
//r.DELIVERY_TYPE_ID = 1;
r.ADRESS = item["OBJECT_ADRESS"].ToString();
r.EMERGENCY_TREATMENT = (bool)item["EMERGENCY_TREATMENT"];
r.COMMENT_FILE = item["PAYMENT"].ToString();
rs.Add(r);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(rs));
}
public static string MakeZakrit(int Rid, string comment, string login_id)
{
if (comment.Length == 0)
{
Mydb.ExecuteNoNQuery("Update REQUEST_SUPPLIERS set STATUS_ID=5 where REQUEST_ID=@rid", new SqlParameter[] { new SqlParameter("@rid", Rid) }, CommandType.Text);
//foreach (ProductService_ item in prs)
//{
// Mydb.ExecuteNoNQuery("update REQUEST_SERVICE set P_SERVICE_ID=@P_SERVICE_ID, QUANTITY=@QUANTITY, COST=@COST where REQUEST_ID=@REQUEST_ID", new SqlParameter[] { new SqlParameter("@P_SERVICE_ID", item.SERVICE_ID), new SqlParameter("@QUANTITY", item.QUANTITY), new SqlParameter("@COST", item.COST), new SqlParameter("@REQUEST_ID", Rid) }, CommandType.Text);
//}
// Mydb.ExecuteNoNQuery("Update REQUEST set PAYMENT=@PAYMENT where REQUEST_ID=@REQUEST_ID", new SqlParameter[] { new SqlParameter("@PAYMENT", opl), new SqlParameter("@REQUEST_ID",Rid) }, CommandType.Text);
// object MobileNumber1 = Mydb.ExecuteScalar("select MOBILE_NUMBER from REQUEST WHERE REQUEST_ID=@rid", new SqlParameter[] { new SqlParameter("@rid", Rid) }, CommandType.Text);
// Mydb.ExecuteNoNQuery("[TestDB].[dbo].[sp_QUICK_API_request_change_status_autopilot]", new SqlParameter[] { new SqlParameter("@MOBILE_NUMBER", Convert.ToInt64(MobileNumber1)), new SqlParameter("@NEW_STATUS", 5), new SqlParameter("@COMMENT", ""), new SqlParameter("@WHO", login_id) }, CommandType.StoredProcedure);
return("");
}
else
{
Mydb.ExecuteNoNQuery("Update REQUEST_SUPPLIERS set STATUS_ID=5 where REQUEST_ID=@rid", new SqlParameter[] { new SqlParameter("@rid", Rid) }, CommandType.Text);
Mydb.ExecuteNoNQuery("insert into REQUEST_COMMENT_SUPPLIERS (REQUEST_COMMENT, REQUEST_ID) values(@rc,@rid)", new SqlParameter[] { new SqlParameter("@rc", comment), new SqlParameter("@rid", Rid) }, CommandType.Text);
//foreach (ProductService_ item in prs)
//{
// Mydb.ExecuteNoNQuery("update REQUEST_SERVICE set P_SERVICE_ID=@P_SERVICE_ID, QUANTITY=@QUANTITY, COST=@COST where REQUEST_ID=@REQUEST_ID", new SqlParameter[] { new SqlParameter("@P_SERVICE_ID", item.SERVICE_ID), new SqlParameter("@QUANTITY", item.QUANTITY), new SqlParameter("@COST", item.COST), new SqlParameter("@REQUEST_ID", Rid) }, CommandType.Text);
//}
// Mydb.ExecuteNoNQuery("Update REQUEST set PAYMENT=@PAYMENT where REQUEST_ID=@REQUEST_ID", new SqlParameter[] { new SqlParameter("@PAYMENT", opl), new SqlParameter("@REQUEST_ID", Rid) }, CommandType.Text);
}
// object MobileNumber = Mydb.ExecuteScalar("select MOBILE_NUMBER from REQUEST WHERE REQUEST_ID=@rid", new SqlParameter[] { new SqlParameter("@rid", Rid) }, CommandType.Text);
//Mydb.ExecuteNoNQuery("[TestDB].[dbo].[sp_QUICK_API_request_change_status_autopilot]", new SqlParameter[] { new SqlParameter("@MOBILE_NUMBER", Convert.ToInt64(MobileNumber)), new SqlParameter("@NEW_STATUS", 5), new SqlParameter("@COMMENT", ""), new SqlParameter("@WHO", login_id) }, CommandType.StoredProcedure);
return("");
}
public static string AllSearch2(int dd, string txt, int lg)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("uspo_AllSearchRequest2", new SqlParameter[] { new SqlParameter("@dd", dd), new SqlParameter("@Stext", txt) }, CommandType.StoredProcedure);
List <Request> rs = new List <Utilities.Request>();
foreach (DataRow item in dt.Rows)
{
Request r = new Utilities.Request();
r.ROOM_TYPE = item["ROOM_TYPE"].ToString();
r.CR_DATE = item["CR_DATE"].ToString();
r.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
r.REQUEST_ID = Convert.ToInt32(item["REQUEST_ID"]);
r.REQUEST_TEXT = item["REQUEST_TEXT"].ToString();
r.REQUEST_COMMENT = item["REQUEST_COMMENT"].ToString();
r.STATUS = item["STATUS"].ToString();
r.PLAN_END_DATE = item["PLAN_END_DATE"].ToString();
r.STATUS_ID = item["STATUS_ID"].ToString();
r.ATRIBUTE = (Convert.ToInt32(item["LOG_IN_ID"]) == lg) ? "Curr" : "NotC";
r.EMERGENCY_TREATMENT = (bool)item["EMERGENCY_TREATMENT"];
r.COMMENT_FILE = item["PAYMENT"].ToString();
rs.Add(r);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(rs));
}
public static string getExistIndividualsAndScores(int obj, string rmNum)
{
string j1 = Mydb.ExecuteReadertoDataTableAsJson(@"select NUMBER from PER_SCORE where IS_DELETED=0 and ROOM_ID in
( select ROOM_ID from ROOM where OBJECT_ID =@obj and ROOM_NUMBER=@rmNum and IS_DELETED=0)", new SqlParameter[] { new SqlParameter("@obj", obj), new SqlParameter("@rmNum", rmNum) }, CommandType.Text);
// j1.Length
dynamic j1_ = JsonConvert.DeserializeObject(j1);
List <Dictionary <string, object> > rows = new List <Dictionary <string, object> >();
// rows.Count
if (j1_.Count != 0)
{
j1_ = j1_[0].NUMBER;
string j2 = Mydb.ExecuteReadertoDataTableAsJson("select * from IND_NAME where IS_DELETED=0 and INDIVIDUAL_ID in (select INDIVIDUAL_ID from INDIVIDUAL_PERSCORE where SCORE_ID=@Score and IS_DELETED=0)", new SqlParameter[] { new SqlParameter("@Score", Convert.ToString(j1_)) }, CommandType.Text);
var row = new Dictionary <string, object>();
row.Add("NummberJson", j1);
row.Add("IndividualJson", j2);
rows.Add(row);
}
//JsonConvert.SerializeObject(j1 + j2);//j1 +","+ j2;
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(rows));
}
public static string getAllCounts(int dd)
{
int CVrabot = (int)Mydb.ExecuteScalar("select COUNT(*) from VW_ALL_REQUESTS_1_2 where DISP_ID=@dd and STATUS_ID=1", new SqlParameter[] { new SqlParameter("@dd", dd) }, CommandType.Text);
//CVrabot= CVrabot+ (int)Mydb.ExecuteScalar("select COUNT(*) from VW_ALL_REQUESTS_2 where DISP_ID=@dd and STATUS_ID=1", new SqlParameter[] { new SqlParameter("@dd", dd) }, CommandType.Text);
int CVipol = (int)Mydb.ExecuteScalar("select COUNT(*) from VW_ALL_REQUESTS_1_2 where DISP_ID=@dd and STATUS_ID=3", new SqlParameter[] { new SqlParameter("@dd", dd) }, CommandType.Text);
//CVipol= CVipol+ (int)Mydb.ExecuteScalar("select COUNT(*) from VW_ALL_REQUESTS_2 where DISP_ID=@dd and STATUS_ID=3", new SqlParameter[] { new SqlParameter("@dd", dd) }, CommandType.Text);
int COtmen = (int)Mydb.ExecuteScalar("select COUNT(*) from VW_ALL_REQUESTS_1_2 where DISP_ID=@dd and STATUS_ID=4", new SqlParameter[] { new SqlParameter("@dd", dd) }, CommandType.Text);
//COtmen= COtmen+ (int)Mydb.ExecuteScalar("select COUNT(*) from VW_ALL_REQUESTS_2 where DISP_ID=@dd and STATUS_ID=4", new SqlParameter[] { new SqlParameter("@dd", dd) }, CommandType.Text);
int CZakrit = (int)Mydb.ExecuteScalar("select COUNT(*) from VW_ALL_REQUESTS_1_2 where DISP_ID=@dd and STATUS_ID=5", new SqlParameter[] { new SqlParameter("@dd", dd) }, CommandType.Text);
int COtprav = (int)Mydb.ExecuteScalar("select COUNT(*) from VW_ALL_REQUESTS_1_2 where DISP_ID2=@dd and STATUS_ID=2", new SqlParameter[] { new SqlParameter("@dd", dd) }, CommandType.Text);
//CZakrit= CZakrit+ (int)Mydb.ExecuteScalar("select COUNT(*) from VW_ALL_REQUESTS_2 where DISP_ID=@dd and STATUS_ID=5", new SqlParameter[] { new SqlParameter("@dd", dd) }, CommandType.Text);
int Count = (int)Mydb.ExecuteScalar("select COUNT(*) from VW_ALL_REQUESTS_1_2 where DISP_ID=@dd", new SqlParameter[] { new SqlParameter("@dd", dd) }, CommandType.Text);
//Count= Count+ (int)Mydb.ExecuteScalar("select COUNT(*) from VW_ALL_REQUESTS_2 where DISP_ID=@dd", new SqlParameter[] { new SqlParameter("@dd", dd) }, CommandType.Text);
return("{\"CVrabot\" : \"" + CVrabot.ToString() + "\",\"CVipol\" :\"" + CVipol.ToString() + "\",\"COtmen\" :\"" + COtmen.ToString() + "\",\"CZakrit\" :\"" + CZakrit.ToString() + "\",\"Alloff\" :\"" + Count.ToString() + "\",\"Otpravv\" :\"" + COtprav.ToString() + "\"}");
}
public static string getAccForSelRole(int C, List <Roles> rls)
{
DataTable dt = null;
List <Account_> accs = new List <Account_>();
foreach (Roles ite_m in rls)
{
dt = Mydb.ExecuteReadertoDataTable("select * from ACCOUNT where CLIENT_ID =@C and LOG_IN_ID in (select LOG_IN_ID from ACCOUNT_ROLE where MR_ID in (select MR_ID from MODUL_ROLE where ROLE_ID=@R))", new SqlParameter[] { new SqlParameter("@C", C), new SqlParameter("@R", ite_m.ROLE_ID) }, CommandType.Text);
foreach (DataRow item in dt.Rows)
{
Account_ acc = new Account_();
acc.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
acc.E_MAIL = item["E_MAIL"].ToString();
acc.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
// acc.MODULE_ROLES = item["MODULE_ROLES"].ToString();
acc.PASSWORD = item["PASSWORD"].ToString();
acc.PHONE_NUMBER = item["PHONE_NUMBER"].ToString();
accs.Add(acc);
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(accs));
}
public static string GetDetailUO(int CLId_, int UoId_)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("select * from MAN_COMPANY where MAN_COMPANY_ID=@id and CLIENT_ID=@ClId", new SqlParameter[] { new SqlParameter("@id", UoId_), new SqlParameter("@ClId", CLId_) }, CommandType.Text);
DataRow item = dt.Rows[0];
Kvorum_App.Client_Admin.Utilities.ManCompany ms = new Kvorum_App.Client_Admin.Utilities.ManCompany();
ms.ADRESS = item["ADRESS"].ToString();
ms.ADRESS_ID = item["ADRESS_ID"].ToString();
ms.CLIENT_ID = Convert.ToInt32(item["CLIENT_ID"]);
ms.EMAIL = item["EMAIL"].ToString();
ms.FB = item["FB"].ToString();
ms.INN = item["INN"].ToString();
ms.KPP = item["KPP"].ToString();
ms.LICENCE = item["LICENCE"].ToString();
ms.MAN_COMPANY_ID = Convert.ToInt32(item["MAN_COMPANY_ID"]);
ms.NAME = item["NAME"].ToString();
ms.OGRN = item["OGRN_OGRNIP"].ToString();
ms.OK = item["OK"].ToString();
ms.OKPO = item["OKPO"].ToString();
ms.PHONE = item["PHONE"].ToString();
ms.TW = item["TW"].ToString();
ms.VK = item["VK"].ToString();
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(ms));
}
public string GetRFP(string sc)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("select * from RECIEPT_FOR_PAYMENT where SCORE_ID=@sc order by RECIEPT_FOR_PAYMENT_ID desc", new SqlParameter[] { new SqlParameter("@sc", sc) }, CommandType.Text);
List <RFP> rfps = new List <RFP>();
int objId = (int)Mydb.ExecuteScalar("select OBJECT_ID from PER_SCORE where SCORE_ID=@sc", new SqlParameter[] { new SqlParameter("@sc", sc) }, CommandType.Text);
foreach (DataRow item in dt.Rows)
{
RFP rfp = new RFP();
rfp.ACCURED_SUMM = item["ACCURED_SUMM"].ToString();
rfp.BACKLOG_START = item["BACKLOG_START"].ToString();
rfp.DATA_MOUNTH_YEAR = item["DATA_MOUNTH_YEAR"].ToString();
rfp.PAYMENT_SUM = item["PAYMENT_SUMM"].ToString();
rfp.RECIEPT_FOR_PAYMENT_ID = (int)item["RECIEPT_FOR_PAYMENT_ID"];
rfp.PAY_DATE = item["PAY_DATE"].ToString();
rfp.MASTER_GUID = item["MASTER_GUID"].ToString();
rfp.PAYED = item["PAYED"].ToString();
rfp.GENERAL_SUM = item["GENERAL_SUM"].ToString();
rfp.RECEIVED = item["RECEIVED"].ToString();
rfp.PAYMENT_SUM = Mydb.ExecuteScalar("TestDB.dbo.sp_QUICK_API_get_shopId", new SqlParameter[] { new SqlParameter("@tokenid", ""), new SqlParameter("@login", ""), new SqlParameter("@obj", objId) }, CommandType.StoredProcedure).ToString();
rfps.Add(rfp);
}
return(JsonConvert.SerializeObject(rfps));
}
public static string SaveDirectsGrup(string GRUP_NAME, string SERVICE_PROJECT, string GRUP_ICON, string direction_guid, string SERVICE_NAME, string SERVICE_UNIT, string SERVICE_COST)
{
//int dId = (int)Mydb.ExecuteScalar("insert into SERVICE_DIRECT (DIRECTION_NAME,SS_ID) output inserted.DIRECTION_ID values(@dname,@sid)", new SqlParameter[] { new SqlParameter("@dname", dname), new SqlParameter("@sid", setId) }, CommandType.Text);
//Mydb.ExecuteNoNQuery("insert into SDIRECT_SICON (S_DIRECT_ID,PROJECT_ID,ICON_ID) values (@dId,@prj,@dIconId)", new SqlParameter[] { new SqlParameter("@dId", dId), new SqlParameter("@prj", prj), new SqlParameter("@dIconId", dIconId) }, CommandType.Text);
//int ProductId = (int)Mydb.ExecuteScalar("insert into PRODUCT_SERVICE (SERVICE_NAME,QUANTITY_IS,UNIT_OF_MEASURE_ID,DIRECTION_ID) output inserted.SERVICE_ID values(@sname, @quantity, @unit, @dId)", new SqlParameter[] { new SqlParameter("@sname", sname), new SqlParameter("@quantity", quantity), new SqlParameter("@unit", unit), new SqlParameter("@dId", dId) }, CommandType.Text);
//Mydb.ExecuteNoNQuery("insert into PROJECT_PRODUCT_SERVICE (PRODUCT_SERVICE_ID,PROJECT_ID,COST,ACTIVE) values(@productId,@prj,@cost,'0')", new SqlParameter[] { new SqlParameter("@productId", ProductId), new SqlParameter("@prj", prj), new SqlParameter("@cost", cost) }, CommandType.Text);
int parentId = Convert.ToInt32(Mydb.ExecuteScalar("INSERT_GRUP_AND_SERVICES", new SqlParameter[] {
new SqlParameter("@SERVICE_NAME", GRUP_NAME),
new SqlParameter("@SERVICE_PROJECT", SERVICE_PROJECT),
new SqlParameter("@SERVICE_ICON", GRUP_ICON),
new SqlParameter("@DIRECTION_GUID", direction_guid),
//new SqlParameter("@SERVICE_SUPPLIER",SERVICE_SUPPLIER),,string SERVICE_SUPPLIER,string SUPPLIER_GUID
//new SqlParameter("SUPPLIER_GUID",SUPPLIER_GUID)
}, CommandType.StoredProcedure));
// insert Service
Mydb.ExecuteScalar("INSERT_GRUP_AND_SERVICES", new SqlParameter[] {
new SqlParameter("@PARENT_ID", parentId),
new SqlParameter("@SERVICE_NAME", SERVICE_NAME),
new SqlParameter("@SERVICE_UNIT", SERVICE_UNIT),
new SqlParameter("@SERVICE_COST", SERVICE_COST),
new SqlParameter("@SERVICE_ICON", DBNull.Value),
new SqlParameter("@SERVICE_PROJECT", SERVICE_PROJECT),
// new SqlParameter("@SERVICE_SUPPLIER",SERVICE_SUPPLIER),
// new SqlParameter("SUPPLIER_GUID",SUPPLIER_GUID)
}, CommandType.StoredProcedure);
return("");
}
public static string GetRequestTableForResponsibles(int LogId)
{
System.Data.DataTable dt = Mydb.ExecuteReadertoDataTable("GetRequestTableForResponsibles", new SqlParameter[] { new SqlParameter("@L", LogId) }, CommandType.StoredProcedure);
List <Resp_Request> rs = new List <Resp_Request>();
foreach (DataRow item in dt.Rows)
{
Resp_Request r = new Resp_Request();
r.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
r.ROOM_TYPE = item["ROOM_TYPE"].ToString();
r.CR_DATE = item["CR_DATE"].ToString();
r.REQUEST_ID = Convert.ToInt32(item["REQUEST_ID"]);
r.REQUEST_TEXT = item["REQUEST_TEXT"].ToString();
// r.SERVICE_NAME = item["SERVICE_NAME"].ToString();
r.STATUS = item["STATUS"].ToString();
r.PLAN_END_DATE = item["PLAN_END_DATE"].ToString();
r.INDIVIDUAL_ID = (item["INDIVIDUAL_ID"] == DBNull.Value) ? -1 : Convert.ToInt32(item["INDIVIDUAL_ID"]);
r.FIRST_NAME = item["FIRST_NAME"].ToString();
r.STATUS_ID = item["STATUS_ID"].ToString();
r.REQUEST_COMMENT = item["PAYMENT"].ToString();
r.EMERGENCY_TREATMENT = (item["ORDER"].ToString() == "1") ? true : false; //(bool)item["EMERGENCY_TREATMENT"];
r.ADRESS = item["OBJECT_ADRESS"].ToString();
r.MOBILE_NUMBER = item["MOBILE_NUMBER"].ToString();
rs.Add(r);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(rs));
}
public static string GetServicesForSupplierSelected(int obj, string supp_guid, string service_guid)
{
string project_guid = Mydb.ExecuteScalar("[GetProjectGuidBySuppGud_LK]", new SqlParameter[] { new SqlParameter("@guid", supp_guid) }, CommandType.StoredProcedure).ToString();
return(Mydb.ExecuteReadertoDataTableAsJson("TestDB.[dbo].[sp_QUICK_API_get_mp_services_web]", new SqlParameter[] { new SqlParameter("@project", project_guid), new SqlParameter("@supplier", supp_guid), new SqlParameter("@service_guid", service_guid) }, CommandType.StoredProcedure));
}
