public static string DeleteDirection(string d_guid)
{
//Mydb.ExecuteNoNQuery("delete from SELECTED_SERVICE_SET_ICON where SSS_ID=@sid and PROJECT_ID=@prj", new SqlParameter[] { new SqlParameter("@sid",sid),
// new SqlParameter("@prj",prj) }, CommandType.Text);
Mydb.ExecuteNoNQuery("DeleteDirection", new SqlParameter[] { new SqlParameter("@d_guid", d_guid) }, CommandType.StoredProcedure);
return("");
}
public static string MakeZakrit(int Rid, string comment, string login_id)
{
if (comment.Length == 0)
{
Mydb.ExecuteNoNQuery("Update REQUEST_SUPPLIERS set STATUS_ID=5 where REQUEST_ID=@rid", new SqlParameter[] { new SqlParameter("@rid", Rid) }, CommandType.Text);
//foreach (ProductService_ item in prs)
//{
// Mydb.ExecuteNoNQuery("update REQUEST_SERVICE set P_SERVICE_ID=@P_SERVICE_ID, QUANTITY=@QUANTITY, COST=@COST where REQUEST_ID=@REQUEST_ID", new SqlParameter[] { new SqlParameter("@P_SERVICE_ID", item.SERVICE_ID), new SqlParameter("@QUANTITY", item.QUANTITY), new SqlParameter("@COST", item.COST), new SqlParameter("@REQUEST_ID", Rid) }, CommandType.Text);
//}
// Mydb.ExecuteNoNQuery("Update REQUEST set PAYMENT=@PAYMENT where REQUEST_ID=@REQUEST_ID", new SqlParameter[] { new SqlParameter("@PAYMENT", opl), new SqlParameter("@REQUEST_ID",Rid) }, CommandType.Text);
// object MobileNumber1 = Mydb.ExecuteScalar("select MOBILE_NUMBER from REQUEST WHERE REQUEST_ID=@rid", new SqlParameter[] { new SqlParameter("@rid", Rid) }, CommandType.Text);
// Mydb.ExecuteNoNQuery("[TestDB].[dbo].[sp_QUICK_API_request_change_status_autopilot]", new SqlParameter[] { new SqlParameter("@MOBILE_NUMBER", Convert.ToInt64(MobileNumber1)), new SqlParameter("@NEW_STATUS", 5), new SqlParameter("@COMMENT", ""), new SqlParameter("@WHO", login_id) }, CommandType.StoredProcedure);
return("");
}
else
{
Mydb.ExecuteNoNQuery("Update REQUEST_SUPPLIERS set STATUS_ID=5 where REQUEST_ID=@rid", new SqlParameter[] { new SqlParameter("@rid", Rid) }, CommandType.Text);
Mydb.ExecuteNoNQuery("insert into REQUEST_COMMENT_SUPPLIERS (REQUEST_COMMENT, REQUEST_ID) values(@rc,@rid)", new SqlParameter[] { new SqlParameter("@rc", comment), new SqlParameter("@rid", Rid) }, CommandType.Text);
//foreach (ProductService_ item in prs)
//{
// Mydb.ExecuteNoNQuery("update REQUEST_SERVICE set P_SERVICE_ID=@P_SERVICE_ID, QUANTITY=@QUANTITY, COST=@COST where REQUEST_ID=@REQUEST_ID", new SqlParameter[] { new SqlParameter("@P_SERVICE_ID", item.SERVICE_ID), new SqlParameter("@QUANTITY", item.QUANTITY), new SqlParameter("@COST", item.COST), new SqlParameter("@REQUEST_ID", Rid) }, CommandType.Text);
//}
// Mydb.ExecuteNoNQuery("Update REQUEST set PAYMENT=@PAYMENT where REQUEST_ID=@REQUEST_ID", new SqlParameter[] { new SqlParameter("@PAYMENT", opl), new SqlParameter("@REQUEST_ID", Rid) }, CommandType.Text);
}
// object MobileNumber = Mydb.ExecuteScalar("select MOBILE_NUMBER from REQUEST WHERE REQUEST_ID=@rid", new SqlParameter[] { new SqlParameter("@rid", Rid) }, CommandType.Text);
//Mydb.ExecuteNoNQuery("[TestDB].[dbo].[sp_QUICK_API_request_change_status_autopilot]", new SqlParameter[] { new SqlParameter("@MOBILE_NUMBER", Convert.ToInt64(MobileNumber)), new SqlParameter("@NEW_STATUS", 5), new SqlParameter("@COMMENT", ""), new SqlParameter("@WHO", login_id) }, CommandType.StoredProcedure);
return("");
}
public static string UpdateMeter(int METERS_ID, int ROOM_TYPE_ID, string ROOM_NUMBER, string SCORE_ID, string METERS_NUMBER, int TYPE_ID, int AMUNT_TARIF, string PREVIOUS_DATE, string NEXT_DATE, string IS_AUTO)
{
//Mydb.ExecuteNoNQuery("UPDATE METERS SET ROOM_TYPE_ID=@ROOM_TYPE_ID,SCORE_ID=@SCORE_ID,METERS_NUMBER=@METERS_NUMBER,TYPE_ID=@TYPE_ID,AMUNT_TARIF=@AMUNT_TARIF,PREVIOUS_DATE=@PREVIOUS_DATE,NEXT_DATE=@NEXT_DATE WHERE METERS_ID=@METERS_ID", new SqlParameter[] {new SqlParameter("@ROOM_TYPE_ID",ROOM_TYPE_ID),
// new SqlParameter("@SCORE_ID",SCORE_ID),
// new SqlParameter("@METERS_NUMBER",METERS_NUMBER),
// new SqlParameter("@AMUNT_TARIF",AMUNT_TARIF),
// new SqlParameter("@PREVIOUS_DATE",PREVIOUS_DATE),
// new SqlParameter("@NEXT_DATE",NEXT_DATE),
// new SqlParameter("@TYPE_ID",TYPE_ID),
// new SqlParameter("@ROOM_NUMBER",ROOM_NUMBER),new SqlParameter("@METERS_ID",METERS_ID)
// }, CommandType.Text);
//string historyText = "Данные счетчика были изменены";
//Mydb.ExecuteNoNQuery("insert into METERS_HISTORY(DATETIME,EVENT,AUTHOR,FILE_,METERS_ID) values( CONVERT(date, getdate()),@historyText,(select ACCOUNT_NAME from ACCOUNT where LOG_IN_ID = (select LOG_IN_ID from VW_METERS where METERS_ID=@mid)),'-',@METERS_ID)", new SqlParameter[] { new SqlParameter("@historyText", historyText), new SqlParameter("@mid", METERS_ID), new SqlParameter("@METERS_ID", METERS_ID) }, CommandType.Text);
Mydb.ExecuteNoNQuery("UpdateMeter", new SqlParameter[] { new SqlParameter("@ROOM_TYPE_ID", ROOM_TYPE_ID),
new SqlParameter("@SCORE_ID", SCORE_ID),
new SqlParameter("@METERS_NUMBER", METERS_NUMBER),
new SqlParameter("@AMUNT_TARIF", AMUNT_TARIF),
new SqlParameter("@PREVIOUS_DATE", PREVIOUS_DATE),
new SqlParameter("@NEXT_DATE", NEXT_DATE),
new SqlParameter("@TYPE_ID", TYPE_ID),
new SqlParameter("@ROOM_NUMBER", ROOM_NUMBER),
new SqlParameter("@METERS_ID", METERS_ID),
new SqlParameter("@IS_AUTO", IS_AUTO) }, CommandType.StoredProcedure);
return("");
}
public static string SendMail(string Login_Mail, string pass_, string Email_)
{
string succEm = "0";
//string protocol = Mydb.ExecuteScalar("select DOMAIN_NAME from OBJECT_DOMAIN where OBJECT_ID=@o", new SqlParameter[] { new SqlParameter("@o", ObjecId) }, CommandType.Text).ToString();
//protocol = protocol = protocol.Substring(0, protocol.IndexOf('.'));
//protocol = HttpContext.Current.Request.Url.Scheme + "://" + HttpContext.Current.Request.Url.Host + "/" + protocol + "/LoginT.aspx";
//string score = datas[0];
string pass = pass_;
string text_ = "Для Вас создана учётная запись";
string body = @"<div style=""display: block; width: 100 %; height: 100 %; background - color: #f3f3f3; margin: 0px; padding: 0px; padding: 10px; font-family: sans-serif;""><div style=""display: block; max-width: 700px; margin-left: auto; margin-right: auto; background-color: #ffffff; padding: 20px;""><p>{0} в системе «УПРАВБОТ».</p><p>Ваш логин: <b>""{1}""</b></p><p>Ваш пароль:<b>""{2}""</b></p><p>Перейти в УправБот Вы можете по ссылке <a href=""https://upravbot.ru"">https://upravbot.ru</a></p<br><p>При возникновении вопросов по работе портала «УПРАВБОТ», пожалуйста, обратитесь в техподдержку: <a href=""mailto:[email protected]"">[email protected] </a></p><br><p>C уважением, Ваш «УПРАВБОТ».</p></div></div>";
//string mobile = HttpContext.Current.Request.Url.Scheme + "://" + HttpContext.Current.Request.Url.Host + "/getmobile.aspx";
body = String.Format(body, text_, Login_Mail, pass);
try
{
Mydb.ExecuteNoNQuery("sp_Send_Mail_Upravbot", new SqlParameter[] { new SqlParameter("@mailto", Email_), new SqlParameter("@theme", "Upravbot.ru"), new SqlParameter("@body", body) }, CommandType.StoredProcedure);
succEm = "1";
}
catch (Exception)
{
succEm = "0";
}
return(succEm);
}
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 UpdatingService(string sname, string quantity, int unit, int servId, int prj, string cost)
{
Mydb.ExecuteNoNQuery("update PRODUCT_SERVICE set SERVICE_NAME=@sname ,QUANTITY_IS=@quantity ,UNIT_OF_MEASURE_ID=@unit where SERVICE_ID=@servId", new SqlParameter[] { new SqlParameter("@sname", sname), new SqlParameter("@quantity", quantity), new SqlParameter("@unit", unit), new SqlParameter("@servId", servId) }, CommandType.Text);
Mydb.ExecuteNoNQuery("insert into PROJECT_PRODUCT_SERVICE (PRODUCT_SERVICE_ID,PROJECT_ID,COST) values(@servId,@prj,@cost)", new SqlParameter[] { new SqlParameter("@servId", servId), new SqlParameter("@prj", prj), new SqlParameter("@cost", cost) }, CommandType.Text);
return("");
}
public static string 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 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 MakeStop(int mid, string St_date, string cmnt, string file, int lg)
{
// Mydb.ExecuteNoNQuery("insert into STOPED_METERS(METER_ID,DATE_STOP,COMMENT,DOC) values (@METER_ID,Cast(@DATE_STOP as date),@COMMENT,@DOC)", new SqlParameter[] { new SqlParameter("@METER_ID", mid),new SqlParameter("@DATE_STOP", St_date),new SqlParameter("@COMMENT",cmnt),new SqlParameter("@DOC",file) }, CommandType.Text);
Mydb.ExecuteNoNQuery("update METERS set SUSBEND='1' where METERS_ID=@mid", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.Text);
//Mydb.ExecuteNoNQuery("insert into METERS_HISTORY='Счетчик приостановлен. Дата выхода из строя:"+St_date+ ". Комментарий'")
Mydb.ExecuteNoNQuery("insert into METERS_HISTORY(DATETIME,EVENT,AUTHOR,FILE_,METERS_ID) values( CONVERT(date, getdate()),'Счетчик приостановлен. Дата выхода из строя: " + St_date + ". Комментарий: " + cmnt + "', (select ACCOUNT_NAME from ACCOUNT WHERE LOG_IN_ID = @lg),@file,@mid)", new SqlParameter[] { new SqlParameter("@lg", lg), new SqlParameter("@file", file), new SqlParameter("@mid", mid) }, CommandType.Text);
return("");
}
public static string UpdateDirect(string d_guid, string NAME, string ICON, int respId)
{
//string DName,int dId,string DIconId,int prj
//Mydb.ExecuteNoNQuery("update SERVICE_DIRECT set DIRECTION_NAME=@Dname where DIRECTION_ID=@dId", new SqlParameter[] { new SqlParameter("@dId",dId),new SqlParameter("@Dname",DName) }, CommandType.Text);
//Mydb.ExecuteNoNQuery("update SDIRECT_SICON set ICON_ID=@DIconId where S_DIRECT_ID=@dId and PROJECT_ID=@prj", new SqlParameter[] { new SqlParameter("@DIconId",DIconId),new SqlParameter("@dId",dId),new SqlParameter("@prj",prj) }, CommandType.Text);
Mydb.ExecuteNoNQuery("UpdateDirect", new SqlParameter[] { new SqlParameter("@d_guid", d_guid), new SqlParameter("@NAME", NAME), new SqlParameter("@ICON", ICON), new SqlParameter("@respId", respId) }, CommandType.StoredProcedure);
return("");
}
public static string SaveHFile(int R, List <RsFile> imgs)
{
foreach (RsFile item in imgs)
{
if (item.ImgAdres != "")
{
Mydb.ExecuteNoNQuery("insert into REQUEST_COMMENT_SUPPLIERS (REQUEST_ID,H_COMMNET_FILE) values(@rid,@url)", new SqlParameter[] { new SqlParameter("@rid", R), new SqlParameter("@url", item.ImgAdres) }, CommandType.Text);
}
}
return("");
}
public static string MakeOtmen(int Rid, string login_id)
{// List<ProductService_> prs, string opl,
Mydb.ExecuteNoNQuery("Update REQUEST_SUPPLIERS set STATUS_ID=4 where REQUEST_ID=@rid", new SqlParameter[] { new SqlParameter("@rid", Rid) }, CommandType.Text);
//foreach (ProductService_ item in prs)
//{
// Mydb.ExecuteNoNQuery("update REQUEST_SERVICE set P_SERVICE_ID=@P_SERVICE_ID, QUANTITY=@QUANTITY, COST=@COST where REQUEST_ID=@REQUEST_ID", new SqlParameter[] { new SqlParameter("@P_SERVICE_ID", item.SERVICE_ID), new SqlParameter("@QUANTITY", item.QUANTITY), new SqlParameter("@COST", item.COST), new SqlParameter("@REQUEST_ID", Rid) }, CommandType.Text);
//}
//Mydb.ExecuteNoNQuery("Update REQUEST set PAYMENT=@PAYMENT where REQUEST_ID=@REQUEST_ID", new SqlParameter[] { new SqlParameter("@PAYMENT", opl), new SqlParameter("@REQUEST_ID", Rid) }, CommandType.Text);
// object 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", 4), new SqlParameter("@COMMENT", ""), new SqlParameter("@WHO", login_id) }, CommandType.StoredProcedure);
return("");
}
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 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 Update_Object(int ObjId, string ObjAdres, string ObjName, string ManKompId, string KladrId, string Photo, int LogId, int PROJECT_ID)
{
Mydb.ExecuteNoNQuery("Update_Object", new SqlParameter[] {
new SqlParameter("@objId", ObjId),
new SqlParameter("@objAdres", ObjAdres),
new SqlParameter("@ObjectName", ObjName),
new SqlParameter("@ManCompId", ManKompId),
new SqlParameter("@photo", Photo),
new SqlParameter("@kladrId", KladrId),
new SqlParameter("@lg", LogId),
new SqlParameter("@p_Id", PROJECT_ID)
}, CommandType.StoredProcedure);
return("{\"result\" : \"1\"}");
}
public static string DeleteAccount(int LogId)
{
Mydb.ExecuteNoNQuery("delete from ACCOUNT where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", LogId) }, CommandType.Text);
DataTable dt_Acc_Role = Mydb.ExecuteReadertoDataTable("select * from ACCOUNT_ROLE where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", LogId) }, 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", LogId) }, CommandType.Text);
return("{\"result\" : \"1\"}");
}
public string SavePaymentsDetails(bool Success, string ErrorCode, string TerminalKey, string Status, string OrderId, string Amount, string PaymentId, string PaymentURL)
{
Mydb.ExecuteNoNQuery("insert into TRY_PAYMENTS (SUCCESS,ERROR_CODE,TERMINAL_KEY,STATUS,PAYMENT_ID,ORDER_ID,AMOUNT,PAYMENT_URL) values (@SUCCESS,@ERROR_CODE,@TERMINAL_KEY,@STATUS,@PAYMENT_ID,@ORDER_ID,@AMOUNT,@PAYMENT_URL)", new SqlParameter[] {
new SqlParameter("@SUCCESS", Success),
new SqlParameter("@ERROR_CODE", ErrorCode),
new SqlParameter("@TERMINAL_KEY", TerminalKey),
new SqlParameter("@STATUS", Status),
new SqlParameter("@PAYMENT_ID", PaymentId),
new SqlParameter("@ORDER_ID", OrderId),
new SqlParameter("@AMOUNT", Amount),
new SqlParameter("@PAYMENT_URL", PaymentURL)
}, CommandType.Text);
return("{\"result\" : \"ok\"}");
}
public static string UpdateServiceSet(string ssn, int sid, int prj, int siconid, int lg)
{
//string dname,int dIconId,string sname,string quantity,int unit,string cost
Mydb.ExecuteNoNQuery("update SERVICE_SET set SERVICE_SET_NAME=@ssn where SERVICE_SET_ID=@sid", new SqlParameter[] { new SqlParameter("@ssn", ssn), new SqlParameter("@sid", sid) }, CommandType.Text);
Mydb.ExecuteNoNQuery("update SELECTED_SERVICE_SET_ICON set PROJECT_ID=@prj ,SSS_ICON=@iconid, RESPONSIBLE_ID=@lg where SSS_ID=@sid", new SqlParameter[] { new SqlParameter("@prj", prj), new SqlParameter("@iconid", siconid), new SqlParameter("@sid", sid), new SqlParameter("@lg", lg) }, CommandType.Text);
//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",sid) }, 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);
return("");
}
public static string SaveClienObject(int Client_Id, string Objectadr, string CODE, int uoId, string img_, int LogId, int project_id)
{
#region COMMENTS
//if (string.IsNullOrEmpty(CODE))
//{
// Mydb.ExecuteNoNQuery("insert into OBJECT (OBJECT_ADRESS,OBJECT_NAME,CLIENT_ID,MAN_COMP_ID,OBJECT_PHOTO) values(@adres,@name,@id,@uoId,@img)", new SqlParameter[] {
// new SqlParameter("@adres", Objectadr),
// new SqlParameter("@name", Objectadr),
// new SqlParameter("@id", Client_Id),
// new SqlParameter("@uoId",uoId),
// new SqlParameter("@img",img_)}, CommandType.Text);
// Mydb.ExecuteNoNQuery("insert into KLADR (KLADR_OBJECT_ADRESS) values(@adres)", new SqlParameter[] { new SqlParameter("@adres", Objectadr) }, CommandType.Text);
// string IdObject = Mydb.ExecuteScalar("select OBJECT_ID from OBJECT where OBJECT_ADRESS=@adr", new SqlParameter[] { new SqlParameter("@adr", Objectadr) }, CommandType.Text).ToString();
// return "{\"result\" : \"1\",\"idObject\" : \"" + IdObject + "\"}";
//}
//else
//{
// Mydb.ExecuteNoNQuery("insert into OBJECT (OBJECT_ADRESS,OBJECT_NAME,CLIENT_ID,MAN_COMP_ID,OBJECT_PHOTO) values(@adres,@name,@id,@uoId,@img)", new SqlParameter[] { new SqlParameter("@adres", Objectadr),
// new SqlParameter("@name", Objectadr),
// new SqlParameter("@id", Client_Id),
// new SqlParameter("@uoId",uoId),
// new SqlParameter("@img",img_)}, CommandType.Text);
// Mydb.ExecuteNoNQuery("insert into KLADR (KLADR_OBJECT_ID,KLADR_OBJECT_ADRESS) values(@code,@adres)", new SqlParameter[] { new SqlParameter("@code",CODE),new SqlParameter("@adres", Objectadr) }, CommandType.Text);
// string IdObject = Mydb.ExecuteScalar("select OBJECT_ID from OBJECT where OBJECT_ADRESS=@adr", new SqlParameter[] { new SqlParameter("@adr", Objectadr) }, CommandType.Text).ToString();
// return "{\"result\" : \"1\",\"idObject\" : \"" + IdObject + "\"}";
//}
#endregion
// CODE = (CODE == "") ? null : CODE;
Mydb.ExecuteNoNQuery("SaveClienObject", new SqlParameter[] {
new SqlParameter("@adres", Objectadr),
new SqlParameter("@name", Objectadr),
new SqlParameter("@id", Client_Id),
new SqlParameter("@uoId", uoId),
new SqlParameter("@img", img_),
new SqlParameter("@CODE", CODE),
new SqlParameter("@log", LogId),
new SqlParameter("@PROJECT_ID", project_id)
}, CommandType.StoredProcedure);
return("{\"result\" : \"1\"}");
}
public static string ConnectServicetoProject(int prj, string sets, string directs, string services)
{
dynamic jsonSets = JsonConvert.DeserializeObject(sets);
foreach (var set in jsonSets)
{
int COuntSet = (int)Mydb.ExecuteScalar("select COUNT (*) from SELECTED_SERVICE_SET_ICON where SSS_ID=@sid and PROJECT_ID=@proj", new SqlParameter[] { new SqlParameter("@sid", Convert.ToInt32(set.SetId)), new SqlParameter("@proj", prj) }, CommandType.Text);
if (COuntSet == 1)
{
Mydb.ExecuteNoNQuery("update SELECTED_SERVICE_SET_ICON set SSS_ICON=@IconId where SSS_ID=@sid and PROJECT_ID=@prj", new SqlParameter[] { new SqlParameter("@IconId", Convert.ToInt32(set.IconId)), new SqlParameter("@sid", Convert.ToInt32(set.SetId)), new SqlParameter("@prj", prj) }, CommandType.Text);
}
else
{
Mydb.ExecuteNoNQuery("insert into SELECTED_SERVICE_SET_ICON (SSS_ID,PROJECT_ID,SSS_ICON) values (@sid,@prj,@IconId)", new SqlParameter[] { new SqlParameter("@sid", Convert.ToInt32(set.SetId)), new SqlParameter("@prj", prj), new SqlParameter("@IconId", Convert.ToInt32(set.IconId)) }, CommandType.Text);
}
}
dynamic JsonDirect = JsonConvert.DeserializeObject(directs);
foreach (var direct in JsonDirect)
{
//int DirectId_ = direct.DirectId;
//int DiconId_ = direct.DiconId;
int COuntDirect = (int)Mydb.ExecuteScalar("select COUNT(*) from SDIRECT_SICON where S_DIRECT_ID=@dId and PROJECT_ID=@prj", new SqlParameter[] { new SqlParameter("@dId", Convert.ToInt32(direct.DirectId)), new SqlParameter("@prj", prj) }, CommandType.Text);
if (COuntDirect == 1)
{
Mydb.ExecuteNoNQuery("update SDIRECT_SICON set ICON_ID=@DiconId where S_DIRECT_ID=@dId and PROJECT_ID=@prj", new SqlParameter[] { new SqlParameter("@DiconId", Convert.ToInt32(direct.DiconId)), new SqlParameter("dId", Convert.ToInt32(direct.DirectId)), new SqlParameter("@prj", prj) }, CommandType.Text);
}
else
{
Mydb.ExecuteNoNQuery("insert into SDIRECT_SICON (S_DIRECT_ID,PROJECT_ID,ICON_ID) values(@dId,@prj,@DiconId)", new SqlParameter[] { new SqlParameter("@dId", Convert.ToInt32(direct.DirectId)), new SqlParameter("@prj", prj), new SqlParameter("@DiconId", Convert.ToInt32(direct.DiconId)) }, CommandType.Text);
}
}
dynamic jsonServices = JsonConvert.DeserializeObject(services);
foreach (var service in jsonServices)
{
//int serviceId_ = service.serviceId;
//string cost_ = service.cost;
Mydb.ExecuteNoNQuery("insert into PROJECT_PRODUCT_SERVICE (PRODUCT_SERVICE_ID,PROJECT_ID,COST) values (@servId,@prj,@cost)", new SqlParameter[] { new SqlParameter("@servId", Convert.ToInt32(service.serviceId)), new SqlParameter("@prj", prj), new SqlParameter("@cost", Convert.ToString(service.cost)) }, CommandType.Text);
}
return("");
}
public static string UpdateDisp(int DD, string icon, string NDisp, string PhDisp, List <ObjectS> objs, List <Account_> DispAcc, List <Account_> EngAcc, List <Account_> TexAcc)
{
int IconId = (int)Mydb.ExecuteScalar("select DISP_ICON_ID from DISP where DISP_ID=@d", new SqlParameter[] { new SqlParameter("@d", DD) }, CommandType.Text);
Mydb.ExecuteNoNQuery("Update DISP_ICON set DISP_ICON_IMG=@ic where DISP_ICON_ID=@id", new SqlParameter[] { new SqlParameter("@ic", icon), new SqlParameter("@id", IconId) }, CommandType.Text);
Mydb.ExecuteNoNQuery("Update DISP set DISP_NAME=@Dn ,DISP_PHONE_NUMBER=@dph where DISP_ID=@d", new SqlParameter[] { new SqlParameter("@Dn", NDisp), new SqlParameter("@dph", PhDisp), new SqlParameter("@d", DD) }, CommandType.Text);
Mydb.ExecuteNoNQuery("delete from DISP_OBJECT where DISP_ID=@dd", new SqlParameter[] { new SqlParameter("@dd", DD) }, CommandType.Text);
foreach (ObjectS item in objs)
{
Mydb.ExecuteNoNQuery("insert into DISP_OBJECT (OBJECT_ID,DISP_ID) values(@oId,@Did)", new SqlParameter[] { new SqlParameter("@oId", item.Object_Id), new SqlParameter("@Did", DD) }, CommandType.Text);
}
Mydb.ExecuteNoNQuery("delete from DISP_ACC where DISP_ID=@dd", new SqlParameter[] { new SqlParameter("@dd", DD) }, CommandType.Text);
foreach (Account_ item in DispAcc)
{
//Mydb.ExecuteNoNQuery("Update ACCOUNT_ROLE set DISP_ID=@dsp where LOG_IN_ID=@lg", new SqlParameter[] {new SqlParameter("@dsp",DispId),new SqlParameter("@lg",item.LOG_IN_ID) }, CommandType.Text);
Mydb.ExecuteNoNQuery("insert into DISP_ACC (LOG_IN_ID,DISP_ID,ROLE_ID) values(@lg,@d,3)", new SqlParameter[] {
new SqlParameter("@lg", item.LOG_IN_ID),
new SqlParameter("@d", DD)
}, CommandType.Text);
}
foreach (Account_ item in EngAcc)
{
//Mydb.ExecuteNoNQuery("Update ACCOUNT_ROLE set DISP_ID=@dsp where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@dsp", DispId), new SqlParameter("@lg", item.LOG_IN_ID) }, CommandType.Text);
Mydb.ExecuteNoNQuery("insert into DISP_ACC (LOG_IN_ID,DISP_ID,ROLE_ID) values(@lg,@d,2)", new SqlParameter[] {
new SqlParameter("@lg", item.LOG_IN_ID),
new SqlParameter("@d", DD)
}, CommandType.Text);
}
foreach (Account_ item in TexAcc)
{
//Mydb.ExecuteNoNQuery("Update ACCOUNT_ROLE set DISP_ID=@dsp where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@dsp", DispId), new SqlParameter("@lg", item.LOG_IN_ID) }, CommandType.Text);
Mydb.ExecuteNoNQuery("insert into DISP_ACC (LOG_IN_ID,DISP_ID,ROLE_ID) values(@lg,@d,6)", new SqlParameter[] {
new SqlParameter("@lg", item.LOG_IN_ID),
new SqlParameter("@d", DD)
}, CommandType.Text);
}
#region
#endregion
return("");
}
public static string DeleteCounter(int mid)
{
//Mydb.ExecuteNoNQuery("update METERS set ARXIV='1' where METERS_ID=@mid", new SqlParameter[] { new SqlParameter("@mid",mid) }, CommandType.Text);
int Mtype = (int)Mydb.ExecuteScalar("select TYPE_ID from VW_METERS where METERS_ID=@mid", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.Text);
Mydb.ExecuteNoNQuery("update METERS set ARXIV='1' where METERS_ID=@mid", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.Text);
string historyText = "Счетчик перенесен в архив";
Mydb.ExecuteNoNQuery("insert into METERS_HISTORY(DATETIME,EVENT,AUTHOR,FILE_,METERS_ID) values( CONVERT(date, getdate()),@historyText,(select ACCOUNT_NAME from ACCOUNT where LOG_IN_ID = (select LOG_IN_ID from VW_METERS where METERS_ID=@mid)),'-',@METERS_ID)", new SqlParameter[] { new SqlParameter("@historyText", historyText), new SqlParameter("@mid", mid), new SqlParameter("@METERS_ID", mid) }, CommandType.Text);
//if (Mtype==4)
//{
//int value1 = (int)Mydb.ExecuteScalar("select top(1) VALUE_ from METER_VALUE where METERS_ID=@mid order by DATE_ desc", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.Text);
//int value2 = (int)Mydb.ExecuteScalar("select top(1) VALUE_2 from METER_VALUE where METERS_ID=@mid order by DATE_ desc", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.Text);
//int value3= (int)Mydb.ExecuteScalar("select top(1) VALUE_3 from METER_VALUE where METERS_ID=@mid order by DATE_ desc", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.Text);
//int valueCount = (int)Mydb.ExecuteScalar("select COUNT (*) from METER_VALUE where METERS_ID=@mid", new SqlParameter[] { new SqlParameter("@mid",mid) }, CommandType.Text);
// if (valueCount<=1)
// {
// Mydb.ExecuteNoNQuery("delete from METERS where METERS_ID=@mid", new SqlParameter[] { new SqlParameter("@mid",mid) }, CommandType.Text);
// Mydb.ExecuteNoNQuery("delete from METERS_HISTORY where METERS_ID=@mid", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.Text);
// Mydb.ExecuteNoNQuery("delete from METER_VALUE where METERS_ID=@mid", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.Text);
// }
// else
// {
//}
// }
//else
//{
// int valueCount = (int)Mydb.ExecuteScalar("select COUNT (*) from METER_VALUE where METERS_ID=@mid", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.Text);
// if (valueCount <= 1)
// {
// Mydb.ExecuteNoNQuery("delete from METERS where METERS_ID=@mid", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.Text);
// Mydb.ExecuteNoNQuery("delete from METERS_HISTORY where METERS_ID=@mid", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.Text);
// Mydb.ExecuteNoNQuery("delete from METER_VALUE where METERS_ID=@mid", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.Text);
// }
// else
// {
// Mydb.ExecuteNoNQuery("update METERS set ARXIV=1 where METERS_ID=@mid", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.Text);
// }
//}
return("");
}
public static string CRDisp(string Dsts, string icon, string NDisp, string PhDisp, int C, List <ObjectS> objs, List <Account_> DispAcc, List <Account_> EngAcc, List <Account_> TexAcc)
{
Mydb.ExecuteNoNQuery("insert into DISP_ICON (DISP_ICON_IMG) values(@ic)", new SqlParameter[] { new SqlParameter("@ic", icon) }, CommandType.Text);
int DispicId = (int)Mydb.ExecuteScalar("select top 1 DISP_ICON_ID from DISP_ICON order by DISP_ICON_ID desc", new SqlParameter[] { }, CommandType.Text);
Mydb.ExecuteNoNQuery("insert into DISP (DISP_STATUS,DISP_NAME,DISP_PHONE_NUMBER,CLIENT_ID,DISP_ICON_ID) values(@dsts,@Dn,@Dph,@c,@ic)", new SqlParameter[] { new SqlParameter("@dsts", Dsts), new SqlParameter("@Dn", NDisp),
new SqlParameter("@Dph", PhDisp),
new SqlParameter("@c", C),
new SqlParameter("@ic", DispicId) }, CommandType.Text);
int DispId = (int)Mydb.ExecuteScalar("select top 1 DISP_ID from DISP order by DISP_ID desc", new SqlParameter[] { }, CommandType.Text);
foreach (ObjectS item in objs)
{
Mydb.ExecuteNoNQuery("insert into DISP_OBJECT (OBJECT_ID,DISP_ID) values(@oId,@Did)", new SqlParameter[] { new SqlParameter("@oId", item.Object_Id), new SqlParameter("@Did", DispId) }, CommandType.Text);
}
foreach (Account_ item in DispAcc)
{
//Mydb.ExecuteNoNQuery("Update ACCOUNT_ROLE set DISP_ID=@dsp where LOG_IN_ID=@lg", new SqlParameter[] {new SqlParameter("@dsp",DispId),new SqlParameter("@lg",item.LOG_IN_ID) }, CommandType.Text);
Mydb.ExecuteNoNQuery("insert into DISP_ACC (LOG_IN_ID,DISP_ID,ROLE_ID) values(@lg,@d,3)", new SqlParameter[] {
new SqlParameter("@lg", item.LOG_IN_ID),
new SqlParameter("@d", DispId)
}, CommandType.Text);
}
foreach (Account_ item in EngAcc)
{
//Mydb.ExecuteNoNQuery("Update ACCOUNT_ROLE set DISP_ID=@dsp where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@dsp", DispId), new SqlParameter("@lg", item.LOG_IN_ID) }, CommandType.Text);
Mydb.ExecuteNoNQuery("insert into DISP_ACC (LOG_IN_ID,DISP_ID,ROLE_ID) values(@lg,@d,2)", new SqlParameter[] {
new SqlParameter("@lg", item.LOG_IN_ID),
new SqlParameter("@d", DispId)
}, CommandType.Text);
}
foreach (Account_ item in TexAcc)
{
//Mydb.ExecuteNoNQuery("Update ACCOUNT_ROLE set DISP_ID=@dsp where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@dsp", DispId), new SqlParameter("@lg", item.LOG_IN_ID) }, CommandType.Text);
Mydb.ExecuteNoNQuery("insert into DISP_ACC (LOG_IN_ID,DISP_ID,ROLE_ID) values(@lg,@d,6)", new SqlParameter[] {
new SqlParameter("@lg", item.LOG_IN_ID),
new SqlParameter("@d", DispId)
}, CommandType.Text);
}
Mydb.ExecuteNoNQuery("Update DISP_PHONES set BUSY=1 where PHONE=@ph", new SqlParameter[] { new SqlParameter("@ph", PhDisp) }, CommandType.Text);
return("");
}
public static string otpravToVrabot(int Rid, List <ProductService_> prs, string opl, string login_id, int sid, string em, int level, int dId, string costDirect, string CostSet, string Ptime, string Pdate)
{
Mydb.ExecuteNoNQuery("Update REQUEST_SUPPLIERS set STATUS_ID=1,SERVICE_GROUP_ID=@gs,PAYMENT=@PAYMENT, EMERGENCY_TREATMENT=@em, PLAN_END_DATE=CAST(@Pdate as date), PLAN_END_TIME=CAST(REPLACE(@Ptime,'-',':')as time(0)) where REQUEST_ID=@rid", new SqlParameter[] { new SqlParameter("@rid", Rid), new SqlParameter("@gs", sid), new SqlParameter("@PAYMENT", opl), new SqlParameter("@em", em), new SqlParameter("@Pdate", Pdate), new SqlParameter("@Ptime", Ptime) }, CommandType.Text);
Mydb.ExecuteNoNQuery("delete from REQUEST_SERVICE_SUPPLIERS where REQUEST_ID=@REQUEST_ID", new SqlParameter[] { new SqlParameter("@REQUEST_ID", Rid) }, CommandType.Text);
if (level == 3)
{
foreach (ProductService_ item in prs)
{
Mydb.ExecuteNoNQuery("insert into REQUEST_SERVICE_SUPPLIERS (REQUEST_ID,P_SERVICE_ID,QUANTITY,COST,[LEVEL]) values (@Rid,@PId,@Q,@C,@l)", new SqlParameter[] {
new SqlParameter("@Rid", Rid),
new SqlParameter("@PId", item.SERVICE_ID),
new SqlParameter("@Q", item.QUANTITY),
new SqlParameter("@C", item.COST),
new SqlParameter("@l", level)
}, CommandType.Text);
}
}
if (level == 2)
{
Mydb.ExecuteNoNQuery("insert into REQUEST_SERVICE_SUPPLIERS (REQUEST_ID,P_SERVICE_ID,QUANTITY,COST,[LEVEL]) values (@Rid,@PId,@Q,@C,@l)", new SqlParameter[] {
new SqlParameter("@Rid", Rid),
new SqlParameter("@PId", dId),
new SqlParameter("@Q", "1"),
new SqlParameter("@C", costDirect),
new SqlParameter("@l", level)
}, CommandType.Text);
}
if (level == 1)
{
Mydb.ExecuteNoNQuery("insert into REQUEST_SERVICE_SUPPLIERS (REQUEST_ID,P_SERVICE_ID,QUANTITY,COST,[LEVEL]) values (@Rid,@PId,@Q,@C,@l)", new SqlParameter[] {
new SqlParameter("@Rid", Rid),
new SqlParameter("@PId", sid),
new SqlParameter("@Q", "1"),
new SqlParameter("@C", CostSet),
new SqlParameter("@l", level)
}, 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", 1), new SqlParameter("@COMMENT", ""), new SqlParameter("@WHO", login_id) }, CommandType.StoredProcedure);
return("");
}
public static string SaveAcc(List <MR> SMSR, string accName_, string PNumb_, string Email_, string Pass_, string ClId_, string Login_)
{
string NonEncryptedPass = Pass_;
Pass_ = GetMd5HashData(Pass_);
Mydb.ExecuteNoNQuery("insert into ACCOUNT (ACCOUNT_NAME,PHONE_NUMBER,E_MAIL,PASSWORD,CLIENT_ID,LOGIN) values(@accName,@PNumb,@Email,@Pass,@ClId,@Login)", new SqlParameter[]
{
new SqlParameter("@accName", accName_),
new SqlParameter("@PNumb", PNumb_),
new SqlParameter("@Email", Email_),
new SqlParameter("@Pass", Pass_),
new SqlParameter("@ClId", ClId_),
new SqlParameter("@Login", Login_)
}, CommandType.Text);
int LogId = (int)Mydb.ExecuteScalar("select LOG_IN_ID from ACCOUNT where LOGIN=@Login", new SqlParameter[] { new SqlParameter("@Login", Login_) }, 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 mr_Id = (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", LogId), new SqlParameter("@mr", mr_Id) }, CommandType.Text);
SendMail(Email_, NonEncryptedPass, Email_);
}
//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", LogId), new SqlParameter("@mr", mr_Id )}, CommandType.Text);
//}
return("{\"result\" : \"1\"}");
}
public static string MakePoverka(int mid, string last, string next, string HistImg, int ObjId, string dRemoval, string dInstal, string removal)
{
string Susbend = Mydb.ExecuteScalar("select SUSBEND from METERS where METERS_ID=@mid", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.Text).ToString();
string historyText = "";
if (Susbend == "True")
{
historyText = "Счетчик возобновил работу";
}
else
{
historyText = "'Была произведена поверка счетчика " + removal + ". Дата снятия: " + dRemoval + ", Дата установки: " + dInstal + " '";
}
Mydb.ExecuteNoNQuery("update METERS set PREVIOUS_DATE=Cast(@lst as date),NEXT_DATE=cast(@nxt as date),SUSBEND='0' where METERS_ID=@mid", new SqlParameter[] { new SqlParameter("@lst", last), new SqlParameter("@nxt", next), new SqlParameter("@mid", mid) }, CommandType.Text);
Mydb.ExecuteNoNQuery("insert into METERS_HISTORY(DATETIME,EVENT,AUTHOR,FILE_,METERS_ID) values( CONVERT(date, getdate()),@historyText,(select ACCOUNT_NAME from ACCOUNT where LOG_IN_ID = (select LOG_IN_ID from OBJECT where OBJECT_ID =@objId)),@file,@METERS_ID)", new SqlParameter[] { new SqlParameter("@historyText", historyText), new SqlParameter("@objId", ObjId), new SqlParameter("@file", HistImg), new SqlParameter("@METERS_ID", mid) }, CommandType.Text);
return("");
}
public static string UpdateSupplier(
string guid
, string INN,
string KPP,
// string OKPO ,
string OKVED,
string OGRN_OGRNIP,
string REGIST_ORGAN,
string REGIST_DATE,
string FULL_NAME,
string NAME,
string INFO_FOUNDERS,
string BIRTH_DATE,
string BIRTH_PLACE,
string TYPE_DOCUMENT,
string SERIES_DOCUMENT,
string NUMBERS_DOCUMENT,
string DATE_ISSUE,
string CONTACT_PHONE,
string DIVISION_CODE,
int CLIENT_ID,
string CHECKING_ACCOUNT,
string CORRESP_ACCOUNT,
string BANK_NAME,
string BIK,
string FIO,
string PAYMENT,
// string LICENCE ,
string LEGAL_ADRESS,
string ADRESS,
string PHONE_FAKS,
string EMAIL,
string VK,
string OK,
string FB,
string TW,
string SHOP_ID,
string ICON,
// bool VISIBLE ,
string FEE,
// bool ACCEPTING ,
string PASSWORD
)
{
string result = "";
try
{
Mydb.ExecuteNoNQuery("UpdateSupplier", new SqlParameter[] {
new SqlParameter("@guid", guid),
new SqlParameter("@INN", INN),
new SqlParameter("@KPP", KPP),
// new SqlParameter("@OKPO",OKPO),
new SqlParameter("@OKVED", OKVED),
new SqlParameter("@OGRN_OGRNIP", OGRN_OGRNIP),
new SqlParameter("@REGIST_ORGAN", REGIST_ORGAN),
new SqlParameter("@REGIST_DATE", REGIST_DATE),
new SqlParameter("@FULL_NAME", FULL_NAME),
new SqlParameter("@NAME", NAME),
new SqlParameter("@INFO_FOUNDERS", INFO_FOUNDERS),
new SqlParameter("@BIRTH_DATE", BIRTH_DATE),
new SqlParameter("@BIRTH_PLACE", BIRTH_PLACE),
new SqlParameter("@TYPE_DOCUMENT", TYPE_DOCUMENT),
new SqlParameter("@SERIES_DOCUMENT", SERIES_DOCUMENT),
new SqlParameter("@NUMBERS_DOCUMENT", NUMBERS_DOCUMENT),
new SqlParameter("@DATE_ISSUE", DATE_ISSUE),
new SqlParameter("@CONTACT_PHONE", CONTACT_PHONE),
new SqlParameter("@DIVISION_CODE", DIVISION_CODE),
new SqlParameter("@CLIENT_ID", CLIENT_ID),
new SqlParameter("@CHECKING_ACCOUNT", CHECKING_ACCOUNT),
new SqlParameter("@CORRESP_ACCOUNT", CORRESP_ACCOUNT),
new SqlParameter("@BANK_NAME", BANK_NAME),
new SqlParameter("@BIK", BIK),
new SqlParameter("@FIO", FIO),
new SqlParameter("@PAYMENT", PAYMENT),
//new SqlParameter("@LICENCE",LICENCE),
new SqlParameter("@LEGAL_ADRESS", LEGAL_ADRESS),
new SqlParameter("@ADRESS", ADRESS),
new SqlParameter("@PHONE_FAKS", PHONE_FAKS),
new SqlParameter("@EMAIL", EMAIL),
new SqlParameter("@VK", VK),
new SqlParameter("@OK", OK),
new SqlParameter("@FB", FB),
new SqlParameter("@TW", TW),
new SqlParameter("@SHOP_ID", SHOP_ID),
new SqlParameter("@ICON", ICON),
// new SqlParameter("@VISIBLE",VISIBLE),
new SqlParameter("@FEE", FEE),
//new SqlParameter("@ACCEPTING",ACCEPTING),
new SqlParameter("@PASSWORD", PASSWORD)
}, CommandType.StoredProcedure);
result = "{\"result\" : \"ok\"}";
}
catch (Exception ex)
{
result = "{\"result\" : \"" + ex.ToString() + "\"}";
}
return(result);
}
public static string Save_Changes(string PASSWORD, string ACCOUNT_NAME, string PHONE_NUMBER, string E_MAIL, string COMPANY_NAME, string INN, string KPP, string OGRN_OGRNIP, int ENTITY_TYPE_ID, string OKPO, string HOUSE, string BNAME, string INNB, string KPPB, string BIK, string BKRS, string RS, int CL, string FIO)
{
if (PASSWORD.Length != 0)
{
PASSWORD = GetMd5HashData(PASSWORD);
Mydb.ExecuteNoNQuery("Update ACCOUNT set E_MAIL=@e,PHONE_NUMBER=@p,PASSWORD=@pas,ACCOUNT_NAME=@acc where CLIENT_ID=@C and Login is null", new SqlParameter[]
{ new SqlParameter("@e", E_MAIL),
new SqlParameter("@p", PHONE_NUMBER),
new SqlParameter("@acc", ACCOUNT_NAME),
new SqlParameter("@C", CL),
new SqlParameter("@pas", PASSWORD) }, CommandType.Text);
}
else
{
PASSWORD = GetMd5HashData(PASSWORD);
Mydb.ExecuteNoNQuery("Update ACCOUNT set E_MAIL=@e,PHONE_NUMBER=@p,ACCOUNT_NAME=@acc where CLIENT_ID=@C and Login is null", new SqlParameter[]
{ new SqlParameter("@e", E_MAIL),
new SqlParameter("@p", PHONE_NUMBER),
new SqlParameter("@acc", ACCOUNT_NAME),
new SqlParameter("@C", CL), }, CommandType.Text);
}
//Mydb.ExecuteNoNQuery("update ENTITY_ADRESS set HOUSE where ADRESS_ID=@adr", new SqlParameter[] { new SqlParameter("@adr", ADRESS_ID) }, CommandType.Text);
/*INSERT INTO table_name (column1, column2, column3, ...)
* VALUES (value1, value2, value3, ...);*/
int CountEntAdres = (int)Mydb.ExecuteScalar("select COUNT(*) from CLIENT c, ENTITY_ADRESS ea where c.ADRESS_ID=ea.ADRESS_ID and c.CLIENT_ID=@c", new SqlParameter[] { new SqlParameter("@c", CL) }, CommandType.Text);
if (CountEntAdres == 0)
{
Mydb.ExecuteNoNQuery("insert into ENTITY_ADRESS (HOUSE) values(@adr)", new SqlParameter[] { new SqlParameter("@adr", HOUSE) }, CommandType.Text);
}
else
{
int AdressId = (int)Mydb.ExecuteScalar("select ea.ADRESS_ID from CLIENT c, ENTITY_ADRESS ea where c.ADRESS_ID=ea.ADRESS_ID and c.CLIENT_ID=@c", new SqlParameter[] { new SqlParameter("@c", CL) }, CommandType.Text);
Mydb.ExecuteNoNQuery("update ENTITY_ADRESS set HOUSE=@h where ADRESS_ID=@AId", new SqlParameter[] { new SqlParameter("@h", HOUSE), new SqlParameter("@AId", AdressId) }, CommandType.Text);
}
int AdresId = (int)Mydb.ExecuteScalar("select ADRESS_ID from ENTITY_ADRESS where HOUSE=@h", new SqlParameter[] { new SqlParameter("@h", HOUSE) }, CommandType.Text);
Mydb.ExecuteNoNQuery("update CLIENT set COMPANY_NAME=@cn,ENTITY_TYPE_ID=@enId,INN=@inn,OGRN_OGRNIP=@ogrn, OKPO=@okpo,KPP=@kpp, BNAME=@bname,INNB=@innb,KPPB=@kppb,BIK=@bik,BKRS=@bkrs,RS=@rs, ADRESS_ID=@A_Id where CLIENT_ID=@cl", new SqlParameter[] {
new SqlParameter("@cn", COMPANY_NAME),
new SqlParameter("@enId", ENTITY_TYPE_ID),
new SqlParameter("@inn", INN),
new SqlParameter("@ogrn", OGRN_OGRNIP),
new SqlParameter("@okpo", OKPO),
new SqlParameter("@kpp", KPP),
new SqlParameter("@bname", BNAME),
new SqlParameter("@innb", INNB),
new SqlParameter("@kppb", KPPB),
new SqlParameter("@bik", BIK),
new SqlParameter("@bkrs", BKRS),
new SqlParameter("@rs", RS),
new SqlParameter("@cl", CL),
new SqlParameter("@A_Id", AdresId)
}, CommandType.Text);
Mydb.ExecuteNoNQuery("update ACCOUNT set ACCOUNT_NAME=@f where CLIENT_ID=@C and LOGIN is null", new SqlParameter[] { new SqlParameter("@C", CL), new SqlParameter("@f", FIO) }, CommandType.Text);
return("{\"result\" : \"1\"}");
}
public static string SaveRequest(int slcObj, int IndId_, int Lg, string em, string Pdate, string Ptime, int spId, string Rt, List <ProductService_> prs, string Rc, List <REQUEST_COMMENT> Cf, string NUMBER, string opl, string phn, int HReq, int dId, int sid) //int Tc,
{
Rt = HttpUtility.UrlDecode(Rt);
Rt.Replace("\\", "");
Rc = HttpUtility.UrlDecode(Rc);
Rc = Rc.Replace(@"\", string.Empty);
int CrRequest;
if (IndId_ == 0)
{
//string files = "";
//if (Cf.Count != 0)
//{
// string domainName = HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority);
// files = domainName;
// for (int i = 0; i < Cf.Count; i++)
// {
// if (i == Cf.Count - 1)
// {
// files += Cf[i].COMMENT_FILE;
// }
// else
// {
// files += Cf[i].COMMENT_FILE + ",";
// }
// }
//}
// object MobileNumber = Mydb.ExecuteScalar("TestDB.dbo.sp_QUICK_API_new_request_add_autopilot2mobile", new SqlParameter[] {
// new SqlParameter("@object_id",slcObj),
// new SqlParameter("@number",NUMBER),
// new SqlParameter("@phone_number",phn),
// new SqlParameter("@request_text",Rt),
// new SqlParameter("@work_kind","490F9FEA-DB91-A9A4-4325-80F9006E94CC"),
// new SqlParameter("@files",files),
// new SqlParameter("@workdate",Pdate),
// new SqlParameter("@workbegin",Ptime),
// new SqlParameter("@workend",Ptime),
// new SqlParameter("@destination","")
//}, CommandType.StoredProcedure);
//int mn = Convert.ToInt32(MobileNumber);
int mn = 0;// Convert.ToInt32(MobileNumber);
Mydb.ExecuteNoNQuery("insert into REQUEST_SUPPLIERS (EMERGENCY_TREATMENT,PLAN_END_DATE,PLAN_END_TIME,SPECIALIS_ID,LOG_IN_ID,REQUEST_TEXT,CR_DATE,STATUS_ID,NUMBER,PAYMENT,SERVICE_GROUP_ID,MOBILE_NUMBER)values(@em,CAST(@Pdate as date),CAST(@Ptime as time(0) ),@spId,@lg,@Rt,GETDATE ( ),1,@NUMBER,@opl,@gs,@MOBILE_NUMBER)", new SqlParameter[] {
new SqlParameter("@em", Convert.ToBoolean(em)),
// new SqlParameter("@Adr",Adr),
// new SqlParameter("@indId",LastIndId),
// new SqlParameter("@DId",0),
new SqlParameter("@Pdate", Pdate),
new SqlParameter("@Ptime", Ptime),
new SqlParameter("@spId", spId),
new SqlParameter("@lg", Lg),
new SqlParameter("@Rt", Rt),
// new SqlParameter("@Tc",Tc),
// new SqlParameter("@CId",ClientId),
// new SqlParameter("@roomT",RoomT),
new SqlParameter("@NUMBER", NUMBER),
new SqlParameter("@opl", Convert.ToBoolean(opl)),
new SqlParameter("@gs", sid),
new SqlParameter("@MOBILE_NUMBER", mn)
}, CommandType.Text);
int LastReqId = (int)Mydb.ExecuteScalar("select top 1 REQUEST_ID from REQUEST_SUPPLIERS order by REQUEST_ID desc", new SqlParameter[] { }, CommandType.Text);
CrRequest = LastReqId;
foreach (ProductService_ item in prs)
{
Mydb.ExecuteNoNQuery("insert into REQUEST_SERVICE_SUPPLIERS (REQUEST_ID,P_SERVICE_ID,QUANTITY,COST,[LEVEL]) values (@Rid,@PId,@Q,@C,3)", new SqlParameter[] {
new SqlParameter("@Rid", LastReqId),
new SqlParameter("@PId", item.SERVICE_ID),
new SqlParameter("@Q", item.QUANTITY),
new SqlParameter("@C", item.COST),
},
CommandType.Text);
}
Mydb.ExecuteNoNQuery("insert into REQUEST_COMMENT_SUPPLIERS (REQUEST_COMMENT,REQUEST_ID) values(@RC,@Rid)", new SqlParameter[] { new SqlParameter("@Rc", Rc), new SqlParameter("@Rid", LastReqId)
//,new SqlParameter("@Cf",Cf)
}, CommandType.Text);
foreach (REQUEST_COMMENT item in Cf)
{
if (item.COMMENT_FILE != "0")
{
Mydb.ExecuteNoNQuery("insert into REQUEST_COMMENT_SUPPLIERS (COMMENT_FILE,REQUEST_ID) values (@Cf,@Rid)", new SqlParameter[] { new SqlParameter("@Cf", item.COMMENT_FILE), new SqlParameter("@Rid", LastReqId) }, CommandType.Text);
}
}
return("{\"RequestId\" : \"" + CrRequest.ToString() + "\"}");;
}
else
{
//string files = "";
//string domainName = HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority);
//if (Cf.Count != 0)
//{
// files = domainName;
// for (int i = 0; i < Cf.Count; i++)
// {
// if (i == Cf.Count - 1)
// {
// files += Cf[i].COMMENT_FILE;
// Cf[i].COMMENT_FILE = domainName + Cf[i].COMMENT_FILE;
// }
// else
// {
// files += Cf[i].COMMENT_FILE + ",";
// Cf[i].COMMENT_FILE = domainName + Cf[i].COMMENT_FILE;
// }
// }
//}
// object MobileNumber = Mydb.ExecuteScalar("TestDB.dbo.sp_QUICK_API_new_request_add_autopilot2mobile", new SqlParameter[] {
// new SqlParameter("@object_id",slcObj),
// new SqlParameter("@number",NUMBER),
// new SqlParameter("@phone_number",phn),
// new SqlParameter("@request_text",Rt),
// new SqlParameter("@work_kind","490F9FEA-DB91-A9A4-4325-80F9006E94CC"),
// new SqlParameter("@files",files),
// new SqlParameter("@workdate",Pdate),
// new SqlParameter("@workbegin",Ptime),
// new SqlParameter("@workend",Ptime),
// new SqlParameter("@destination","")
//}, CommandType.StoredProcedure);
int mn = 0;//Convert.ToInt32(MobileNumber);
Mydb.ExecuteNoNQuery("insert into REQUEST_SUPPLIERS (EMERGENCY_TREATMENT,INDIVIDUAL_ID,PLAN_END_DATE,PLAN_END_TIME,SPECIALIS_ID,LOG_IN_ID,REQUEST_TEXT,CR_DATE,STATUS_ID,NUMBER,PAYMENT,PHONE_NUMBER,SERVICE_GROUP_ID,MOBILE_NUMBER)values(@em,@indId,CAST(@Pdate as date),CAST(@Ptime as time(0) ),@spId,@lg,@Rt,GETDATE ( ),1,@NUMBER,@opl,@phn,@gs,@MOBILE_NUMBER )", new SqlParameter[] {
new SqlParameter("@em", Convert.ToBoolean(em)),
// new SqlParameter("@Adr",Adr),
new SqlParameter("@indId", IndId_),
//new SqlParameter("@DId",0),
new SqlParameter("@Pdate", Pdate),
new SqlParameter("@Ptime", Ptime),
new SqlParameter("@spId", spId),
new SqlParameter("@lg", Lg),
new SqlParameter("@Rt", Rt),
//new SqlParameter("@roomT",RoomT),
new SqlParameter("@NUMBER", NUMBER),
new SqlParameter("@opl", Convert.ToBoolean(opl)),
new SqlParameter("@phn", phn),
new SqlParameter("@gs", sid),
// new SqlParameter("@CId",ClientId),
new SqlParameter("@MOBILE_NUMBER", mn),
}, CommandType.Text);
int LastReqId = (int)Mydb.ExecuteScalar("select top 1 REQUEST_ID from REQUEST_SUPPLIERS order by REQUEST_ID desc", new SqlParameter[] { }, CommandType.Text);
CrRequest = LastReqId;
foreach (ProductService_ item in prs)
{
Mydb.ExecuteNoNQuery("insert into REQUEST_SERVICE_SUPPLIERS (REQUEST_ID,P_SERVICE_ID,QUANTITY,COST,[LEVEL]) values (@Rid,@PId,@Q,@C,3)", new SqlParameter[] {
new SqlParameter("@Rid", LastReqId),
new SqlParameter("@PId", item.SERVICE_ID),
new SqlParameter("@Q", item.QUANTITY),
new SqlParameter("@C", item.COST)
}, CommandType.Text);
}
if (Rc.Trim().Length != 0)
{
Mydb.ExecuteNoNQuery("insert into REQUEST_COMMENT_SUPPLIERS (REQUEST_COMMENT,REQUEST_ID) values(@RC,@Rid)", new SqlParameter[] {
new SqlParameter("@Rc", Rc),
new SqlParameter("@Rid", LastReqId)
//, new SqlParameter("@Cf",Cf)
}, CommandType.Text);
}
foreach (REQUEST_COMMENT item in Cf)
{
if (item.COMMENT_FILE != "0")
{
Mydb.ExecuteNoNQuery("insert into REQUEST_COMMENT_SUPPLIERS (COMMENT_FILE,REQUEST_ID) values (@Cf,@Rid)", new SqlParameter[] { new SqlParameter("@Cf", item.COMMENT_FILE), new SqlParameter("@Rid", LastReqId) }, CommandType.Text);
}
}
}
return("{\"RequestId\" : \"" + CrRequest.ToString() + "\"}");
}
public static string sntComment(int rq, string cmnt)
{
Mydb.ExecuteNoNQuery("insert into REQUEST_COMMENT_SUPPLIERS (REQUEST_ID,REQUEST_COMMENT) values (@rq,@rc)", new SqlParameter[] { new SqlParameter("@rq", rq), new SqlParameter("@rc", cmnt) }, CommandType.Text);
return("");
}
