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