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