protected void Page_Load(object sender, EventArgs e) { string url = HttpContext.Current.Request.Url.AbsoluteUri; string decodedUrl = HttpUtility.UrlDecode(url); var uri = new Uri(url); var query = HttpUtility.ParseQueryString(uri.Query); string obj = query.Get("obj"); string lg = query.Get("lg"); string roomId = query.Get("roomId"); string types_param = query.Get("types"); byte[] bytes = Convert.FromBase64String(types_param); var types = Encoding.ASCII.GetString(bytes); dynamic RoomTypes = JsonConvert.DeserializeObject(types); foreach (var item in RoomTypes) { dynamic QRS_AND_Adress = JsonConvert.DeserializeObject(Mydb.ExecuteAsJson("Get_QRS_AND_Adress", new SqlParameter[] { new SqlParameter("@lg", Convert.ToInt32(lg)), new SqlParameter("@types", Convert.ToInt32(item.ROOM_TYPE)), new SqlParameter("@obj", Convert.ToInt32(obj)), new SqlParameter("@roomId", Convert.ToInt32(roomId)) }, CommandType.StoredProcedure)); foreach (var item2 in QRS_AND_Adress) { string Guid = item2.ROOM_GUID; //HttpContext.Current.Request.Url.Scheme + "://" + HttpContext.Current.Request.Url.Host + string path = @"C:\inetpub\wwwroot\__QR\" + Guid.Trim() + ".jpg"; if (!File.Exists(path)) { GenerateQrCode(Guid); } string QR_CODE = item2.QR_CODES; string Adress = item2.OBJECT_ADRESS; Response.Write("<div class=\"tabService\"><img src=\"" + QR_CODE + "\" class=\"qr\"><div class=\"headerServ\">" + Adress + "</div></div>"); } } }
public static string LoginIdentity(string Id_, string isTenant, string role) { string returnvalue = null; try { if (isTenant == "false") { /* * Mydb.ExecuteScalar("LoginIdendity", new SqlParameter[] { new SqlParameter("@procType", "2"), new SqlParameter("@lg", Id) }, CommandType.StoredProcedure);*/ if (role != "УК") { returnvalue = UK_Login(Id_); } else { int CountOfMailAsClient = Convert.ToInt32(Mydb.ExecuteScalar("LoginIdendity", new SqlParameter[] { new SqlParameter("@procType", "6"), new SqlParameter("@mail", Id_) }, CommandType.StoredProcedure)); if (CountOfMailAsClient == 0) { Mydb.ExecuteNoNQuery("InsertNewClient_T", new SqlParameter[] { new SqlParameter("@mail", Id_) }, CommandType.StoredProcedure); returnvalue = UK_Login(Id_); } else { returnvalue = UK_Login(Id_); } } } else if (isTenant == "true") { //Mydb.ExecuteAsJson("LoginSecond", new SqlParameter[] { new SqlParameter("@sc", Id_), new SqlParameter("@pass", pass) }, CommandType.StoredProcedure) returnvalue = Mydb.ExecuteAsJson("TestDB.dbo.sp_QUICK_API_get_accounts_by_device1", new SqlParameter[] { new SqlParameter("@device_id", Id_) }, CommandType.StoredProcedure); } } catch (Exception ex) { returnvalue = "{\"result\" : \"ErrorIdendity\"}"; } /* * return Redirect(AppConstants.AuthServer() + "/connect/endsession?id_token_hint=" + idToken + "&post_logout_redirect_uri=" + AppConstants.ClientServer() + "/signout-callback-oidc"); */ //HttpContext.Current.Response.Redirect("https://upravbot.ru/IDS4/Account/Logout?logoutId=CfDJ8JQq6V4gQ1xPva8MeQadqxUh3pMtraOr8jUvW3qBRzq9wjZC_7fNFZKIYrQJb94_dXsQJdLY64yybb8ZktHoTlmfzsLBfLLKRHIAuq7no_fY4fV35KwYxS6yGoQ10iGckHDmBjHS6pJcM8SwTA141e9htZFEwmiA1BQ9klespO6JcD4xZLTWbHbKm9N0juHicGdGySaC0TS5WQBsdJ3CxhDQeAt9lmcNZLTlv-2zOS8aX1bnW3p_UkLyOOszvEij3SsQSdcxo4GzSMW6UJ5ZhVBO9PizBVpxKTgKf-0ntb1_EMTxBC20xBY1h_foAP_vjsAyt2a8mEFSxRdZRcjiBIM"); //HttpContext.Current.Response.Cookies.Remove("cookie"); //HttpContext.Current.Response.Cookies["cookie"].Expires = DateTime.Now.AddDays(-1); //HttpContext.Current.GetOwinContext().Authentication.SignOut("Cookies"); //HttpContext.Current.GetOwinContext().Authentication.SignOut("oidc"); //HttpContext.Current.GetOwinContext().Authentication.SignOut(); // HttpContext.Current.GetOwinContext().Authentication.SignOut(CookieAuthenticationDefaults.AuthenticationType); // examplefunction(); return(returnvalue); }
public static string ConnectLs(string sc_C, string pwd_C, string device_id) { string r = Mydb.ExecuteAsJson("TestDB.dbo.sp_QUICK_API_auth", new SqlParameter[] { new SqlParameter("@log", sc_C), new SqlParameter("@pwd", pwd_C), new SqlParameter("@DEVICE_ID", device_id) }, CommandType.StoredProcedure).ToString(); return(r); }
public static void COMPARE_REQUESTS(bool is_Compare, string Request_as_JSON, int R_id_guid, int lg, string EVENT_MESSAGE, string path, string R_Services) { string R_id_guid2 = R_id_guid.ToString(); int REQUEST_ID = 0; if (int.TryParse(R_id_guid2, out REQUEST_ID)) { } string EVENT_TYPE; string EVENT_STATUS = "Важное"; // string path = HttpContext.Current.Request.Url.AbsolutePath; string EVENT_ROLE = (path.IndexOf("Manager/") > -1) ? "Управляющий" : (path.IndexOf("Super_Disp/") > -1) ? "Супер Диспетчер" : (path.IndexOf("Responsible_Admin/") > -1) ? "Ответственный" : (path.IndexOf("Disp_Admin/") > -1) ? "Диспетчер" : "Диспетчер поставщика"; string EVENT_MODULE = (path.IndexOf("Manager/") > -1) ? "Профиль Управляющего" : (path.IndexOf("Super_Disp/") > -1) ? "Диспетчерская" : (path.IndexOf("Responsible_Admin/") > -1) ? "Профиль Управляющего" : (path.IndexOf("Disp_Admin/") > -1) ? "Диспетчерская" : "Диспетчер поставщика"; if (is_Compare == false) { if (REQUEST_ID != 0) { EVENT_TYPE = "Создан"; ExecuteNoNQuery("[usp_ConstructorAPI_INSERT_LOG]", new SqlParameter[] { new SqlParameter("@EVENT_TYPE", EVENT_TYPE), new SqlParameter("@EVENT_STATUS", EVENT_STATUS), new SqlParameter("@EVENT_ROLE", EVENT_ROLE), new SqlParameter("@EVENT_MODULE", EVENT_MODULE), new SqlParameter("@EVENT_MESSAGE", EVENT_MESSAGE), new SqlParameter("@EVENT_MAKER", lg), new SqlParameter("@REQUEST_ID", REQUEST_ID), new SqlParameter("@JSON_DATAS", Request_as_JSON) }, CommandType.StoredProcedure); if (Request_as_JSON != "4" && Request_as_JSON != "5") { Mydb.ExecuteNoNQuery("LoginForRequest", new SqlParameter[] { new SqlParameter("@action", "NewUkR"), new SqlParameter("@rId", REQUEST_ID), new SqlParameter("@lg", lg) }, CommandType.StoredProcedure); Mydb.ExecuteNoNQuery("LoginForRequest", new SqlParameter[] { new SqlParameter("@action", "NewResp"), new SqlParameter("@rId", REQUEST_ID), new SqlParameter("@lg", lg) }, CommandType.StoredProcedure); Mydb.ExecuteNoNQuery("LoginForRequest", new SqlParameter[] { new SqlParameter("@action", "NewIspol"), new SqlParameter("@rId", REQUEST_ID), new SqlParameter("@lg", lg) }, CommandType.StoredProcedure); } } else { Mydb.ExecuteNoNQuery("LoginForRequest", new SqlParameter[] { new SqlParameter("@action", "NewSuppR"), new SqlParameter("@rGuid", R_id_guid2), new SqlParameter("@lg", lg) }, CommandType.StoredProcedure); } } else { EVENT_TYPE = "Обновить"; ExecuteNoNQuery("[usp_ConstructorAPI_INSERT_LOG]", new SqlParameter[] { new SqlParameter("@EVENT_TYPE", EVENT_TYPE), new SqlParameter("@EVENT_STATUS", EVENT_STATUS), new SqlParameter("@EVENT_ROLE", EVENT_ROLE), new SqlParameter("@EVENT_MODULE", EVENT_MODULE), new SqlParameter("@EVENT_MESSAGE", EVENT_MESSAGE), new SqlParameter("@EVENT_MAKER", lg), new SqlParameter("@REQUEST_ID", REQUEST_ID), new SqlParameter("@JSON_DATAS", Request_as_JSON) }, CommandType.StoredProcedure); dynamic Old_requests = JsonConvert.DeserializeObject(ExecuteAsJson("GETRequestForLOG", new SqlParameter[] { new SqlParameter("@rid", REQUEST_ID) }, CommandType.StoredProcedure)); dynamic newRequest = JsonConvert.DeserializeObject(Request_as_JSON); int STATUS_ID = (int)newRequest[0].STATUS_ID; string TextForPlanDate = ""; string TextForPlanTime = ""; //if (REQUEST_ID != 0) //{ // Mydb.ExecuteNoNQuery("LoginForRequest", new SqlParameter[] { new SqlParameter("@action", "NewStatus"), new SqlParameter("@rId", REQUEST_ID), new SqlParameter("@NewStatusId", STATUS_ID) }, CommandType.StoredProcedure); //} //else //{ // Mydb.ExecuteNoNQuery("LoginForRequest", new SqlParameter[] { new SqlParameter("@action", "NewUkRStatus"), new SqlParameter("@rGuid", R_id_guid2), new SqlParameter("@NewStatusId", STATUS_ID) }, CommandType.StoredProcedure); //} string Pdate = newRequest[0].Pdate; string[] charArray = Pdate.Split('-'); Pdate = charArray[2] + "." + charArray[1] + '.' + charArray[0]; string PLAN_END_DATE = Old_requests[0].PLAN_END_DATE; PLAN_END_DATE = (PLAN_END_DATE.Length != 0) ? PLAN_END_DATE.Substring(0, 10) : ""; if (Pdate != PLAN_END_DATE && PLAN_END_DATE.Length != 0) { TextForPlanDate = ": планируемая дата изменена с «" + PLAN_END_DATE + "» на «" + Pdate + "»"; ExecuteNoNQuery("[insert_HISTORY_LOG]", new SqlParameter[] { new SqlParameter("@REQUEST_ID", REQUEST_ID), new SqlParameter("@EVENT_MAKER", lg), new SqlParameter("@EVENT_ROLE", EVENT_ROLE), new SqlParameter("@EVENT_TYPE", EVENT_TYPE), new SqlParameter("@LOG_TYPE", 1), new SqlParameter("@PLAN_DATE_TEXT", TextForPlanDate) }, CommandType.StoredProcedure); } else { if (PLAN_END_DATE.Length == 0) { TextForPlanDate = ": Выбран планируемая дата на «" + Pdate + "»"; ExecuteNoNQuery("[insert_HISTORY_LOG]", new SqlParameter[] { new SqlParameter("@REQUEST_ID", REQUEST_ID), new SqlParameter("@EVENT_MAKER", lg), new SqlParameter("@EVENT_ROLE", EVENT_ROLE), new SqlParameter("@EVENT_TYPE", EVENT_TYPE), new SqlParameter("@LOG_TYPE", 1), new SqlParameter("@PLAN_DATE_TEXT", TextForPlanDate) }, CommandType.StoredProcedure); } } string Ptime = newRequest[0].Ptime; string PLAN_END_TIME = Old_requests[0].PLAN_END_TIME; PLAN_END_TIME = (PLAN_END_TIME.Length != 0) ? PLAN_END_TIME.Substring(0, 5) : ""; Ptime = Ptime.Substring(0, 5); if (Ptime != PLAN_END_TIME && PLAN_END_TIME.Length != 0) { TextForPlanTime = ": планируемое время изменено с «" + PLAN_END_TIME + "» на «" + Ptime + "»"; ExecuteNoNQuery("[insert_HISTORY_LOG]", new SqlParameter[] { new SqlParameter("@REQUEST_ID", REQUEST_ID), new SqlParameter("@EVENT_MAKER", lg), new SqlParameter("@EVENT_ROLE", EVENT_ROLE), new SqlParameter("@EVENT_TYPE", EVENT_TYPE), new SqlParameter("@LOG_TYPE", 1), new SqlParameter("@PLAN_DATE_TEXT", TextForPlanTime) }, CommandType.StoredProcedure); } else { if (PLAN_END_TIME.Length == 0) { TextForPlanTime = ": Выбран планируемое время на «" + Ptime + "»"; ExecuteNoNQuery("[insert_HISTORY_LOG]", new SqlParameter[] { new SqlParameter("@REQUEST_ID", REQUEST_ID), new SqlParameter("@EVENT_MAKER", lg), new SqlParameter("@EVENT_ROLE", EVENT_ROLE), new SqlParameter("@EVENT_TYPE", EVENT_TYPE), new SqlParameter("@LOG_TYPE", 1), new SqlParameter("@PLAN_DATE_TEXT", TextForPlanTime) }, CommandType.StoredProcedure); } } // string TextForPerformer = ""; string newspId = Convert.ToString(newRequest[0].spId); Mydb.ExecuteNoNQuery("LoginForRequest", new SqlParameter[] { new SqlParameter("@action", "IspolChange"), new SqlParameter("@rId", REQUEST_ID), new SqlParameter("@IspolId", newspId), new SqlParameter("@lg", lg) }, CommandType.StoredProcedure); string OldSPECIALIS_ID = Convert.ToString(Old_requests[0].SPECIALIS_ID); if (newspId != OldSPECIALIS_ID) { var new_spId = (newRequest[0].spId != null) ? Convert.ToInt32(newRequest[0].spId) : DBNull.Value; var Old_SPECIALIS_ID = (Old_requests[0].SPECIALIS_ID != DBNull.Value) ? Convert.ToInt32(Old_requests[0].SPECIALIS_ID) : DBNull.Value; // TextForPerformer = "исполнитель изменен с «" + Old_requests.SPECIALIS_ID + "» на «" + newRequest.spId + "»"; ExecuteNoNQuery("[insert_HISTORY_LOG]", new SqlParameter[] { new SqlParameter("@REQUEST_ID", REQUEST_ID), new SqlParameter("@EVENT_MAKER", lg), new SqlParameter("@EVENT_ROLE", EVENT_ROLE), new SqlParameter("@EVENT_TYPE", EVENT_TYPE), new SqlParameter("@LOG_TYPE", 2), new SqlParameter("@OLD_ID", Old_SPECIALIS_ID), new SqlParameter("@NEW_ID", new_spId) }, CommandType.StoredProcedure); } // string TextForResponsible = ""; string newResp = Convert.ToString(newRequest[0].RESPONSIBLE_ID); Mydb.ExecuteNoNQuery("LoginForRequest", new SqlParameter[] { new SqlParameter("@action", "RespChange"), new SqlParameter("@rId", REQUEST_ID), new SqlParameter("@RespId", newResp), new SqlParameter("@lg", lg) }, CommandType.StoredProcedure); string oldResp = Convert.ToString(Old_requests[0].RESPONSIBLE_ID); if (newResp != oldResp) { //TextForResponsible = "ответственный по заявке изменен с «" + Old_requests.RESPONSIBLE_ID + "» на «" + newRequest.RESPONSIBLE_ID + "»"; var New_RESPONSIBLE_ID = (newRequest[0].RESPONSIBLE_ID != null) ? Convert.ToInt32(newRequest[0].RESPONSIBLE_ID) : DBNull.Value; var Old_RESPONSIBLE_ID = (Old_requests[0].RESPONSIBLE_ID != DBNull.Value) ? Convert.ToInt32(Old_requests[0].RESPONSIBLE_ID) : DBNull.Value; ExecuteNoNQuery("[insert_HISTORY_LOG]", new SqlParameter[] { new SqlParameter("@REQUEST_ID", REQUEST_ID), new SqlParameter("@EVENT_MAKER", lg), new SqlParameter("@EVENT_ROLE", EVENT_ROLE), new SqlParameter("@EVENT_TYPE", EVENT_TYPE), new SqlParameter("@LOG_TYPE", 3), new SqlParameter("@OLD_ID", Old_RESPONSIBLE_ID), new SqlParameter("@NEW_ID", New_RESPONSIBLE_ID) }, CommandType.StoredProcedure); } dynamic New_prs = JsonConvert.DeserializeObject(R_Services); dynamic Old_prs = JsonConvert.DeserializeObject(ExecuteAsJson("GETREQUEST_SERVICES_FOR_LOG", new SqlParameter[] { new SqlParameter("@REQUEST_ID", REQUEST_ID) }, CommandType.StoredProcedure)); //Если Добавлена услуга или Группа услуг или изиеннено for (int k = 0; k < New_prs.Count; k++) { string New_Service_Guid = Convert.ToString(New_prs[k].SERVICE_GUID); object New_ParentId = ExecuteScalar("GetParentIdOfServices", new SqlParameter[] { new SqlParameter("@SERVICE_GUID", New_Service_Guid) }, CommandType.StoredProcedure); int CountOf_Service = (int)Mydb.ExecuteScalar("GetServiceCount", new SqlParameter[] { new SqlParameter("@rid", REQUEST_ID), new SqlParameter("@service_gud", New_Service_Guid) }, CommandType.StoredProcedure); // Если Добавлена услуга if (New_ParentId != DBNull.Value) { if (CountOf_Service == 0) { string NEW_quantity2 = Convert.ToString(New_prs[k].QUANTITY); ExecuteNoNQuery("[insert_HISTORY_LOG]", new SqlParameter[] { new SqlParameter("@REQUEST_ID", REQUEST_ID), new SqlParameter("@EVENT_MAKER", lg), new SqlParameter("@EVENT_ROLE", EVENT_ROLE), new SqlParameter("@EVENT_TYPE", EVENT_TYPE), new SqlParameter("@LOG_TYPE", 5), new SqlParameter("@NEW_QUANTITY", NEW_quantity2), new SqlParameter("@SERVICE_GUID", Convert.ToString(New_prs[k].SERVICE_GUID)) }, CommandType.StoredProcedure); } //изменено данные старых услуг else { dynamic old = JsonConvert.DeserializeObject(Mydb.ExecuteAsJson("GetService_COST_QUANTITY", new SqlParameter[] { new SqlParameter("@SERVICE_GUID", New_Service_Guid), new SqlParameter("@rid", REQUEST_ID) }, CommandType.StoredProcedure)); string OLD_quantity = Convert.ToString(old[0].QUANTITY); string OLD_cost = Convert.ToString(old[0].COST); string NEW_COST = Convert.ToString(New_prs[k].COST); string NEW_quantity = Convert.ToString(New_prs[k].QUANTITY); NEW_quantity = (NEW_quantity.IndexOf('.') != -1) ? NEW_quantity.Replace(".", ",") : NEW_quantity + ",00"; if (OLD_cost != NEW_COST) { ExecuteNoNQuery("[insert_HISTORY_LOG]", new SqlParameter[] { new SqlParameter("@REQUEST_ID", REQUEST_ID), new SqlParameter("@EVENT_MAKER", lg), new SqlParameter("@EVENT_ROLE", EVENT_ROLE), new SqlParameter("@EVENT_TYPE", EVENT_TYPE), new SqlParameter("@LOG_TYPE", 4), new SqlParameter("@OLD_COST", (OLD_cost == "0.00")?"Договорная":OLD_cost), new SqlParameter("@NEW_COST", (NEW_COST == "0.00")?"Договорная":NEW_COST), new SqlParameter("@SERVICE_GUID", Convert.ToString(New_prs[k].SERVICE_GUID)) }, CommandType.StoredProcedure); } if (OLD_quantity != NEW_quantity) { ExecuteNoNQuery("[insert_HISTORY_LOG]", new SqlParameter[] { new SqlParameter("@REQUEST_ID", REQUEST_ID), new SqlParameter("@EVENT_MAKER", lg), new SqlParameter("@EVENT_ROLE", EVENT_ROLE), new SqlParameter("@EVENT_TYPE", EVENT_TYPE), new SqlParameter("@LOG_TYPE", 4), new SqlParameter("@OLD_QUANTITY", OLD_quantity), new SqlParameter("@NEW_QUANTITY", NEW_quantity), new SqlParameter("@SERVICE_GUID", Convert.ToString(New_prs[k].SERVICE_GUID)) }, CommandType.StoredProcedure); } } } // Если Добавлена Группа услуг else { int Count_Grups = (int)Mydb.ExecuteScalar("GetServiceCount", new SqlParameter[] { new SqlParameter("@rid", REQUEST_ID), new SqlParameter("@Parent", "yes") }, CommandType.StoredProcedure); if (Count_Grups == 0) { string NEW_quantity2 = Convert.ToString(New_prs[k].QUANTITY); ExecuteNoNQuery("[insert_HISTORY_LOG]", new SqlParameter[] { new SqlParameter("@REQUEST_ID", REQUEST_ID), new SqlParameter("@EVENT_MAKER", lg), new SqlParameter("@EVENT_ROLE", EVENT_ROLE), new SqlParameter("@EVENT_TYPE", EVENT_TYPE), new SqlParameter("@LOG_TYPE", 5), new SqlParameter("@NEW_QUANTITY", NEW_quantity2), new SqlParameter("@SERVICE_GUID", Convert.ToString(New_prs[k].SERVICE_GUID)) }, CommandType.StoredProcedure); } else { // если старый Группа услуг изменено на новый string Old_Service_Guid = Mydb.ExecuteScalar("GetGrupOf_service_ofRequest", new SqlParameter[] { new SqlParameter("@rid", REQUEST_ID) }, CommandType.StoredProcedure).ToString(); if (Old_Service_Guid != New_Service_Guid) { ExecuteNoNQuery("[insert_HISTORY_LOG]", new SqlParameter[] { new SqlParameter("@REQUEST_ID", REQUEST_ID), new SqlParameter("@EVENT_MAKER", lg), new SqlParameter("@EVENT_ROLE", EVENT_ROLE), new SqlParameter("@EVENT_TYPE", EVENT_TYPE), new SqlParameter("@LOG_TYPE", 7), new SqlParameter("@Old_Service_guid", Old_Service_Guid), new SqlParameter("@New_Service_guid", New_Service_Guid) }, CommandType.StoredProcedure); } } } } //если Удалено услуги for (int i = 0; i < Old_prs.Count; i++) { string Old_Service_Guid = Convert.ToString(Old_prs[i].SERVICE_GUID); object Old_ParentId = ExecuteScalar("GetParentIdOfServices", new SqlParameter[] { new SqlParameter("@SERVICE_GUID", Old_Service_Guid) }, CommandType.StoredProcedure); if (Old_ParentId != DBNull.Value) { bool hasService = false; for (int k = 0; k < New_prs.Count; k++) { string New_Service_Guid = Convert.ToString(New_prs[k].SERVICE_GUID); if (New_Service_Guid == Old_Service_Guid) { hasService = true; } } if (hasService == false) { ExecuteNoNQuery("[insert_HISTORY_LOG]", new SqlParameter[] { new SqlParameter("@REQUEST_ID", REQUEST_ID), new SqlParameter("@EVENT_MAKER", lg), new SqlParameter("@EVENT_ROLE", EVENT_ROLE), new SqlParameter("@EVENT_TYPE", EVENT_TYPE), new SqlParameter("@LOG_TYPE", 6), new SqlParameter("@OLD_QUANTITY", "0"), new SqlParameter("@SERVICE_GUID", Old_Service_Guid) }, CommandType.StoredProcedure); } } else { bool IsDeletedOrNot = false; for (int k = 0; k < New_prs.Count; k++) { string New_Service_Guid = Convert.ToString(New_prs[k].SERVICE_GUID); object New_ParentId = ExecuteScalar("GetParentIdOfServices", new SqlParameter[] { new SqlParameter("@SERVICE_GUID", New_Service_Guid) }, CommandType.StoredProcedure); if (New_ParentId != DBNull.Value) { IsDeletedOrNot = true; } } if (IsDeletedOrNot == true) { ExecuteNoNQuery("[insert_HISTORY_LOG]", new SqlParameter[] { new SqlParameter("@REQUEST_ID", REQUEST_ID), new SqlParameter("@EVENT_MAKER", lg), new SqlParameter("@EVENT_ROLE", EVENT_ROLE), new SqlParameter("@EVENT_TYPE", EVENT_TYPE), new SqlParameter("@LOG_TYPE", 6), new SqlParameter("@OLD_QUANTITY", "0"), new SqlParameter("@SERVICE_GUID", Old_Service_Guid) }, CommandType.StoredProcedure); } } } } }