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