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 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));
}
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 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));
}
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 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 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));
}
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 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 GetDisps(int C)
{
int CNTDisp = (int)Mydb.ExecuteScalar("select COUNT(*) from DISP where CLIENT_ID=@C", new SqlParameter[] { new SqlParameter("@C", C) }, CommandType.Text);
if (CNTDisp != 0)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("select d.DISP_ID,d.DISP_STATUS,d.DISP_NAME,dc.DISP_ICON_IMG from DISP d,DISP_ICON dc where d.DISP_ICON_ID=dc.DISP_ICON_ID and d.CLIENT_ID=@C order by d.DISP_ID desc", new SqlParameter[] { new SqlParameter("@C", C) }, CommandType.Text);
List <Dispatcheer> disps = new List <Dispatcheer>();
foreach (DataRow item in dt.Rows)
{
Dispatcheer d = new Dispatcheer();
d.DISP_ICON_IMG = item["DISP_ICON_IMG"].ToString();
d.DISP_ID = Convert.ToInt32(item["DISP_ID"]);
d.DISP_NAME = item["DISP_NAME"].ToString();
d.DISP_STATUS = Convert.ToBoolean(item["DISP_STATUS"]);
disps.Add(d);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(disps));
}
else
{
return("{\"result\" : \"2\"}");
}
}
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 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 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 AddNewService(string sname, string quantity, int unit, int dId, int prj, string cost)
{
int servId = (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) values (@servId,@prj,@cost)", new SqlParameter[] { new SqlParameter("@servId", servId), new SqlParameter("@prj", prj), new SqlParameter("@cost", cost) }, CommandType.Text);
return("");
}
public static string getLogin()
{
string nextLoginId = Mydb.ExecuteScalar("SELECT isnull(IDENT_CURRENT('ACCOUNT') + IDENT_INCR('ACCOUNT'),1)", new SqlParameter[] { }, CommandType.Text).ToString();
nextLoginId = "Login_" + nextLoginId;
return("{\"result\" : \"" + nextLoginId + "\"}");
}
public static string UpdateAcc(List <MR> SMSR, string accName_, string PNumb_, string Email_, string Pass_, string ClId_, string Login_, int LgId)
{
DataTable dt_Acc_Role = Mydb.ExecuteReadertoDataTable("select * from ACCOUNT_ROLE where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", LgId) }, CommandType.Text);
List <MR> mrs = new List <MR>();
foreach (DataRow item in dt_Acc_Role.Rows)
{
int Mr_Id = Convert.ToInt32(item["MR_ID"]);
Mydb.ExecuteNoNQuery("delete from MODUL_ROLE where MR_ID=@mr", new SqlParameter[] { new SqlParameter("@mr", Mr_Id) }, CommandType.Text);
}
Mydb.ExecuteNoNQuery("delete from ACCOUNT_ROLE where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", LgId) }, CommandType.Text);
foreach (MR mr in SMSR)
{
int M_Id = Convert.ToInt32(mr.sm);
int R_Id = Convert.ToInt32(mr.sr);
/*INSERT INTO table_name (column1, column2, column3, ...)
* VALUES (value1, value2, value3, ...);*/
Mydb.ExecuteNoNQuery("insert into MODUL_ROLE (MODUL_ID,ROLE_ID) values (@Mid,@Rid)", new SqlParameter[] { new SqlParameter("@Mid", M_Id), new SqlParameter("@Rid", R_Id) }, CommandType.Text);
int LastMr = (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(@l,@mr)", new SqlParameter[] { new SqlParameter("@l", LgId), new SqlParameter("@mr", LastMr) }, CommandType.Text);
}
//foreach (MR item in SMSR)
//{
// int mr_Id = (int)Mydb.ExecuteScalar("select MR_ID from MODUL_ROLE where ROLE_ID=@r and MODUL_ID=@m", new SqlParameter[]
// {
// new SqlParameter("@r",Convert.ToInt32(item.sr)),
// new SqlParameter("@m",Convert.ToInt32(item.sm))
// }, CommandType.Text);
// Mydb.ExecuteNoNQuery("insert into ACCOUNT_ROLE (LOG_IN_ID,MR_ID) values(@l,@mr)", new SqlParameter[] { new SqlParameter("@l", LgId), new SqlParameter("@mr", mr_Id) }, CommandType.Text);
//}
if (Pass_.Length != 0)
{
Pass_ = GetMd5HashData(Pass_);
Mydb.ExecuteNoNQuery("Update ACCOUNT set E_MAIL=@e,PHONE_NUMBER=@p,PASSWORD=@pas,ACCOUNT_NAME=@acc where LOG_IN_ID=@L", new SqlParameter[]
{ new SqlParameter("@e", Email_),
new SqlParameter("@p", PNumb_),
new SqlParameter("@acc", accName_),
new SqlParameter("@L", LgId),
new SqlParameter("@pas", Pass_) }, CommandType.Text);
}
else
{
Pass_ = GetMd5HashData(Pass_);
Mydb.ExecuteNoNQuery("Update ACCOUNT set E_MAIL=@e,PHONE_NUMBER=@p,ACCOUNT_NAME=@acc where LOG_IN_ID=@L", new SqlParameter[]
{ new SqlParameter("@e", Email_),
new SqlParameter("@p", PNumb_),
new SqlParameter("@acc", accName_),
new SqlParameter("@L", LgId) }, CommandType.Text);
}
return("{\"result\" : \"1\"}");
}
public static string GetDetailClient(int Cl)
{
int countRelationalDatas = (int)Mydb.ExecuteScalar("select count(*)from ACCOUNT a,CLIENT c, ENTITY_ADRESS e, ENTITY_TYPE et where et.ENTITY_TYPE_ID = c.ENTITY_TYPE_ID and e.ADRESS_ID = c.ADRESS_ID and c.CLIENT_ID = @c", new SqlParameter[] { new SqlParameter("@c", Cl) }, CommandType.Text);
if (countRelationalDatas == 0)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("select E_MAIL,PASSWORD from ACCOUNT where CLIENT_ID=@cl and LOGIN is null", new SqlParameter[] { new SqlParameter("@cl", Cl) }, CommandType.Text);
List <Account_> accs = new List <Account_>();
foreach (DataRow item in dt.Rows)
{
Account_ acc = new Account_();
acc.E_MAIL = item["E_MAIL"].ToString();
acc.PASSWORD = item["PASSWORD"].ToString();
accs.Add(acc);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(accs));
}
else
{
List <Account_> accs = new List <Account_>();
DataTable dt = Mydb.ExecuteReadertoDataTable("getDetailClient", new SqlParameter[] { new SqlParameter("@c", Cl) }, CommandType.StoredProcedure);
foreach (DataRow item in dt.Rows)
{
Account_ acc = new Account_();
acc.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
acc.COMPANY_NAME = item["COMPANY_NAME"].ToString();
acc.ENTITY_TYPE_ID = Convert.ToInt32(item["ENTITY_TYPE_ID"]);
acc.E_MAIL = item["E_MAIL"].ToString();
acc.HOUSE = item["HOUSE"].ToString();
acc.INN = item["INN"].ToString();
acc.KPP = item["KPP"].ToString();
acc.BNAME = item["BNAME"].ToString();
acc.INNB = item["INNB"].ToString();
acc.KPPB = item["KPPB"].ToString();
acc.ADRESS_ID = item["ADRESS_ID"].ToString();
acc.BIK = item["BIK"].ToString();
acc.BKRS = item["BKRS"].ToString();
acc.RS = item["RS"].ToString();
acc.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
acc.OGRN_OGRNIP = item["OGRN_OGRNIP"].ToString();
acc.OKPO = item["OKPO"].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 ContentResult LoginSecond(string sc, string pass)
{
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\"}";
}
//res.Content = new StringContent(result.ToString(), Encoding.UTF8, "text/csv");
return(Content(result, "application/json"));//result
}
public static string AFilterin2(List <Kvorum_App.Disp_Admin.Utilities.Filter> flt, int Log)
{
string REQUEST_ID = "";
string ROOM_NUMBER = "";
string OBJECT_ID = "";
string ROOM_TYPE_ID = "";
string FIRST_NAME = "";
string STATUS_ID = "";
string CR_DATE_from = "";
string CR_DATEE_TO = "";
foreach (Kvorum_App.Disp_Admin.Utilities.Filter item in flt)
{
REQUEST_ID = (item.REQUEST_ID != 0) ? "REQUEST_ID=" + item.REQUEST_ID.ToString() : "";
ROOM_NUMBER = (item.ROOM_NUMBER != "0") ? "REQUEST_COMMENT like q%wroomwLw" + item.ROOM_NUMBER.ToString() + "w%q" : "";
ROOM_NUMBER = (ROOM_NUMBER != "") ? ROOM_NUMBER.Replace("q", "'").Replace("w", "\"").Replace("L", ":") : "";
OBJECT_ID = (item.OBJECT_ID != 0) ? "REQUEST_COMMENT like q%zObject_Idzw" + item.OBJECT_ID.ToString() + "%q" : "";
OBJECT_ID = (OBJECT_ID != "") ? OBJECT_ID.Replace("q", "'").Replace("z", "\"").Replace("w", ":") : "";
//ROOM_TYPE_ID = (item.ROOM_TYPE_ID != 0) ? "ROOM_TYPE_ID=" + item.ROOM_TYPE_ID.ToString() + "" : "";
FIRST_NAME = (item.FIRST_NAME != "") ? "REQUEST_COMMENT like q%windNamewLw" + item.FIRST_NAME + "w%q" : "";
FIRST_NAME = (FIRST_NAME != "") ? FIRST_NAME.Replace("q", "'").Replace("w", "\"").Replace("L", ":") : "";
STATUS_ID = (item.STATUSE != 0) ? "STATUS_ID=" + item.STATUSE.ToString() : "";
CR_DATE_from = (item.CR_DATE_FROM != "") ? string.Format("CR_DATE >=\"{0}\"", item.CR_DATE_FROM) : "";
CR_DATE_from = (CR_DATE_from != "") ? CR_DATE_from.Replace("\"", "'") : "";
CR_DATEE_TO = (item.CR_DATE_TO != "") ? string.Format("CR_DATE<=\"{0}\"", item.CR_DATE_TO) : "";
CR_DATEE_TO = (CR_DATEE_TO != "") ? CR_DATEE_TO.Replace("\"", "'") : "";
}
string Clid = Mydb.ExecuteScalar("select CLIENT_ID from VW_ALL_REQUESTS_2 where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", Log) }, CommandType.Text).ToString();
string query = "select * from VW_ALL_REQUESTS_2 where CLIENT_ID=" + Clid + " " + ((REQUEST_ID != "") ? " and " + REQUEST_ID : " ") + " " + ((STATUS_ID != "") ? " and " + STATUS_ID : " ") + " " + ((CR_DATE_from != "") ? " and " + CR_DATE_from : " ") + " " + ((CR_DATEE_TO != "") ? " and " + CR_DATEE_TO : " ") + " " + ((ROOM_NUMBER != "") ? " and " + ROOM_NUMBER : " ") + " " + ((OBJECT_ID != "") ? " and " + OBJECT_ID : " ") + " " + ((FIRST_NAME != "") ? " and " + FIRST_NAME : " ");
System.Data.DataTable dt = Mydb.ExecuteReadertoDataTable(query, new SqlParameter[] { }, CommandType.Text);
List <Request> rs = new List <Utilities.Request>();
foreach (DataRow item in dt.Rows)
{
Request r = new Utilities.Request();
r.CR_DATE = item["CR_DATE"].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.COMMENT_FILE = (Convert.ToInt32(item["LOG_IN_ID"]) == Log) ? "Curr" : "NoC";
rs.Add(r);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(rs));
}
public static string GetDispName(int LgId)
{
string DspName = Mydb.ExecuteScalar("select ACCOUNT_NAME from ACCOUNT where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", LgId) }, CommandType.Text).ToString();
string dspPhone = Mydb.ExecuteScalar("select DISP_PHONE_NUMBER from DISP where DISP_ID in (select DISP_ID from DISP_ACC where LOG_IN_ID = @lg)", new SqlParameter[] { new SqlParameter("@lg", LgId) }, CommandType.Text).ToString();
string dspPhoneUrl = Mydb.ExecuteScalar("select PHONE_URL from DISP_PHONES where PHONE=@Ph", new SqlParameter[] { new SqlParameter("@Ph", dspPhone) }, CommandType.Text).ToString();
string dispPPass = Mydb.ExecuteScalar(" select [PHONE_PWD] from DISP_PHONES where PHONE=@Ph", new SqlParameter[] { new SqlParameter("@Ph", dspPhone) }, CommandType.Text).ToString();
//
string dspetName = Mydb.ExecuteScalar("select DISP_NAME from DISP where DISP_ID in (select DISP_ID from DISP_ACC where LOG_IN_ID = @lg)", new SqlParameter[] { new SqlParameter("@lg", LgId) }, CommandType.Text).ToString();
string ddspId = Mydb.ExecuteScalar("select DISP_ID from DISP_ACC where LOG_IN_ID = @lg", new SqlParameter[] { new SqlParameter("@lg", LgId) }, CommandType.Text).ToString();
return("{\"dspName\" : \"" + DspName + "\",\"Phone\":\"" + dspPhone + "\",\"DName\":\"" + dspetName + "\",\"DDId\":\"" + ddspId + "\",\"PhUrl\":\"" + dspPhoneUrl + "\",\"PhPwd\":\"" + dispPPass + "\"}");
}
public static string CheckkDisp(int Log)
{
int CountDisp = (int)Mydb.ExecuteScalar("select COUNT(*) from DISP_ACC where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", Log) }, CommandType.Text);
if (CountDisp == 0)
{
return("{\"HasDisp\" : \"0\"}");
}
else
{
return("{\"HasDisp\" : \"1\"}");
}
}
public static string CheckMail(string email)
{
int EmCount = (int)Mydb.ExecuteScalar("select COUNT(*) from ACCOUNT where E_MAIL=@em", new SqlParameter[] { new SqlParameter("@em", email) }, CommandType.Text);
if (EmCount == 0)
{
return("{\"result\" : \"0\"}");
}
else
{
return("{\"result\" : \"1\"}");
}
}
public static string CheckRS(string RS)
{
int COuntRs = (int)Mydb.ExecuteScalar("select COUNT(*) from RS where RS=@rs", new SqlParameter[] { new SqlParameter("@rs", RS) }, CommandType.Text);
if (COuntRs != 0)
{
return("{\"result\" : \"1\"}");;
}
else
{
return("{\"result\" : \"0\"}");
}
}
public static string CheckCountOfRequestForResponsible(int Log)
{
int CountDisp = (int)Mydb.ExecuteScalar("CheckCountOfRequestForResponsible", new SqlParameter[] { new SqlParameter("@lg", Log) }, CommandType.StoredProcedure);
if (CountDisp == 0)
{
return("{\"CountRequest\" : \"0\"}");
}
else
{
return("{\"CountRequest\" : \"1\"}");
}
}
public static string DispDelete(int DD)
{
int IconId = (int)Mydb.ExecuteScalar("select DISP_ICON_ID from DISP where DISP_ID=@d", new SqlParameter[] { new SqlParameter("@d", DD) }, CommandType.Text);
string PhDisp_ = Mydb.ExecuteScalar("select DISP_PHONE_NUMBER from DISP where DISP_ID=@DD", new SqlParameter[] { new SqlParameter("@DD", DD) }, CommandType.Text).ToString();
Mydb.ExecuteNoNQuery("Update DISP_PHONES set BUSY=0 where PHONE=@ph", new SqlParameter[] { new SqlParameter("@ph", PhDisp_) }, CommandType.Text);
Mydb.ExecuteNoNQuery("delete from DISP_ICON where DISP_ICON_ID=@ic", new SqlParameter[] { new SqlParameter("@ic", IconId) }, CommandType.Text);
Mydb.ExecuteNoNQuery("delete from DISP_OBJECT where DISP_ID=@d", new SqlParameter[] { new SqlParameter("@d", DD) }, CommandType.Text);
Mydb.ExecuteNoNQuery("delete from DISP_ACC where DISP_ID=@d", new SqlParameter[] { new SqlParameter("@d", DD) }, CommandType.Text);
Mydb.ExecuteNoNQuery("delete from DISP where DISP_ID=@d", new SqlParameter[] { new SqlParameter("@d", DD) }, CommandType.Text);
return("");
}
public static string ChkPass(int Log, string Pass)
{
string dbPass = Mydb.ExecuteScalar("select PASSWORD from ACCOUNT where LOG_IN_ID=@L", new SqlParameter[] { new SqlParameter("@L", Log) }, CommandType.Text).ToString();
Pass = GetMd5HashData(Pass);
if (dbPass == Pass)
{
return("{\"result\" : \"0\"}");
}
else
{
return("{\"result\" : \"1\"}");
}
}
public static string makeVipol(int Rid, List <RsFile> rsf, string rst, List <ProductService_> prs, string opl, string login_id)
{
Mydb.ExecuteNoNQuery("insert into REQUEST_STATUS_TEXT_SUPPLIERS (RS_TEXT) values (@rst)", new SqlParameter[] { new SqlParameter("@rst", rst) }, CommandType.Text);
int LastId = (int)Mydb.ExecuteScalar(" select top 1 RST_ID from REQUEST_STATUS_TEXT_SUPPLIERS order by RST_ID desc", new SqlParameter[] { }, CommandType.Text);
foreach (RsFile item in rsf)
{
if (item.ImgAdres == "0")
{
Mydb.ExecuteNoNQuery("insert into REQUEST_STATUS_FILE_SUPPLIERS (REQUEST_ID,FILE_ADRESS,RST_ID)values (@r_id,@fs,@rst)", new SqlParameter[] { new SqlParameter("@r_id", Rid), new SqlParameter("@fs", "0"), new SqlParameter("@rst", LastId) }, CommandType.Text);
}
else
{
Mydb.ExecuteNoNQuery("insert into REQUEST_STATUS_FILE_SUPPLIERS (REQUEST_ID,FILE_ADRESS,RST_ID)values (@r_id,@fs,@rst)", new SqlParameter[] { new SqlParameter("@r_id", Rid), new SqlParameter("@fs", item.ImgAdres), new SqlParameter("@rst", LastId) }, CommandType.Text);
}
}
Mydb.ExecuteNoNQuery("Update REQUEST_SUPPLIERS set STATUS_ID=3,DONE_DATE=GETDATE(),PAYMENT=@PAYMENT where REQUEST_ID=@rid", new SqlParameter[] { new SqlParameter("@rid", Rid), new SqlParameter("@PAYMENT", Convert.ToBoolean(opl)) }, CommandType.Text);
// Mydb.ExecuteNoNQuery("delete from REQUEST_SERVICE where REQUEST_ID=@REQUEST_ID", new SqlParameter[] { new SqlParameter("@REQUEST_ID", Rid) }, CommandType.Text);
//foreach (ProductService_ item in prs)
//{
// Mydb.ExecuteNoNQuery("insert into REQUEST_SERVICE (REQUEST_ID,P_SERVICE_ID,QUANTITY,COST) values (@Rid,@PId,@Q,@C)", new SqlParameter[] {
// new SqlParameter("@Rid",Rid),
// new SqlParameter("@PId",item.SERVICE_ID),
// new SqlParameter("@Q",item.QUANTITY),
// new SqlParameter("@C",item.COST)}, 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",Convert.ToBoolean(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",3),new SqlParameter("@COMMENT",""),new SqlParameter("@WHO",login_id) }, CommandType.StoredProcedure);
return("");
//if (comment.Length==0)
//{
//
// return "";
//}
//else
//{
// Mydb.ExecuteNoNQuery("Update REQUEST set STATUS_ID=3 where REQUEST_ID=@rid", new SqlParameter[] { new SqlParameter("@rid", Rid) }, CommandType.Text);
// Mydb.ExecuteNoNQuery("insert into REQUEST_COMMENT (REQUEST_COMMENT, REQUEST_ID) values(@rc,@rid)", new SqlParameter[] { new SqlParameter("@rc",comment),new SqlParameter("@rid",Rid) }, CommandType.Text);
// return "";
//}
}
public static string getPhone()
{
int COuntDSPh = (int)Mydb.ExecuteScalar("select COUNT (*) from DISP_PHONES where BUSY=0", new SqlParameter[] { }, CommandType.Text);
if (COuntDSPh != 0)
{
string Phone = Mydb.ExecuteScalar(" select top 1 PHONE from DISP_PHONES where BUSY=0 order by ID asc", new SqlParameter[] { }, CommandType.Text).ToString();
return("{\"phone\" : \"" + Phone + "\"}");
}
else
{
return("{\"phone\" : \"000\"}");
}
}
public static string RelationObject(int Uo_)
{
string returnval = null;
int countRelation = (int)Mydb.ExecuteScalar("select COUNT(*) from OBJECT where MAN_COMP_ID=@uo", new SqlParameter[] { new SqlParameter("@uo", Uo_) }, CommandType.Text);
if (countRelation == 0)
{
returnval = "{\"result\" : \"0\"}";
}
if (countRelation > 0)
{
returnval = "{\"result\" : \"1\"}";
}
return(returnval);
}
public static string GetCounts(int lg)
{
int Count = (int)Mydb.ExecuteScalar("select COUNT(*) from VW_Request_Datas_1_2 where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", lg) }, CommandType.Text);
int CVrabot = (int)Mydb.ExecuteScalar("select COUNT(*) from VW_Request_Datas_1_2 where LOG_IN_ID=@lg and STATUS_ID=1", new SqlParameter[] { new SqlParameter("@lg", lg) }, CommandType.Text);
double Vrabot_ = 0;
if (Count != 0 && CVrabot != 0)
{
Vrabot_ = (double)(100 * CVrabot) / Count;
Vrabot_ = System.Math.Round(Vrabot_, 2);
}
int CVipol = (int)Mydb.ExecuteScalar("select COUNT(*) from VW_Request_Datas_1_2 where LOG_IN_ID=@lg and STATUS_ID=3", new SqlParameter[] { new SqlParameter("@lg", lg) }, CommandType.Text);
double Vipol = 0;
if (Count != 0 && CVipol != 0)
{
Vipol = (double)(100 * CVipol) / Count;
Vipol = System.Math.Round(Vipol, 2);
}
int COtmen = (int)Mydb.ExecuteScalar("select COUNT(*) from VW_Request_Datas_1_2 where LOG_IN_ID=@lg and STATUS_ID=4", new SqlParameter[] { new SqlParameter("@lg", lg) }, CommandType.Text);
double Otmen = 0;
if (COtmen != 0 && Count != 0)
{
Otmen = (double)(100 * COtmen) / Count;
Otmen = System.Math.Round(Otmen, 2);
}
int CZakrit = (int)Mydb.ExecuteScalar("select COUNT(*) from VW_Request_Datas_1_2 where LOG_IN_ID=@lg and STATUS_ID=5", new SqlParameter[] { new SqlParameter("@lg", lg) }, CommandType.Text);
double Zakrit = 0;
if (CZakrit != 0 && Count != 0)
{
Zakrit = (double)(100 * CZakrit) / Count;
Zakrit = System.Math.Round(Zakrit, 2);
}
return("{\"CVrabot\" : \"" + CVrabot.ToString() + "\",\"Vrabot\" :\"" + Vrabot_.ToString() + "\",\"CVipol\" :\"" + CVipol.ToString() + "\",\"Vipol\":\"" + Vipol.ToString() + "\",\"COtmen\" :\"" + COtmen.ToString() + "\",\"Otmen\" :\"" + Otmen.ToString() + "\",\"CZakrit\" :\"" + CZakrit.ToString() + "\",\"Zakrit\" :\"" + Zakrit.ToString() + "\",\"Alloff\" :\"" + Count.ToString() + "\"}");
}
