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;// }
// 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 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 GetExistDirections(string project_Guid) { // return Mydb.ExecuteReadertoDataTableAsJson(@"select ss.SERVICE_SET_ID,ss.SERVICE_SET_NAME,ssc.S_ICON_ADRESS,ssc.S_ICON_ID,isnull(ssi.RESPONSIBLE_ID,0) as RESPONSIBLE_ID from SELECTED_SERVICE_SET_ICON ssi //inner join SERVICE_SET ss on ss.SERVICE_SET_ID=ssi.SSS_ID inner join SERVICE_SET_ICONS ssc on ssc.S_ICON_ID=ssi.SSS_ICON where ssi.PROJECT_ID=@projectId", new SqlParameter[] { new SqlParameter("@projectId", projectId) }, CommandType.Text); // var a = 0; //return Mydb.ExecuteAsJson("TestDB.[dbo].[sp_QUICK_API_get_ub_directions]", new SqlParameter[] { new SqlParameter("@PROJECT_GUID", project_Guid), new SqlParameter("@respid", 0) }, CommandType.StoredProcedure); return(Mydb.ExecuteAsJson("TestDB.[dbo].[sp_QUICK_API_get_ub_directions]", new SqlParameter[] { new SqlParameter("@PROJECT_GUID", project_Guid), new SqlParameter("@respid", Convert.ToInt32(0)) }, CommandType.StoredProcedure)); }
public ContentResult LoginSecond(string sc, string pass) { #region badCode //string result = ""; //int ObjCount = (int)Mydb.ExecuteScalar("select COUNT(OBJECT_ID) from PER_SCORE where SCORE_ID=@sc", new SqlParameter[] { new SqlParameter("@sc",sc) }, CommandType.Text); //if (ObjCount==1) //{ // int objId= (int)Mydb.ExecuteScalar("select OBJECT_ID from PER_SCORE where SCORE_ID=@sc", new SqlParameter[] { new SqlParameter("@sc", sc) }, CommandType.Text); // int ExistOrNot = (int)Mydb.ExecuteScalar("select COUNT(*) from PER_SCORE where SCORE_ID=@sc and PASS=@pass and OBJECT_ID=@objId", new SqlParameter[] { new SqlParameter("@sc",sc),new SqlParameter("@pass",pass),new SqlParameter("@objId",objId) }, CommandType.Text); // if (ExistOrNot==1) // { // int ProjectId = (int)Mydb.ExecuteScalar("select PROJECT_ID from OBJECT where OBJECT_ID=@ObjId", new SqlParameter[] { new SqlParameter("@ObjId", objId) }, CommandType.Text); // result = "{\"result\" : \"1\",\"objId\":\"" + objId + "\",\"C_Score\":\"" + sc + "\",\"ProjectId\":\"" + ProjectId + "\"}"; // } // else // { // int ProjectId = (int)Mydb.ExecuteScalar("select PROJECT_ID from OBJECT where OBJECT_ID=@ObjId", new SqlParameter[] { new SqlParameter("@ObjId", objId) }, CommandType.Text); // string LoginBitrix = Mydb.ExecuteReadertoDataTableAsJson("usp_CHECK_BITRIX_USER", new SqlParameter[] { new SqlParameter("@login", sc), new SqlParameter("@pwd", pass) }, CommandType.StoredProcedure); // dynamic jsonLoginBitrix = JsonConvert.DeserializeObject(LoginBitrix); // if (jsonLoginBitrix[0].LOTUS_GUID != "Login failed") // { // result = "{\"result\" : \"1\",\"objId\":\"" + objId + "\",\"C_Score\":\"" + sc + "\",\"ProjectId\":\"" + ProjectId + "\"}"; // } // else // { // result = "{\"result\" : \"0\"}"; // } // } //} //if (ObjCount>1) //{ // int objId = (int)Mydb.ExecuteScalar("select OBJECT_ID from PER_SCORE where SCORE_ID=@sc", new SqlParameter[] { new SqlParameter("@sc", sc) }, CommandType.Text); // int ProjectId = (int)Mydb.ExecuteScalar("select PROJECT_ID from OBJECT where OBJECT_ID=@ObjId", new SqlParameter[] { new SqlParameter("@ObjId", objId) }, CommandType.Text); // string LoginBitrix = Mydb.ExecuteReadertoDataTableAsJson("usp_CHECK_BITRIX_USER", new SqlParameter[] { new SqlParameter("@login", sc), new SqlParameter("@pwd", pass) }, CommandType.StoredProcedure); // dynamic jsonLoginBitrix = JsonConvert.DeserializeObject(LoginBitrix); // if (jsonLoginBitrix[0].LOTUS_GUID != "Login failed") // { // result = "{\"result\" : \"1\",\"objId\":\"" + objId + "\",\"C_Score\":\"" + sc + "\",\"ProjectId\":\"" + ProjectId + "\"}"; // } // else // { // result = "{\"result\" : \"0\"}"; // } //} //if (ObjCount==0) //{ // result = "{\"result\" : \"0\"}"; //} #endregion //res.Content = new StringContent(result.ToString(), Encoding.UTF8, "text/csv"); return(Content(Mydb.ExecuteAsJson("LoginSecond", new SqlParameter[] { new SqlParameter("@sc", sc), new SqlParameter("@pass", pass) }, CommandType.StoredProcedure), "application/json"));//result }
public string AddCounterValueT(int mid, string values_T, int tarif) { // values_T = "{T1: \"1\",T2:\"2\", T3:\"3\"}"; dynamic T_Values = JsonConvert.DeserializeObject(values_T); var ValueT1 = T_Values.T1.Value; var ValueT2 = (tarif >= 2)?T_Values.T2.Value:null; var ValueT3 = (tarif == 3) ?T_Values.T3.Value:null; Mydb.ExecuteReadertoDataTable("InsertOrUpdateELectricMeter", new SqlParameter[] { new SqlParameter("@VALUE_", ValueT1), new SqlParameter("@VALUE_2", ((ValueT2 == null) ? DBNull.Value : ValueT2)), new SqlParameter("@VALUE_3", (string.IsNullOrEmpty(ValueT3)?DBNull.Value: ValueT3)), new SqlParameter("@METERS_ID", mid) }, CommandType.StoredProcedure); return(Mydb.ExecuteAsJson("GetLastValueAndAVG_of_Meters", new SqlParameter[] { new SqlParameter("@id", mid) }, CommandType.StoredProcedure));; }
public static string GetDirections_Grups_and_Services(string PROJECT_GUID, string DIRECTION_GUID, string SERVICE_GUID) { dynamic servc; if (SERVICE_GUID.Length == 0) { servc = DBNull.Value; } else { servc = SERVICE_GUID; } return(Mydb.ExecuteAsJson("TestDB.dbo.sp_QUICK_API_get_ub_services", new SqlParameter[] { new SqlParameter("@PROJECT_GUID", PROJECT_GUID), new SqlParameter("@DIRECTION_GUID", DIRECTION_GUID), new SqlParameter("@SERVICE_GUID", servc) }, CommandType.StoredProcedure)); }
public static string Filtering(List <Kvorum_App.Disp_Admin.Utilities.Filter> flt, int Log, int role, int all) { string returnval = ""; /*string r ="REQUEST_ID=5"; * Console.WriteLine(r); * int index = r.IndexOf('.'); * r=r.Substring(r.LastIndexOf('=')+1); * Console.WriteLine(r);*/ object MOBILE_NUMBER = ""; object ROOM_NUMBER = ""; object OBJECT_ID = ""; object ROOM_TYPE_ID = ""; object FIRST_NAME = ""; object STATUS_ID = ""; object CR_DATE_from = ""; object CR_DATEE_TO = ""; foreach (Kvorum_App.Disp_Admin.Utilities.Filter item in flt) { MOBILE_NUMBER = (item.MOBILE_NUMBER.Length != 0) ? item.MOBILE_NUMBER.ToString() : (object)DBNull.Value; ROOM_NUMBER = (item.ROOM_NUMBER.Length != 0) ? item.ROOM_NUMBER.ToString() : (object)DBNull.Value; OBJECT_ID = (item.OBJECT_ID != 0) ? item.OBJECT_ID.ToString() : (object)DBNull.Value; ROOM_TYPE_ID = (item.ROOM_TYPE_ID != 0) ? item.ROOM_TYPE_ID.ToString() : (object)DBNull.Value; FIRST_NAME = (item.FIRST_NAME != "") ? item.FIRST_NAME : (object)DBNull.Value; // FIRST_NAME = (FIRST_NAME != "") ? FIRST_NAME.Replace("\"", "'"):""; STATUS_ID = (item.STATUSE != 0) ? item.STATUSE.ToString() : (object)DBNull.Value; CR_DATE_from = (item.CR_DATE_FROM != "") ? item.CR_DATE_FROM : (object)DBNull.Value; //CR_DATE_from = (CR_DATE_from != "") ? CR_DATE_from.Replace("\"", "'"):""; CR_DATEE_TO = (item.CR_DATE_TO != "") ? item.CR_DATE_TO : (object)DBNull.Value; //CR_DATEE_TO = (CR_DATEE_TO != "") ? CR_DATEE_TO.Replace("\"", "'"):""; } return(Mydb.ExecuteAsJson("uspo_Filtering", new SqlParameter[] { new SqlParameter("@rid", MOBILE_NUMBER), new SqlParameter("@room", ROOM_NUMBER), new SqlParameter("@objectId", OBJECT_ID), new SqlParameter("@roomtype", ROOM_TYPE_ID), new SqlParameter("@firstname", FIRST_NAME), new SqlParameter("@status", STATUS_ID), new SqlParameter("@cr_S", CR_DATE_from), new SqlParameter("@cr_E", CR_DATEE_TO), new SqlParameter("@lg", Log), new SqlParameter("@role", role), new SqlParameter("@all", all) }, CommandType.StoredProcedure)); }
public static string GetRolesLeftmenu(int clId) { //int log =(int) Mydb.ExecuteScalar("select LOG_IN_ID from ACCOUNT where CLIENT_ID=@C and LOGIN is null", new SqlParameter[] { new SqlParameter("@C", clId) }, CommandType.Text); //DataTable dt = Mydb.ExecuteReadertoDataTable("GetRoles_", new SqlParameter[] { new SqlParameter("@L", log) }, CommandType.StoredProcedure); //List<Roles> rs = new List<Roles>(); //foreach (DataRow item in dt.Rows) //{ // Roles r = new Roles(); // r.ROLE_NAME = item["ROLE_NAME"].ToString(); // r.ACCOUNT_QUANTITY = log.ToString(); // rs.Add(r); //} //JavaScriptSerializer js = new JavaScriptSerializer(); //return js.Serialize(rs); return(Mydb.ExecuteAsJson("AdminGetRolesLeftmenu", new SqlParameter[] { new SqlParameter("@C", clId) }, CommandType.StoredProcedure)); }
public static string OBJ_List(int client_id) { //DataTable dt = Mydb.ExecuteReadertoDataTable("sp_CounstructorAPI_GET_OBJ_by_CLIENT_ID", new SqlParameter[] { new SqlParameter("@CLIENT_ID", client_id) }, CommandType.StoredProcedure); //List<ObjectS> objs = new List<ObjectS>(); //foreach (DataRow item in dt.Rows) //{ // ObjectS obj = new ObjectS(); // obj.Object_Id = Convert.ToInt32(item["OBJECT_ID"]); // obj.ObjectAdress = item["OBJECT_ADRESS"].ToString(); // obj.ObjectPhoto = item["OBJECT_IMG"].ToString(); // obj.MAN_COMP_NAME = item["MAN_COMP_NAME"].ToString(); // objs.Add(obj); //} //JavaScriptSerializer js = new JavaScriptSerializer(); //return js.Serialize(objs); return(Mydb.ExecuteAsJson("sp_CounstructorAPI_GET_OBJ_by_CLIENT_ID", new SqlParameter[] { new SqlParameter("@CLIENT_ID", client_id) }, CommandType.StoredProcedure)); }
public static string GetUOList(int client_id) { return(Mydb.ExecuteAsJson("GetUOList", new SqlParameter[] { new SqlParameter("@C", client_id) }, CommandType.StoredProcedure)); }
public string AddCounterValue(string type, int meterId, string VALUE_, string cnum) { double VALUE_1; if (VALUE_.IndexOf('.') != -1) { VALUE_1 = double.Parse(VALUE_, CultureInfo.InvariantCulture); VALUE_1 = (double)Math.Round(VALUE_1, 3); VALUE_ = VALUE_1.ToString(); VALUE_ = VALUE_.Replace(',', '.'); } if (VALUE_.IndexOf(',') != -1) { VALUE_ = VALUE_.Replace(',', '.'); VALUE_1 = double.Parse(VALUE_, CultureInfo.InvariantCulture); VALUE_1 = (double)Math.Round(VALUE_1, 3); VALUE_ = VALUE_1.ToString(); VALUE_ = VALUE_.Replace(',', '.'); } if (type == "Газ") { //Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_,METERS_ID) values (GETDATE(),@VALUE_,@METERS_ID)", new SqlParameter[] {new SqlParameter("@VALUE_", VALUE_),new SqlParameter("@METERS_ID", mid) }, CommandType.Text); int count = (int)Mydb.ExecuteScalar("select COUNT(*) from METER_VALUE where DATE_= CONVERT(date, getdate())and METERS_ID=@METERS_ID", new SqlParameter[] { new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); if (count != 0) { Mydb.ExecuteNoNQuery("update METER_VALUE set VALUE_=CONVERT (numeric(20,3),@VALUE_) where METERS_ID=@mid and DATE_= CONVERT(date, getdate())", new SqlParameter[] { new SqlParameter("@VALUE_", VALUE_), new SqlParameter("@mid", meterId) }, CommandType.Text); } else { Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_,METERS_ID) values (GETDATE(),CONVERT (numeric(20,3),@VALUE_),@METERS_ID)", new SqlParameter[] { new SqlParameter("@VALUE_", VALUE_), new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); } } if (type == "Теплоэнергия") { //Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_,METERS_ID) values (GETDATE(),@VALUE_,@METERS_ID)", new SqlParameter[] { new SqlParameter("@VALUE_", VALUE_), new SqlParameter("@METERS_ID", mid) }, CommandType.Text); int count = (int)Mydb.ExecuteScalar("select COUNT(*) from METER_VALUE where DATE_= CONVERT(date, getdate())and METERS_ID=@METERS_ID", new SqlParameter[] { new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); if (count != 0) { Mydb.ExecuteNoNQuery("update METER_VALUE set VALUE_=CONVERT (numeric(20,3),@VALUE_) where METERS_ID=@mid and DATE_= CONVERT(date, getdate())", new SqlParameter[] { new SqlParameter("@VALUE_", VALUE_), new SqlParameter("@mid", meterId) }, CommandType.Text); } else { Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_,METERS_ID) values (GETDATE(),CONVERT (numeric(20,3),@VALUE_),@METERS_ID)", new SqlParameter[] { new SqlParameter("@VALUE_", VALUE_), new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); } } if (type == "ХВС") { //Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_,METERS_ID) values (GETDATE(),@VALUE_,@METERS_ID)", new SqlParameter[] { new SqlParameter("@VALUE_", VALUE_), new SqlParameter("@METERS_ID", mid) }, CommandType.Text); int count = (int)Mydb.ExecuteScalar("select COUNT(*) from METER_VALUE where DATE_= CONVERT(date, getdate())and METERS_ID=@METERS_ID", new SqlParameter[] { new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); if (count != 0) { Mydb.ExecuteNoNQuery("update METER_VALUE set VALUE_=CONVERT (numeric(20,3),@VALUE_) where METERS_ID=@mid and DATE_= CONVERT(date, getdate())", new SqlParameter[] { new SqlParameter("@VALUE_", VALUE_), new SqlParameter("@mid", meterId) }, CommandType.Text); } else { Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_,METERS_ID) values (GETDATE(),CONVERT (numeric(20,3),@VALUE_),@METERS_ID)", new SqlParameter[] { new SqlParameter("@VALUE_", VALUE_), new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); } } if (type == "ГВС") { //Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_,METERS_ID) values (GETDATE(),@VALUE_,@METERS_ID)", new SqlParameter[] { new SqlParameter("@VALUE_", VALUE_), new SqlParameter("@METERS_ID", mid) }, CommandType.Text); int count = (int)Mydb.ExecuteScalar("select COUNT(*) from METER_VALUE where DATE_= CONVERT(date, getdate())and METERS_ID=@METERS_ID", new SqlParameter[] { new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); if (count != 0) { Mydb.ExecuteNoNQuery("update METER_VALUE set VALUE_=CONVERT (numeric(20,3),@VALUE_) where METERS_ID=@mid and DATE_= CONVERT(date, getdate())", new SqlParameter[] { new SqlParameter("@VALUE_", VALUE_), new SqlParameter("@mid", meterId) }, CommandType.Text); } else { Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_,METERS_ID) values (GETDATE(),CONVERT (numeric(20,3),@VALUE_),@METERS_ID)", new SqlParameter[] { new SqlParameter("@VALUE_", VALUE_), new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); } } if (type != "Газ" && type != "Теплоэнергия" && type != "ХВС" && type != "ГВС") { string Tarif = type.Substring(type.IndexOf('_') + 1, 1); string ValueNumber = type.Substring(type.LastIndexOf('/') + 1, 1); if (Tarif == "3") { if (ValueNumber == "3") { int count = (int)Mydb.ExecuteScalar("select COUNT(*) from METER_VALUE where DATE_= CONVERT(date, getdate())and METERS_ID=@METERS_ID", new SqlParameter[] { new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); //Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_2,METERS_ID) values (GETDATE(),@VALUE_,@METERS_ID)", new SqlParameter[] { new SqlParameter("@VALUE_", VALUE_), new SqlParameter("@METERS_ID", mid) }, CommandType.Text); if (count != 0) { Mydb.ExecuteNoNQuery("update METER_VALUE set VALUE_3=CONVERT (numeric(20,3),@VALUE_3) where METERS_ID=@mid and DATE_= CONVERT(date, getdate())", new SqlParameter[] { new SqlParameter("@VALUE_3", VALUE_), new SqlParameter("@mid", meterId) }, CommandType.Text); } else { Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_,VALUE_2,VALUE_3,METERS_ID) values (GETDATE(),NULL,NULL,CONVERT (numeric(20,3),@VALUE_3),@METERS_ID)", new SqlParameter[] { new SqlParameter("@VALUE_3", VALUE_), new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); } } if (ValueNumber == "2") { int count = (int)Mydb.ExecuteScalar("select COUNT(*) from METER_VALUE where DATE_= CONVERT(date, getdate())and METERS_ID=@METERS_ID", new SqlParameter[] { new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); //Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_2,METERS_ID) values (GETDATE(),@VALUE_,@METERS_ID)", new SqlParameter[] { new SqlParameter("@VALUE_", VALUE_), new SqlParameter("@METERS_ID", mid) }, CommandType.Text); if (count != 0) { Mydb.ExecuteNoNQuery("update METER_VALUE set VALUE_2=CONVERT (numeric(20,3),@VALUE_2) where METERS_ID=@mid and DATE_= CONVERT(date, getdate())", new SqlParameter[] { new SqlParameter("@VALUE_2", VALUE_), new SqlParameter("@mid", meterId) }, CommandType.Text); } else { Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_,VALUE_2,VALUE_3,METERS_ID) values (GETDATE(),NULL,CONVERT (numeric(20,3),@VALUE_2),NULL,@METERS_ID)", new SqlParameter[] { new SqlParameter("@VALUE_2", VALUE_), new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); } } if (ValueNumber == "1") { int count = (int)Mydb.ExecuteScalar("select COUNT(*) from METER_VALUE where DATE_= CONVERT(date, getdate())and METERS_ID=@METERS_ID", new SqlParameter[] { new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); //Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_2,METERS_ID) values (GETDATE(),@VALUE_,@METERS_ID)", new SqlParameter[] { new SqlParameter("@VALUE_", VALUE_), new SqlParameter("@METERS_ID", mid) }, CommandType.Text); if (count != 0) { Mydb.ExecuteNoNQuery("update METER_VALUE set VALUE_=CONVERT (numeric(20,3),@VALUE_1) where METERS_ID=@mid and DATE_= CONVERT(date, getdate())", new SqlParameter[] { new SqlParameter("@VALUE_1", VALUE_), new SqlParameter("@mid", meterId) }, CommandType.Text); } else { Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_,VALUE_2,VALUE_3,METERS_ID) values (GETDATE(),CONVERT (numeric(20,3),@VALUE_1),NULL,NULL,@METERS_ID)", new SqlParameter[] { new SqlParameter("@VALUE_1", VALUE_), new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); } } } if (Tarif == "2") { if (ValueNumber == "2") { int count = (int)Mydb.ExecuteScalar("select COUNT(*) from METER_VALUE where DATE_= CONVERT(date, getdate())and METERS_ID=@METERS_ID", new SqlParameter[] { new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); //Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_2,METERS_ID) values (GETDATE(),@VALUE_,@METERS_ID)", new SqlParameter[] { new SqlParameter("@VALUE_", VALUE_), new SqlParameter("@METERS_ID", mid) }, CommandType.Text); if (count != 0) { Mydb.ExecuteNoNQuery("update METER_VALUE set VALUE_2=CONVERT (numeric(20,3),@VALUE_2) where METERS_ID=@mid and DATE_= CONVERT(date, getdate())", new SqlParameter[] { new SqlParameter("@VALUE_2", VALUE_), new SqlParameter("@mid", meterId) }, CommandType.Text); } else { Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_,VALUE_2,VALUE_3,METERS_ID) values (GETDATE(),NULL,CONVERT (numeric(20,3),@VALUE_2),NULL,@METERS_ID)", new SqlParameter[] { new SqlParameter("@VALUE_2", VALUE_), new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); } } if (ValueNumber == "1") { int count = (int)Mydb.ExecuteScalar("select COUNT(*) from METER_VALUE where DATE_= CONVERT(date, getdate())and METERS_ID=@METERS_ID", new SqlParameter[] { new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); //Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_2,METERS_ID) values (GETDATE(),@VALUE_,@METERS_ID)", new SqlParameter[] { new SqlParameter("@VALUE_", VALUE_), new SqlParameter("@METERS_ID", mid) }, CommandType.Text); if (count != 0) { Mydb.ExecuteNoNQuery("update METER_VALUE set VALUE_=CONVERT (numeric(20,3),@VALUE_1) where METERS_ID=@mid and DATE_= CONVERT(date, getdate())", new SqlParameter[] { new SqlParameter("@VALUE_1", VALUE_), new SqlParameter("@mid", meterId) }, CommandType.Text); } else { Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_,VALUE_2,VALUE_3,METERS_ID) values (GETDATE(),CONVERT (numeric(20,3),@VALUE_1),NULL,NULL,@METERS_ID)", new SqlParameter[] { new SqlParameter("@VALUE_1", VALUE_), new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); } } } if (Tarif == "1") { if (ValueNumber == "1") { int count = (int)Mydb.ExecuteScalar("select COUNT(*) from METER_VALUE where DATE_= CONVERT(date, getdate())and METERS_ID=@METERS_ID", new SqlParameter[] { new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); //Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_2,METERS_ID) values (GETDATE(),@VALUE_,@METERS_ID)", new SqlParameter[] { new SqlParameter("@VALUE_", VALUE_), new SqlParameter("@METERS_ID", mid) }, CommandType.Text); if (count != 0) { Mydb.ExecuteNoNQuery("update METER_VALUE set VALUE_=CONVERT (numeric(20,3),@VALUE_1) where METERS_ID=@mid and DATE_= CONVERT(date, getdate())", new SqlParameter[] { new SqlParameter("@VALUE_1", VALUE_), new SqlParameter("@mid", meterId) }, CommandType.Text); } else { Mydb.ExecuteNoNQuery("insert into METER_VALUE(DATE_,VALUE_,VALUE_2,VALUE_3,METERS_ID) values (GETDATE(),CONVERT (numeric(20,3),@VALUE_1),NULL,NULL,@METERS_ID)", new SqlParameter[] { new SqlParameter("@VALUE_1", VALUE_), new SqlParameter("@METERS_ID", meterId) }, CommandType.Text); } } } } return(Mydb.ExecuteAsJson("GetLastValueAndAVG_of_Meters", new SqlParameter[] { new SqlParameter("@id", meterId) }, CommandType.StoredProcedure)); //"{\"result\" : \"1\"}"; }
public static string GetDispName(int LgId) { return(Mydb.ExecuteAsJson("Get_supp_disp_Name", new SqlParameter[] { new SqlParameter("@lg", LgId) }, CommandType.StoredProcedure)); }
public static string getObjectByProjectId(int prj) { return(Mydb.ExecuteAsJson("getObjectByProjectId", new SqlParameter[] { new SqlParameter("@prj", prj) }, CommandType.StoredProcedure)); }
public static string GetSuppDispByObjectid(int obj, string supGuid) { return(Mydb.ExecuteAsJson("GetSuppDispByObjectid", new SqlParameter[] { new SqlParameter("@obj", obj), new SqlParameter("@supGuid", supGuid) }, CommandType.StoredProcedure)); }
public static string getObject(int CLId_, int ObjId_) { return(Mydb.ExecuteAsJson("getObjectById", new SqlParameter[] { new SqlParameter("@objId", ObjId_), new SqlParameter("@CL_Id", CLId_) }, CommandType.StoredProcedure)); }
public string getMetersValuesHistory(int mid) { return(Mydb.ExecuteAsJson("getMetersValuesHistory", new SqlParameter[] { new SqlParameter("@id", mid) }, CommandType.StoredProcedure)); }
public static string getObjectDisp(int lg, int role) { return(Mydb.ExecuteAsJson("GetObjectsByRole", new SqlParameter[] { new SqlParameter("@lg", lg), new SqlParameter("@role", role) }, CommandType.StoredProcedure)); }
public ContentResult LoginSecond_Idendity(string sc) { string pass = Mydb.ExecuteScalar("GetPassForIdendity", new SqlParameter[] { new SqlParameter("@sc", sc) }, CommandType.StoredProcedure).ToString(); return(Content(Mydb.ExecuteAsJson("LoginSecond", new SqlParameter[] { new SqlParameter("@sc", sc), new SqlParameter("@pass", pass) }, CommandType.StoredProcedure), "application/json"));//result }
public static string GetSuppliersByObjectId(int obj) { return(Mydb.ExecuteAsJson("GetSuppliersByObjectId", new SqlParameter[] { new SqlParameter("@obj", obj) }, CommandType.StoredProcedure)); }
public static string getExistSuppliers(int lg) { int clientId = (int)Mydb.ExecuteScalar("select CLIENT_ID from Account where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", lg) }, CommandType.Text); return(Mydb.ExecuteAsJson("[dbo].[GetSuppliers]", new SqlParameter[] { new SqlParameter("@Cid", clientId) }, CommandType.StoredProcedure)); }
// GET: Payments_Fili public string Get_accural_payments(string id, string login, string month, string type) { return(Mydb.ExecuteAsJson("TestDB.dbo.sp_QUICK_API_Get_accural_payments", new SqlParameter[] { new SqlParameter("@id", id), new SqlParameter("@login", "221900"), new SqlParameter("@type", type) }, CommandType.StoredProcedure)); }
public static string GetStreetsBytext(string txt) { return(Mydb.ExecuteAsJson("sp_KLADR_SEARCH_STREET", new SqlParameter[] { new SqlParameter("@SearchText", txt) }, CommandType.StoredProcedure)); }
public static string GetUPRRoles(int ClId) { return(Mydb.ExecuteAsJson("GetUPRRoles", new SqlParameter[] { new SqlParameter("@c", ClId) }, CommandType.StoredProcedure)); }
public static string GetRequestsForManager(int lg) { return(Mydb.ExecuteAsJson("GetRequestsForManager", new SqlParameter[] { new SqlParameter("@lg", lg) }, CommandType.StoredProcedure)); }
public static string GetProjects() { return(Mydb.ExecuteAsJson("GetProjects", new SqlParameter[] { }, CommandType.StoredProcedure)); }
public static string GetSupplierRequesets_LK(string guid) { return(Mydb.ExecuteAsJson("GetSupplierRequesets_LK", new SqlParameter[] { new SqlParameter("@guid", guid) }, CommandType.StoredProcedure)); }
public static string GetProjectForMan(int UoId) { return(Mydb.ExecuteAsJson("GetProjectForMan", new SqlParameter[] { new SqlParameter("@MC_ID", UoId) }, CommandType.StoredProcedure)); }
public static string getRoomTypes() { return(Mydb.ExecuteAsJson("getRoomTypes", new SqlParameter[] { }, CommandType.StoredProcedure)); }
public static string GetServicesBySuppGuid_LK(string guid) { return(Mydb.ExecuteAsJson("GetServicesBySuppGuid_LK", new SqlParameter[] { new SqlParameter("@guid", guid) }, CommandType.StoredProcedure)); }