protected void grvNgach_UpdateCommand(object sender, GridCommandEventArgs e) { GridEditableItem item = e.Item as GridEditableItem; switch (e.Item.OwnerTableView.Name) { case "tbl_Ngach": var iDNgach = Convert.ToInt32(item.GetDataKeyValue("IDNgach").ToString()); Ngach ngach = _entities.Ngaches.Where(d => d.IDNgach == iDNgach).First(); ngach.NgayCapNhat = DateTime.Now; ngach.NguoiCapNhat = idNhanVien; item.UpdateValues(ngach); _entities.SaveChanges(); break; case "tbl_BacNgach": var iDBacNgach = Convert.ToInt32(item.GetDataKeyValue("IDBacNgach").ToString()); BacNgach bacngach = _entities.BacNgaches.Where(d => d.IDBacNgach == iDBacNgach).First(); bacngach.NgayCapNhat = DateTime.Now; bacngach.NguoiCapNhat = idNhanVien; item.UpdateValues(bacngach); _entities.SaveChanges(); break; } }
protected void radGridPaciente_ItemCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "Buscar") { GridEditableItem item = e.Item as GridEditableItem; string idTipoIdentificacion = item.GetDataKeyValue("idTipoIdentificacion").ToString(); string numeroIdentificacion = item.GetDataKeyValue("NumeroIdentifacion").ToString(); Response.Redirect("~/ModPacientes/RegistroPaciente.aspx?idTipoIdentificacion=" + idTipoIdentificacion + "&NumeroIdentifacion=" + numeroIdentificacion); } if (e.CommandName == "360") { GridEditableItem item = e.Item as GridEditableItem; string idTipoIdentificacion = item.GetDataKeyValue("idTipoIdentificacion").ToString(); string numeroIdentificacion = item.GetDataKeyValue("NumeroIdentifacion").ToString(); int riesgo = Convert.ToInt16(item.GetDataKeyValue("riesgo")); decimal Glucosa = Convert.ToDecimal(item.GetDataKeyValue("Glucosa")); decimal limiteSuperiorGlucosa = Convert.ToInt16(item.GetDataKeyValue("limiteSuperiorGlucosa")); decimal limiteInferiorGlucosa = Convert.ToInt16(item.GetDataKeyValue("limiteInferiorGlucosa")); decimal Sistolica = Convert.ToDecimal(item.GetDataKeyValue("Sistolica")); decimal limiteSuperiorSistolica = Convert.ToInt16(item.GetDataKeyValue("limiteSuperiorSistolica")); decimal limiteInferiorSistolica = Convert.ToInt16(item.GetDataKeyValue("limiteInferiorSistolica")); decimal Diastolica = Convert.ToDecimal(item.GetDataKeyValue("Diastolica")); decimal limiteSuperiorDiastolica = Convert.ToInt16(item.GetDataKeyValue("limiteSuperiorDiastolica")); decimal limiteInferiorDiastolica = Convert.ToInt16(item.GetDataKeyValue("limiteInferiorDiastolica")); DateTime FechaGlucosa = Convert.ToDateTime(item.GetDataKeyValue("FechaGlucosa")); DateTime FechaSistolica = Convert.ToDateTime(item.GetDataKeyValue("FechaSistolica")); DateTime FechaDiastolica = Convert.ToDateTime(item.GetDataKeyValue("FechaDiastolica")); Response.Redirect("~/ModPacientes/Vista360.aspx?idTipoIdentificacion=" + idTipoIdentificacion + "&NumeroIdentifacion=" + numeroIdentificacion + "&riesgo=" + riesgo + "&Glucosa=" + Glucosa + "&limiteSuperiorGlucosa=" + limiteSuperiorGlucosa + "&limiteInferiorGlucosa=" + limiteInferiorGlucosa + "&Sistolica=" + Sistolica + "&limiteSuperiorSistolica=" + limiteSuperiorSistolica + "&limiteInferiorSistolica=" + limiteInferiorSistolica + "&Diastolica=" + Diastolica + "&limiteSuperiorDiastolica=" + limiteSuperiorDiastolica + "&limiteInferiorDiastolica=" + limiteInferiorDiastolica + "&FechaGlucosa=" + FechaGlucosa + "&FechaSistolica=" + FechaSistolica + "&FechaDiastolica=" + FechaDiastolica); } }
protected void RadGridPatients_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e) { // form template is in insert mode if (e.Item is GridEditFormInsertItem && RadGridPatients.MasterTableView.IsItemInserted) { RadComboBox cmbCities = e.Item.FindControl("cmbCities") as RadComboBox; cmbCities.DataSource = getCities(); cmbCities.DataBind(); RadComboBox cmbNationalities = e.Item.FindControl("cmbNationalities") as RadComboBox; cmbNationalities.DataSource = getNationalities(); cmbNationalities.DataBind(); Panel patientPasswordPanel = e.Item.FindControl("patientPasswordPanel") as Panel; patientPasswordPanel.Visible = false; } else if (e.Item is GridEditFormItem && e.Item.IsInEditMode) { RadComboBox cmbCities = e.Item.FindControl("cmbCities") as RadComboBox; cmbCities.DataSource = getCities(); cmbCities.DataBind(); RadComboBox cmbNationalities = e.Item.FindControl("cmbNationalities") as RadComboBox; cmbNationalities.DataSource = getNationalities(); cmbNationalities.DataBind(); CheckBox chkActive = e.Item.FindControl("chkActive") as CheckBox; GridEditableItem dataItem = e.Item as GridEditableItem; int PatientId = Convert.ToInt32(dataItem.GetDataKeyValue("patientId")); chkActive.Checked = db.Patients.Where(p => p.id == PatientId).Any(p => p.Sec_Users.IsActive == true); GridEditableItem editItem = e.Item as GridEditableItem; string patientCityID = editItem.GetDataKeyValue("patientCityID").ToString(); cmbCities.SelectedValue = editItem.GetDataKeyValue("patientCityID").ToString(); cmbNationalities.SelectedValue = editItem.GetDataKeyValue("patientnatid").ToString(); } }
protected void grvNhomChucDanh_UpdateCommand(object sender, GridCommandEventArgs e) { GridEditableItem item = e.Item as GridEditableItem; switch (e.Item.OwnerTableView.Name) { case "tbl_NhomChucDanh": var iDNhomChucDanh = Convert.ToInt32(item.GetDataKeyValue("IDNhomChucDanh").ToString()); NhomChucDanh nhomchucdanh = _entities.NhomChucDanhs.Where(d => d.IDNhomChucDanh == iDNhomChucDanh).First(); nhomchucdanh.NgayCapNhat = DateTime.Now; nhomchucdanh.NguoiCapNhat = idNhanVien; item.UpdateValues(nhomchucdanh); _entities.SaveChanges(); break; case "tbl_ChucDanhChuyenMon": var iDChucDanhChuyenMon = Convert.ToInt32(item.GetDataKeyValue("IDChucDanh").ToString()); ChucDanh chucdanh = _entities.ChucDanhs.Where(d => d.IDChucDanh == iDChucDanhChuyenMon).First(); chucdanh.NgayCapNhat = DateTime.Now; chucdanh.NguoiCapNhat = idNhanVien; item.UpdateValues(chucdanh); _entities.SaveChanges(); break; } }
// insert/update function private void Insert_or_Update_ProjectMaster(ref GridCommandEventArgs e, string operation) { GridEditableItem editedItem = e.Item as GridEditableItem; try { if (e.Item.OwnerTableView.DataMember == "ProjectMaster") { //Insert new values Hashtable newPaycodeValues = new Hashtable(); newPaycodeValues["@prjidd"] = Convert.ToInt32(editedItem.GetDataKeyValue("prjidd")); newPaycodeValues["@prjcod"] = editedItem.GetDataKeyValue("prjcod"); RadComboBox ddlEmployee = (editedItem.FindControl("ddlEmployee") as RadComboBox); if (ddlEmployee != null) { if (ddlEmployee.Items.Count > 0) { #region delete old records Hashtable ht = new Hashtable(); ht.Add("@ID", Convert.ToInt32(editedItem.GetDataKeyValue("prjidd"))); clsDAL.ExecuteNonQuery_payroll("sp_Payroll_Delete_ProjectEmployeeAssignment_detail", ht); #endregion RadGrid rgEmployee = (ddlEmployee.Items[0].FindControl("rGrdEmployee4DDL") as RadGrid); if (rgEmployee.SelectedItems.Count > 0) { foreach (GridDataItem dataItem in rgEmployee.SelectedItems) { newPaycodeValues["@empidd"] = Convert.ToInt32(dataItem.OwnerTableView.DataKeyValues[dataItem.ItemIndex]["recidd"].ToString()); newPaycodeValues["@empcod"] = dataItem.OwnerTableView.DataKeyValues[dataItem.ItemIndex]["empcod"].ToString(); newPaycodeValues["@empfsn"] = dataItem.OwnerTableView.DataKeyValues[dataItem.ItemIndex]["empfsn"].ToString(); newPaycodeValues["@DBMessage"] = ""; string DBMessage = ""; DBMessage = clsDAL.ExecuteNonQuery_payroll("sp_Payroll_Insert_ProjectEmployeeAssignment_Record", newPaycodeValues, "@DBMessage", System.Data.SqlDbType.NVarChar, 255).ToString(); if ((null != DBMessage) && DBMessage.Contains("ERROR:")) { ShowClientMessage(DBMessage, MessageType.Error); e.Canceled = true; } } } } } ShowClientMessage("Project employee assignment record saved successfully.", MessageType.Success); gvProject.Rebind(); } } catch (Exception ex) { ShowClientMessage("Unable to save project employee assignment record. Reason: " + ex.Message, MessageType.Error); e.Canceled = true; } }
protected void RadGridPatients_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e) { // form template is in insert mode if (e.Item is GridEditFormInsertItem && RadGridPatients.MasterTableView.IsItemInserted) { // fill in drop down lists with data RadComboBox cmbCities = e.Item.FindControl("cmbCities") as RadComboBox; cmbCities.DataSource = getCities(); cmbCities.DataBind(); RadComboBox cmbNationalities = e.Item.FindControl("cmbNationalities") as RadComboBox; cmbNationalities.DataSource = getNationalities(); cmbNationalities.DataBind(); ImageButton btnAddProcess = e.Item.FindControl("btnAddProcess") as ImageButton; btnAddProcess.Visible = false; } else // form template is in edit mode if (e.Item is GridEditFormItem && e.Item.IsInEditMode) { // fill in drop down lists with data RadComboBox cmbCities = e.Item.FindControl("cmbCities") as RadComboBox; cmbCities.DataSource = getCities(); cmbCities.DataBind(); RadComboBox cmbNationalities = e.Item.FindControl("cmbNationalities") as RadComboBox; cmbNationalities.DataSource = getNationalities(); cmbNationalities.DataBind(); // get patient city id from the edited item GridEditableItem editItem = (GridEditableItem)e.Item; cmbCities.SelectedValue = editItem.GetDataKeyValue("patientCityID").ToString(); cmbNationalities.SelectedValue = editItem.GetDataKeyValue("patientnatid").ToString(); RadComboBox cmbProcessTypes = e.Item.FindControl("cmbProcessTypes") as RadComboBox; cmbProcessTypes.DataSource = getprocessTypes(); cmbProcessTypes.DataBind(); RadDatePicker dpProcessDate = e.Item.FindControl("dpProcessDate") as RadDatePicker; dpProcessDate.MinDate = System.DateTime.Now; RadComboBox cmbOrganizations = e.Item.FindControl("cmbOrganizations") as RadComboBox; cmbOrganizations.DataSource = getOrganizations(); cmbOrganizations.DataBind(); Panel PatientProcessMedicine = e.Item.FindControl("PatientProcessMedicine") as Panel; RadListView RadListViewPatientRegister = e.Item.FindControl("RadListViewPatientRegister") as RadListView; RadListView RadListViewPatientMedicine = e.Item.FindControl("RadListViewPatientMedicine") as RadListView; GridEditableItem dataItem = e.Item as GridEditableItem; int PatientId = Convert.ToInt32(dataItem.GetDataKeyValue("patientId")); if (getPatientRegistrationsCount(PatientId) > 0) { PatientProcessMedicine.Visible = true; RadListViewPatientRegister.DataSource = getPatientRegisterationsById(PatientId); RadListViewPatientMedicine.DataBind(); RadListViewPatientMedicine.DataSource = getMedicinesById(PatientId); RadListViewPatientMedicine.DataBind(); } } }
protected void grdManufacturers_UpdateCommand(object sender, GridCommandEventArgs e) { GridEditableItem item = e.Item as GridEditableItem; var manufacturerId = (int)item.GetDataKeyValue("VehicleManufacturerId"); string oldManufacturerDesc = item.GetDataKeyValue("Description").ToString(); string manufacturerDesc = (item.FindControl("ManufacturerDescEdit") as RadTextBox).Text; if (string.Compare(manufacturerDesc, oldManufacturerDesc, false) != 0) { Facade.Manufacturer.Update(manufacturerId, manufacturerDesc); } item.Edit = false; }
/// <summary> /// Fires when updating information in the grid /// </summary> protected void rgElementHazards_UpdateCommand(object sender, GridCommandEventArgs e) { GridEditableItem item = e.Item as GridEditableItem; if (e.Item.OwnerTableView.Name == "Hazards") { int site_specificcond_id = Convert.ToInt32(item.GetDataKeyValue("site_specificcond_id")); var updateSSC = db.SHASpecificConditions.FirstOrDefault(p => p.site_specificcond_id == site_specificcond_id); updateSSC.remarks = (item.FindControl("tbHazard") as TextBox).Text; updateSSC.priority = (item.FindControl("cbPriority") as CheckBox).Checked; try { db.SubmitChanges(); DisplayMessage(false, "The site specific condition was updated!", "hazards"); } catch (Exception ex) { DisplayMessage(true, "Unable to update site specific condition. Reason: " + ex.Message, "hazards"); e.Canceled = true; } } else if (e.Item.OwnerTableView.Name == "JobLimits") { int site_reflevel_id = Convert.ToInt32(item.GetDataKeyValue("site_reflevel_id")); var updateRL = db.SHAReferenceLevels.FirstOrDefault(p => p.site_reflevel_id == site_reflevel_id); updateRL.reflevel_id = Convert.ToInt32((item.FindControl("rddlJobLimitType") as RadDropDownList).SelectedValue); updateRL.reflevel_va = Convert.ToDouble((item.FindControl("rntbJobLimitValue") as RadNumericTextBox).Text); updateRL.reflevel_units = (item.FindControl("tbUnits") as TextBox).Text; updateRL.remarks = (item.FindControl("tbRemarks") as TextBox).Text; try { db.SubmitChanges(); DisplayMessage(false, "The job operational limit was updated!", "hazards"); } catch (Exception ex) { DisplayMessage(true, "Unable to update job operational limit. Reason: " + ex.Message, "hazards"); e.Canceled = true; } } //Update the reviewed_by and reviewed_dt fields of SHA_Site_Master - the reviewed_by and reviewed_dt fields are legacy; not being used outside of this situation var sha = db.SHAs.FirstOrDefault(p => p.site_id == SiteID); sha.reviewed_by = user.ID; sha.reviewed_dt = DateTime.Now; db.SubmitChanges(); }
protected void rgRecordTypes_UpdateCommand(object source, GridCommandEventArgs e) { GridEditableItem editedItem = (GridEditableItem)e.Item; UserControl MyUserControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID); try { int record_type_id = Convert.ToInt32(editedItem.GetDataKeyValue("record_type_id")); var rec_type = db.RecordTypes.FirstOrDefault(p => p.record_type_id == record_type_id); rec_type.type_cd = ((TextBox)MyUserControl.FindControl("tbCode")).Text; rec_type.type_ds = ((TextBox)MyUserControl.FindControl("tbDescription")).Text; rec_type.TemplateID = Convert.ToInt32(((RadDropDownList)MyUserControl.FindControl("rddlTemplates")).SelectedValue); rec_type.analyze_html_va = ((RadTextBox)MyUserControl.FindControl("rtbAnalyzeInstructions")).Text; rec_type.approve_html_va = ((RadTextBox)MyUserControl.FindControl("rtbApproveInstructions")).Text; db.SubmitChanges(); rgRecordTypes.Rebind(); } catch (Exception ex) { Label lblError = new Label(); lblError.Text = "Unable to update record-type. Reason: " + ex.Message; lblError.ForeColor = System.Drawing.Color.Red; rgRecordTypes.Controls.Add(lblError); e.Canceled = true; } }
protected void rgAdditionalNotes_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { try { //Guid ChildDataID = new Guid(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["Id"].ToString()); if (e.CommandName == "Edit") { GridEditableItem dataItem = (GridEditableItem)e.Item; ChildDataId = new Guid(ViewState["ChildDataId"].ToString()); ViewState["Id"] = dataItem.GetDataKeyValue("Id").ToString(); Guid ChildSchoolYearId = Common.GetChildSchoolYearId(ChildDataId, new Guid(Session["CurrentSchoolYearId"].ToString())); DayCareBAL.AdditionalNotesService proxyAdditionalNotes = new DayCareBAL.AdditionalNotesService(); DayCarePL.AdditionalNotesProperties[] objNotes = proxyAdditionalNotes.GetAdditionNoteById(new Guid(dataItem.GetDataKeyValue("Id").ToString()), ChildSchoolYearId); if (objNotes != null) { radCommentDate.SelectedDate = Convert.ToDateTime(objNotes[0].CommentDate); txtComment.Text = objNotes[0].Comments; } e.Canceled = true; } } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.AddEditChild, "rgAddEditChid_ItemCommand", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); } }
protected void m_dgvGrid_UpdateCommand(object source, GridCommandEventArgs e) { DisplayError("", m_lblError); Hashtable values = new Hashtable(); GridEditableItem item = e.Item as GridEditableItem; item.ExtractValues(values); m_role = Role(item.GetDataKeyValue("ID")); if (!m_role.UpdateName(String(values["Name"]))) { e.Canceled = true; DisplayError("Failed to update the role name.", m_lblError); } else { Repeater repeater = e.Item.FindControl("m_rpTaskList") as Repeater; foreach (RepeaterItem rItem in repeater.Items) { CheckBox chkTask = rItem.FindControl("m_chkTask") as CheckBox; if (chkTask.Checked) { var btnDelete = rItem.FindControl("m_btnDelete") as LinkButton; var task = Task(btnDelete.CommandArgument); m_role.AddTask(task); } } } }
protected void m_dgvGrid_UpdateCommand(object source, GridCommandEventArgs e) { DisplayError("", m_lblError); Hashtable values = new Hashtable(); GridEditableItem item = e.Item as GridEditableItem; item.ExtractValues(values); m_businessEntity = Entity(m_cboEntities.SelectedValue); m_shift = Shift(m_cboShifts.SelectedValue, m_businessEntity); m_shiftException = ShiftException(item.GetDataKeyValue("ID"), m_shift); m_shiftStart = DateTime(values["StartTime"]); m_shiftEnd = DateTime(values["EndTime"]); m_shiftEnd = new DateTime(m_shiftStart.Year, m_shiftStart.Month, m_shiftStart.Day, m_shiftEnd.Hour, m_shiftEnd.Minute, m_shiftEnd.Second, m_shiftEnd.Millisecond); if (m_shiftEnd < m_shiftStart) { m_shiftEnd = m_shiftEnd.AddDays(1); } var exceptionTypeID = Int((e.Item.FindControl("m_cboExceptionTypes") as RadComboBox).SelectedValue); m_shiftExceptionType = ShiftExceptionType(exceptionTypeID); var weekDayName = String((e.Item.FindControl("m_cboWeekDays") as RadComboBox).SelectedValue); DayOfWeek?weekDay = string.IsNullOrEmpty(weekDayName) ? (DayOfWeek?)null : (DayOfWeek)Enum.Parse(typeof(DayOfWeek), weekDayName); if (!m_shiftException.UpdateDetails(m_shiftStart, m_shiftEnd, weekDay, m_shiftExceptionType)) { e.Canceled = true; DisplayError("Failed to update shift exception details.", m_lblError); } }
/// <summary> /// Event Handler for Update Command /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void RadGrid1_UpdateCommand(object sender, GridCommandEventArgs e) { if (e.Item is GridEditableItem) { GridEditableItem gei = e.Item as GridEditableItem; Dictionary <string, string> newValues = new Dictionary <string, string>(); e.Item.OwnerTableView.ExtractValuesFromItem(newValues, gei); int _Id = (int)gei.GetDataKeyValue("Id"); EmployeeDataContract edc = GetAppropriateDataObject(); edc.Employees = (edc.Employees.Select(emp => { if (emp.Id == _Id) { emp = new BusinessEntities.Employee { Id = _Id, Job = newValues["Job"].ToString(), ManagerName = newValues["ManagerName"].ToString(), Name = newValues["Name"].ToString(), Salary = double.Parse(newValues["Salary"].ToString()) }; } return(emp); })).ToList(); Session["data"] = edc; } }
protected void rgSANAL_UpdateCommand(object sender, GridCommandEventArgs e) { GridEditableItem item = e.Item as GridEditableItem; int period_id = Convert.ToInt32(item.GetDataKeyValue("period_id")); var period = db.RecordAnalysisPeriods.FirstOrDefault(p => p.period_id == period_id); period.analyzed_by = (item.FindControl("rddlAnalyzedBy") as RadDropDownList).SelectedValue.ToString(); period.analyzed_dt = (item.FindControl("rdpAnalyzedDt") as RadDatePicker).SelectedDate; period.approved_by = (item.FindControl("rddlApprovedBy") as RadDropDownList).SelectedValue.ToString(); period.approved_dt = (item.FindControl("rdpApprovedDt") as RadDatePicker).SelectedDate; period.analysis_notes_va = (item.FindControl("reSANAL") as RadEditor).Content.FormatParagraphIn(); Data.PeriodChangeLog changeLog = new Data.PeriodChangeLog() { period_id = period.period_id, edited_by_uid = user.ID, edited_dt = DateTime.Now, new_va = (item.FindControl("reSANAL") as RadEditor).Text.FormatParagraphIn() }; db.PeriodChangeLogs.InsertOnSubmit(changeLog); Data.PeriodDialog dialog = new Data.PeriodDialog() { period_id = period.period_id, dialog_dt = DateTime.Now, dialog_by = user.ID, origin_va = "Admin", comments_va = "The analysis was modified using the Manage Analyses interface." }; db.PeriodDialogs.InsertOnSubmit(dialog); db.SubmitChanges(); }
protected void rgPersonnel_UpdateCommand(object sender, GridCommandEventArgs e) { GridEditableItem item = e.Item as GridEditableItem; string user_id = item.GetDataKeyValue("user_id").ToString(); var currUser = db.Employees.FirstOrDefault(p => p.user_id == user_id); int office_id = Convert.ToInt32((item.FindControl("rddlOffice") as RadDropDownList).SelectedValue); string first_nm = (item.FindControl("rtbFirstNm") as RadTextBox).Text; string last_nm = (item.FindControl("rtbLastNm") as RadTextBox).Text; string administrator_va = (item.FindControl("rddlAdminLevel") as RadDropDownList).SelectedValue.ToString(); string pass_access = (item.FindControl("rddlPASSLevel") as RadDropDownList).SelectedValue.ToString(); Boolean approver_va = Convert.ToBoolean((item.FindControl("rrblSafetyApprover") as RadRadioButtonList).SelectedValue); Boolean active = Convert.ToBoolean((item.FindControl("rrblStatus") as RadRadioButtonList).SelectedValue); Boolean show_reports = Convert.ToBoolean((item.FindControl("rcbReports") as RadCheckBox).Checked); currUser.first_nm = first_nm; currUser.last_nm = last_nm; currUser.office_id = office_id; currUser.administrator_va = administrator_va; currUser.pass_access = pass_access; currUser.approver_va = approver_va; currUser.active = active; currUser.show_reports = show_reports; db.SubmitChanges(); DisplayMessage(false, "The user's info was updated!"); }
/// <summary> /// Handles the UpdateCommand event of the rgProjectTeam control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="GridCommandEventArgs"/> instance containing the event data.</param> protected void rgProjectTeam_UpdateCommand(object sender, GridCommandEventArgs e) { searchUsers.HideNotifications(); //Get the GridEditableItem of the RadGrid GridEditableItem dataItem = e.Item as GridEditableItem; TextBox txtRole = (TextBox)dataItem.FindControl("txtRole"); int projectUserId = (int)dataItem.GetDataKeyValue("ProjectUserId"); ProjectUser projUser = DataContext.ProjectUsers.Where(pu => pu.ProjectUserId == projectUserId).FirstOrDefault(); #region Project Notification if (projUser.Role != txtRole.Text.Trim()) { string projectUserName = projUser.User.FirstName + " " + projUser.User.LastName; DataContext.Notifications.AddObject(CreateNotification(Support.GetCodeIdByCodeValue("OperationType", "EDIT"), string.Format("{0} edited the project role of {1}.", Support.UserFullName, projectUserName))); } #endregion Project Notification projUser.Role = txtRole.Text.Trim(); projUser.LastUpdatedByUserId = UserID; projUser.LastUpdatedDate = Now; DataContext.SaveChanges(); rgProjectTeam.EditIndexes.Clear(); rgProjectTeam.Rebind(); }
protected void SelectorCheckBox_CheckedChanged(Object sender, EventArgs e) { CheckBox cb = (CheckBox)sender; GridEditableItem item = (GridEditableItem)cb.NamingContainer; var index = item.GetDataKeyValue("ContactID"); if (Session["Selected"] != null) { selectedItems = (ArrayList)Session["Selected"]; } if (cb.Checked) { if (!selectedItems.Contains(index)) { selectedItems.Add(index); } } else { selectedItems.Remove(index); } if (selectedItems != null && selectedItems.Count > 0) { Session["Selected"] = selectedItems; } }
protected void userGV_UpdateCommand(object sender, GridCommandEventArgs e) { string IPAddress = Utility.GetIPAddress(); GridEditableItem item = (GridEditableItem)e.Item; string LoginID = item.GetDataKeyValue("Login_ID").ToString(); string sTxtNTID = (item.FindControl("TxtNTID") as TextBox).Text; string sTxtFirstName = (item.FindControl("TxtFirstName") as TextBox).Text; // string sTxtLastName = (item.FindControl("TxtLastName") as TextBox).Text; RadioButton RdoActive = (RadioButton)item.FindControl("RdoStatusActive"); int Status = 0; if (RdoActive.Checked == true) { Status = 1; } Int64 iRetVal = ObjPriController.FunUpdate(IPAddress, LoginID, sTxtNTID, sTxtFirstName, "", Status); if (iRetVal > 0) { MessageBoxRedirect("User Updated Successfully.", "AddUser.aspx"); } else { MessageBoxRedirect("User Already Exist.", "AddUser.aspx"); } }
protected void gvDefaultSkills_UpdateCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { if (Page.IsValid) { GridEditableItem dataItem = e.Item as GridEditableItem; TextBox txtName = (TextBox)dataItem.FindControl("txtName"); string editedSkillName = txtName.Text.Trim(); int skillId = (int)dataItem.GetDataKeyValue("SkillId"); //look for duplicate skill names Skill duplicateSkill = DataContext.Skills.Where(sk => sk.Name.ToLower() == editedSkillName.ToLower()).FirstOrDefault(); if (duplicateSkill != null && duplicateSkill.SkillId != skillId) { popupDefaultSkillMessage.ShowPopup(); e.Canceled = true; return; } else //only update if the new value is different { Skill skill = DataContext.Skills.Where(sk => sk.SkillId == skillId).FirstOrDefault(); skill.Name = editedSkillName; skill.LastUpdatedByUserId = UserID; skill.LastUpdatedDate = Now; DataContext.SaveChanges(); } gvDefaultSkills.EditIndexes.Clear(); gvDefaultSkills.Rebind(); } }
protected void RadGrid2_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e) { if (e.Item is GridEditableItem && (e.Item as GridEditableItem).IsInEditMode) { GridEditableItem editedItem = e.Item as GridEditableItem; RadComboBox ddlmarkets = editedItem.FindControl("ddlmarket") as RadComboBox; ddlmarkets.DataSource = Bitcoin_Notify_DB.SPs.ViewMarketsAll().GetDataSet().Tables[0]; ddlmarkets.DataTextField = "market_shortname"; ddlmarkets.DataValueField = "market_key"; ddlmarkets.DataBind(); //assign the card group if (editedItem is GridEditFormInsertItem) //is edit, and not insert { } else { string strgroupkey = editedItem.GetDataKeyValue("market_key").ToString(); if (strgroupkey.Length > 0) { ddlmarkets.SelectedValue = strgroupkey; } } } }
protected void m_dgvGrid_UpdateCommand(object source, GridCommandEventArgs e) { DisplayError("", m_lblError); Hashtable values = new Hashtable(); GridEditableItem item = e.Item as GridEditableItem; item.ExtractValues(values); m_businessEntity = BusinessEntity.Find(Int(item.GetDataKeyValue("ID"))); var txtName = e.Item.FindControl("m_txtCompName") as TextBox; if (!m_businessEntity.UpdateName(txtName.Text)) { e.Canceled = true; DisplayError("Failed to update the company name.", m_lblError); } Repeater repeater = e.Item.FindControl("m_rpCompanyContactInfo") as Repeater; foreach (RepeaterItem rItem in repeater.Items) { var txtValue = rItem.FindControl("m_txtData") as TextBox; var btnDelete = rItem.FindControl("m_btnDelete") as LinkButton; var contactDetail = ContactDetail(btnDelete.CommandArgument, m_businessEntity); if (!contactDetail.UpdateValue(txtValue.Text)) { e.Canceled = true; DisplayError("Failed to update the one or more contact information.", m_lblError); } } }
protected void rgFieldTrips_UpdateCommand(object sender, GridCommandEventArgs e) { GridEditableItem item = e.Item as GridEditableItem; int trip_id = Convert.ToInt32(item.GetDataKeyValue("trip_id")); var currTrip = db.Trips.FirstOrDefault(p => p.trip_id == trip_id); string trip_nm = (item.FindControl("rtbTripName") as RadTextBox).Text; string assigned_to = (item.FindControl("rddlAssignedTo") as RadDropDownList).SelectedValue.ToString(); RadListBox assigned_sites = (item.FindControl("rlbSitesEnd") as RadListBox); currTrip.trip_nm = trip_nm; currTrip.user_id = assigned_to; db.TripSites.DeleteAllOnSubmit(currTrip.TripSites); db.SubmitChanges(); List <Data.TripSite> tripSites = new List <Data.TripSite>(); foreach (RadListBoxItem site in assigned_sites.Items) { tripSites.Add(new Data.TripSite() { trip_id = currTrip.trip_id, site_id = Convert.ToInt32(site.Value) }); } db.TripSites.InsertAllOnSubmit(tripSites); db.SubmitChanges(); DisplayMessage(false, "The field trip's info was updated!"); }
private void loadControls(GridEditableItem item, GridItemEventArgs e) { try { if (item.DataItem == null) { return; } if (item.IsInEditMode) { if (item.DataItem == null) { return; } var Type_Id = item.GetDataKeyValue("Type_Id").ToString(); //Loading of Type string qry = "select * from tbl_Type_Master where Type_Id='" + Type_Id + "' "; DataTable dt = DBUtils.SQLSelect(new SqlCommand(qry)); } } catch (Exception ex) { throw ex; } }
/// <summary> /// Called when an Agreements is edited /// </summary> /// <param name="sender">The grid that is sending the update command</param> /// <param name="e">The Command Event Arguments</param> protected void rgAgreements_UpdateCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { //Cast the GridCommandEventArgs item as an editable item GridEditableItem editedItem = e.Item as GridEditableItem; //Find the user control used by that item save it as a UserControl UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID); //Grab the AgreementID of the Agreement that was edited var AgreementID = Convert.ToInt32(editedItem.GetDataKeyValue("AgreementID").ToString()); //Add metrics var metric = new MetricHandler(customer.OrgCode, customer.CustomerID, null, MetricType.RecordUpdate, "Agreement", String.Format("Updated AgreementID = {0}", AgreementID)); metric.SubmitChanges(); //Grab the agreement from the database with the matching ID var agreement = siftaDB.Agreements.FirstOrDefault(p => p.AgreementID == AgreementID); //Grab Mod 0 associated with that agreement var mod = agreement.AgreementMods.FirstOrDefault(p => p.Number == 0); //Assign the values from the user control GrabValuesFromUserControl(userControl, ref agreement, ref mod); //Grab all mods that don't have a null end date var mods = agreement.AgreementMods.Where(p => p.EndDate != null).OrderByDescending(p => p.Number).ToList(); //If a mod meets the criteria of having an end date grab the first one (highest mod number) and assign its end date to the agreement. if (mods.Count() != 0) { agreement.EndDate = mods.FirstOrDefault().EndDate; } //Submit Changes to the database siftaDB.SubmitChanges(); }
protected void m_dgvGrid_UpdateCommand(object source, GridCommandEventArgs e) { DisplayError("", m_lblError); Hashtable values = new Hashtable(); GridEditableItem item = e.Item as GridEditableItem; item.ExtractValues(values); m_businessEntity = Entity(m_cboEntities.SelectedValue); m_employee = Employee(m_cboEmployees.SelectedValue, m_businessEntity); m_attendanceException = AttendanceException(item.GetDataKeyValue("ID"), m_employee); m_start = DateTime(values["Start"]); m_end = DateTime(values["End"]); var exceptionTypeID = Int((e.Item.FindControl("m_cboExceptionTypes") as RadComboBox).SelectedValue); m_attendanceExceptionType = AttendanceExceptionType(exceptionTypeID); var approved = Bool((e.Item.FindControl("m_chkApproved") as CheckBox).Checked); if (!m_attendanceException.UpdateDetails(String(values["Remarks"]), m_start, m_end, approved)) { e.Canceled = true; DisplayError("Failed to update entry details.", m_lblError); } }
protected void rgTypeMaster_UpdateCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { try { GridEditableItem editedItem = e.Item as GridEditableItem; Hashtable newValues = new Hashtable(); e.Item.OwnerTableView.ExtractValuesFromItem(newValues, editedItem); var Type_Id = editedItem.GetDataKeyValue("Type_Id").ToString(); //Load controls RadTextBox txtTypeName = (RadTextBox)editedItem.FindControl("txtTypeName"); //Insert query var strsql = "UPDATE tbl_Type_Master set [Type_Name] = '" + txtTypeName.Text + "' where [Type_Id] = '" + Type_Id + "'"; int i = DBUtils.ExecuteSQLCommand(new SqlCommand(strsql)); if (i > 0) { rmw1.RadAlert("Type Name: " + txtTypeName.Text + " Updated Successfully", 400, 100, "Success", null); } else { rmw1.RadAlert("Error occured during Update", 400, 100, "Success", null); } } catch (Exception ex) { throw ex; } }
protected void rgCC_UpdateCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { try { GridEditableItem editedItem = e.Item as GridEditableItem; Hashtable newValues = new Hashtable(); e.Item.OwnerTableView.ExtractValuesFromItem(newValues, editedItem); var CC_Id = editedItem.GetDataKeyValue("CC_Id").ToString(); //Load controls RadTextBox txtEmail = (RadTextBox)editedItem.FindControl("txtEmail"); RadDropDownList ddlType = (RadDropDownList)editedItem.FindControl("ddlType"); //Insert query var strsql = "UPDATE tbl_Email_CC_Master set CC_Email_Id = '" + txtEmail.Text + "', Type_Id = '" + ddlType.SelectedValue + "' where CC_Id = '" + CC_Id + "'"; int i = DBUtils.ExecuteSQLCommand(new SqlCommand(strsql)); if (i > 0) { rmw1.RadAlert("Email: " + txtEmail.Text + " Updated Successfully", 400, 100, "Success", null); } else { rmw1.RadAlert("Error.", 400, 100, "Success", null); return; } } catch (Exception ex) { throw ex; } }
protected void grdPromotionCode_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { if (e.CommandName == RadGrid.InitInsertCommandName) { Response.Redirect("PromotionCodeAdd.aspx"); } else if (e.CommandName == RadGrid.EditCommandName) { GridEditableItem item = e.Item as GridEditableItem; int id = (int)item.GetDataKeyValue("PromotionCodeId"); Response.Redirect("PromotionCodeAdd.aspx?id=" + id); } else if (e.CommandName == RadGrid.DeleteCommandName) { GridEditableItem editedItem = e.Item as GridEditableItem; if (editedItem != null) { try { Telerik.Web.UI.DataKey key = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]; int id = (int)key["PromotionCodeId"]; _promoCodeManage.DeletePromotionCode(id); } catch (Exception ex) { } GetPromotionCodes(); } } }
protected void grdProducts_ItemCreated(object sender, GridItemEventArgs e) { if (e.Item is GridDataItem) { GridEditableItem item = e.Item as GridEditableItem; long id = (long)item.GetDataKeyValue("BranchProductID"); ProductsInBranch pb = (from p in entities.ProductsInBranches where p.BranchProductID == id select p).FirstOrDefault(); Label label = item.FindControl("Label1") as Label; Label label2 = item.FindControl("Label2") as Label; if (pb != null) { Product pp = (from p in entities.Products where p.ProductID == pb.ProductID select p).FirstOrDefault(); if (pp != null) { label.Text = pp.Name; } Branch bb = (from b in entities.Branches where b.BranchID == pb.BranchID select b).FirstOrDefault(); if (bb != null) { label2.Text = bb.Title; } } } }
protected void rgContacts_UpdateCommand(object sender, GridCommandEventArgs e) { GridEditableItem item = e.Item as GridEditableItem; int contact_id = Convert.ToInt32(item.GetDataKeyValue("contact_id")); var c = db.Contacts.FirstOrDefault(p => p.contact_id == contact_id); try { c.contact_nm = (item.FindControl("tbContactNm") as TextBox).Text; c.street_addrs = (item.FindControl("tbStreetAddrs2") as TextBox).Text; c.city = (item.FindControl("tbCity2") as TextBox).Text; c.state = (item.FindControl("tbState2") as TextBox).Text; c.zip = (item.FindControl("tbZip2") as TextBox).Text; c.ph_no = (item.FindControl("tbPhoneNo2") as TextBox).Text; } catch (Exception ex) { DisplayContactMessage(true, "You must complete all required form fields!"); e.Canceled = true; return; } try { db.SubmitChanges(); DisplayContactMessage(false, "The contact was updated!"); } catch (Exception ex) { DisplayContactMessage(true, "Unable to update contact. Reason: " + ex.Message); e.Canceled = true; } }
private void actualizarDatos(UserControl userControl, GridEditableItem g) { Consulta c = new Consulta(); RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta c1 = new RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta(); DetalleGrupoDependiente d = null; InsertUpdateDelete i = new InsertUpdateDelete(c1.consultarUsuarioXnombre(User.Identity.Name)); try { d = c.consultarDetalleGrupoDependenciaOBJ(Convert.ToInt32(g.GetDataKeyValue("id_grupo"))); d.estado = c.consultarEstadoParametrizacionOBJ(Convert.ToInt16((userControl.FindControl("ddlEstado") as RadDropDownList).SelectedValue)); d.descripcion = (userControl.FindControl("txtDescripcion") as RadTextBox).Text.Trim(); i.IUDdetGrupoVariableDependiente(d, 3); this.RadWindowManager1.RadAlert("Datos actualizados correctamente", 400, 200, Utilities.windowTitle(TypeMessage.information_message), null, Utilities.pathImageMessage(TypeMessage.information_message)); cargarGrilla2(); } catch (Exception ex) { Logger.generarLogError(ex.Message, new System.Diagnostics.StackFrame(true), ex); this.RadWindowManager1.RadAlert(Utilities.errorMessage(), 400, 200, Utilities.windowTitle(TypeMessage.error_message), null, Utilities.pathImageMessage(TypeMessage.error_message)); } }
public static void DeleteTouristFromList(List<TouristInfo> lstTourists, GridEditableItem editableItem) { var intTouristId = (int)editableItem.GetDataKeyValue("PolTuristiSaraksts"); var itemTourist = lstTourists.Where(n => n.PolTuristiSaraksts == intTouristId).FirstOrDefault(); lstTourists.Remove(itemTourist); }
private void eliminarExtension(GridEditableItem g) { Int16 idExtension = Convert.ToInt16(g.GetDataKeyValue("value")); Consulta c = new Consulta(); RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta c1 = new RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta(); InsertUpdateDelete i = new InsertUpdateDelete(c1.consultarUsuarioXnombre(User.Identity.Name)); ExtensionArchivo e = c.consultarExtensionesOBJ(idExtension); if (!(c.consultarExtensionXarchivo("",idExtension).Rows.Count > 0)) { if (e != null) { try { i.IUDextensionArchivo(e, 4); this.RadWindowManager1.RadAlert("Valor eliminado correctamente", 400, 200, Utilities.windowTitle(TypeMessage.information_message), null, Utilities.pathImageMessage(TypeMessage.information_message)); cargarGrilla(); } catch (Exception ex) { Logger.generarLogError(ex.Message, new System.Diagnostics.StackFrame(true), ex); this.RadWindowManager1.RadAlert(Utilities.errorMessage(), 400, 200, Utilities.windowTitle(TypeMessage.error_message), null, Utilities.pathImageMessage(TypeMessage.error_message)); } } } else { this.RadWindowManager1.RadAlert("la extensión que intenta eliminar está asociada a uno o más archivo elimine la extensión del archivo antes de eliminarla de la plataforma.", 400, 200, Utilities.windowTitle(TypeMessage.information_message), null, Utilities.pathImageMessage(TypeMessage.information_message)); } }
private void eliminarRegisgtro(GridEditableItem g) { Consulta c = new Consulta(); int idEncGrupo = Convert.ToInt32(g.GetDataKeyValue("id_enc_grupo")); if (c.consultarDetalleGrupoDependencia(idEncGrupo).Rows.Count > 0) { this.RadWindowManager1.RadAlert("No se puede eliminar el grupo, existen detalles asociados a este, favor elimínelos primero " + "antes de eliminar el grupo", 400, 200, Utilities.windowTitle(TypeMessage.information_message), null, Utilities.pathImageMessage(TypeMessage.information_message)); return; } try { RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta c1 = new RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta(); InsertUpdateDelete i = new InsertUpdateDelete(c1.consultarUsuarioXnombre(User.Identity.Name)); EncabezadoGrupoVarDependiente e = c.consultarEncabezadoGruposDependenciasOBJ(idEncGrupo); i.IUDencGrupoVariableDependiente(e, 4); this.RadWindowManager1.RadAlert("Grupo eliminado correctamente", 400, 200, Utilities.windowTitle(TypeMessage.information_message), null, Utilities.pathImageMessage(TypeMessage.information_message)); cargarGrilla(); } catch (Exception ex) { Logger.generarLogError(ex.Message, new System.Diagnostics.StackFrame(true), ex); this.RadWindowManager1.RadAlert(Utilities.errorMessage(), 400, 200, Utilities.windowTitle(TypeMessage.error_message), null, Utilities.pathImageMessage(TypeMessage.error_message)); } }
private void guardarDatos(UserControl uc, GridEditableItem g = null) { string extension = (uc.FindControl("txtExtension") as RadTextBox).Text.Trim().ToUpper(); string descripcion = (uc.FindControl("txtDescipcion") as RadTextBox).Text.Trim(); RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta c = new RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta(); InsertUpdateDelete i = new InsertUpdateDelete(c.consultarUsuarioXnombre(User.Identity.Name)); if (g == null) { DataRow[] changeRow = tablaDatos.Select("text = '" + extension + "'"); if (changeRow.Length <= 0) { try { ExtensionArchivo e = new ExtensionArchivo(0, extension.ToUpper(), descripcion); i.IUDextensionArchivo(e, 2); this.RadWindowManager1.RadAlert("Valor agregado correctamente", 400, 200, Utilities.windowTitle(TypeMessage.information_message), null, Utilities.pathImageMessage(TypeMessage.information_message)); cargarGrilla(); } catch(Exception ex) { Logger.generarLogError(ex.Message, new System.Diagnostics.StackFrame(true), ex); this.RadWindowManager1.RadAlert(Utilities.errorMessage(),400,200,Utilities.windowTitle(TypeMessage.error_message), null, Utilities.pathImageMessage(TypeMessage.error_message)); } } else { this.RadWindowManager1.RadAlert("La extension que inteta agregar, ya existe",400,200,Utilities.windowTitle(TypeMessage.information_message), null,Utilities.pathImageMessage(TypeMessage.information_message)); } } else { Int16 idExtension = Convert.ToInt16(g.GetDataKeyValue("value")); try { ExtensionArchivo e = new ExtensionArchivo(idExtension, extension.ToUpper(), descripcion); i.IUDextensionArchivo(e, 3); this.RadWindowManager1.RadAlert("Valor actualizado correctamente", 400, 200, Utilities.windowTitle(TypeMessage.information_message), null, Utilities.pathImageMessage(TypeMessage.information_message)); cargarGrilla(); } catch(Exception ex) { Logger.generarLogError(ex.Message, new System.Diagnostics.StackFrame(true), ex); this.RadWindowManager1.RadAlert(Utilities.errorMessage(),400,200,Utilities.windowTitle(TypeMessage.error_message), null, Utilities.pathImageMessage(TypeMessage.error_message)); } } }
private void eliminarRegisgtro(GridEditableItem g) { Consulta c = new Consulta(); int idCruce = Convert.ToInt32(g.GetDataKeyValue("id_cruce_afiliado")); int idColumna = Convert.ToInt32(g.GetDataKeyValue("id_cruce_columna")); try { RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta c1 = new RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta(); InsertUpdateDelete i = new InsertUpdateDelete(c1.consultarUsuarioXnombre(User.Identity.Name)); CruceAfiliadoColumna c2 = c.consultarCruceAfiliadoColumnaOBJ(idCruce, idColumna); i.IUDcruceAfiliadoColumna(c2, 4); this.RadWindowManager1.RadAlert("Detalle eliminado correctamente", 400, 200, Utilities.windowTitle(TypeMessage.information_message), null, Utilities.pathImageMessage(TypeMessage.information_message)); cargarGrilla(); } catch (Exception ex) { Logger.generarLogError(ex.Message, new System.Diagnostics.StackFrame(true), ex); this.RadWindowManager1.RadAlert(Utilities.errorMessage(), 400, 200, Utilities.windowTitle(TypeMessage.error_message), null, Utilities.pathImageMessage(TypeMessage.error_message)); } }
private void eliminarRegistro(GridEditableItem g) { int idEncGrupo = Convert.ToInt32(g.GetDataKeyValue("id_enc_grupo")); int idGrupo = Convert.ToInt32(g.GetDataKeyValue("id_grupo")); try { Consulta c = new Consulta(); RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta c1 = new RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta(); InsertUpdateDelete i = new InsertUpdateDelete(c1.consultarUsuarioXnombre(User.Identity.Name)); DetalleGrupoDependiente d = c.consultarDetalleGrupoDependenciaOBJ(idGrupo); i.IUDdetGrupoVariableDependiente(d, 4); this.RadWindowManager1.RadAlert("Registro Eliminado Correctamente", 400, 200, Utilities.windowTitle(TypeMessage.information_message), null, Utilities.pathImageMessage(TypeMessage.information_message)); cargarGrilla2(); } catch (Exception ex) { Logger.generarLogError(ex.Message, new System.Diagnostics.StackFrame(true), ex); this.RadWindowManager1.RadAlert(Utilities.errorMessage(), 400, 200, Utilities.windowTitle(TypeMessage.error_message), null, Utilities.pathImageMessage(TypeMessage.error_message)); } }
private void eliminarRegisgtro(GridEditableItem g) { Consulta c = new Consulta(); int idCruce = Convert.ToInt32(g.GetDataKeyValue("id")); if (c.consultarCruceAfiliadoColumna(idCruce, 0).Rows.Count > 0) { this.RadWindowManager1.RadAlert("No se puede eliminar el cruce, existen detalles asociados a esté, favor elimínelos primero " + "antes de eliminar el cruce", 400, 200, Utilities.windowTitle(TypeMessage.information_message), null, Utilities.pathImageMessage(TypeMessage.information_message)); return; } try { RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta c1 = new RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta(); InsertUpdateDelete i = new InsertUpdateDelete(c1.consultarUsuarioXnombre(User.Identity.Name)); CruceAfiliado c2 = c.consultarCruceAfiliadoOBJ(idCruce); i.IUDcruceAfiliado(c2, 4); this.RadWindowManager1.RadAlert("Cruce eliminado correctamente", 400, 200, Utilities.windowTitle(TypeMessage.information_message), null, Utilities.pathImageMessage(TypeMessage.information_message)); cargarGrilla(); } catch (Exception ex) { Logger.generarLogError(ex.Message, new System.Diagnostics.StackFrame(true), ex); this.RadWindowManager1.RadAlert(Utilities.errorMessage(), 400, 200, Utilities.windowTitle(TypeMessage.error_message), null, Utilities.pathImageMessage(TypeMessage.error_message)); } }
private void guardarDatos(UserControl userControl, GridEditableItem g = null) { string codArchivo = this.ddlTipoArchivo.SelectedValue; int numColumna = Convert.ToInt32(this.ddlNumColumna.SelectedValue); Consulta c = new Consulta(); RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta c1 = new RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta(); InsertUpdateDelete i = new InsertUpdateDelete(c1.consultarUsuarioXnombre(User.Identity.Name)); try { EncabezadoGrupoVarDependiente e = new EncabezadoGrupoVarDependiente(); e.datosArchivo = c.consultarEstructuraArchivo(codArchivo, numColumna); e.estado = c.consultarEstadoParametrizacionOBJ(Convert.ToInt16((userControl.FindControl("ddlEstado") as RadDropDownList).SelectedValue)); e.descripcion = (userControl.FindControl("txtDescripcion") as RadTextBox).Text.Trim(); if (g == null) { e.idEncabezadoGrupo = 0; i.IUDencGrupoVariableDependiente(e, 2); } else { e.idEncabezadoGrupo = Convert.ToInt32(g.GetDataKeyValue("id_enc_grupo")); i.IUDencGrupoVariableDependiente(e, 3); } cargarGrilla(); } catch (Exception ex) { Logger.generarLogError(ex.Message, new System.Diagnostics.StackFrame(true), ex); this.RadWindowManager1.RadAlert(Utilities.errorMessage(), 400, 200, Utilities.windowTitle(TypeMessage.error_message), null, Utilities.pathImageMessage(TypeMessage.error_message)); } }
public static void UpdateTouristFromList(List<TouristInfo> lstTourists, int intTerritoryID, GridEditableItem editableItem) { var intTouristId = (int)editableItem.GetDataKeyValue("PolTuristiSaraksts"); var itemTourist = lstTourists.Where(n => n.PolTuristiSaraksts == intTouristId).FirstOrDefault(); if (itemTourist != null) { editableItem.UpdateValues(itemTourist); itemTourist.Apstaklis = ((RadComboBox)editableItem.FindControl("ddlApstaklis")).Text; itemTourist.Apstaklis_ID = Convert.ToInt32(((RadComboBox)editableItem.FindControl("ddlApstaklis")).SelectedValue); itemTourist.IsResident = ((CheckBox)editableItem.FindControl("chkResidents")).Checked; if (itemTourist.IsResident) { itemTourist.DzDatums = null; } else { itemTourist.PersKods = string.Empty; } } }
private void eliminarDatos(GridEditableItem g) { string codArchivo = g.GetDataKeyValue("COD_ARCHIVO").ToString(); int numColumna = int.Parse(g.GetDataKeyValue("NUMERO_COLUMNA").ToString()); int idValPermitido = int.Parse(g.GetDataKeyValue("ID_VAL_PERMITIDO").ToString()); Consulta c = new Consulta(); try { DataTable objDtDatos = c.consultarVariablesDependientes(string.Empty, 0); DataRow[] rows1 = objDtDatos.Select("COD_ARCHIVO_DEP = '" + codArchivo + "' and NUM_COLUMNA_DEP = " + numColumna + " and ID_VAL_PERMITIDO_DEP = " + idValPermitido); DataRow[] rows2 = objDtDatos.Select("COD_ARCHIVO_CRU = '" + codArchivo + "' and NUM_COLUMNA_CRU = " + numColumna + " and ID_VAL_PERMITIDO_CRU = " + idValPermitido); if (rows1.Length > 0) { this.RadWindowManager1.RadAlert("No se puede eliminar el registro, este esta asociado en variables dependientes, primero " + "debe eliminarlo de variables dependientes para poder realizar esta operación", 400, 200, Utilities.windowTitle(TypeMessage.information_message), null, Utilities.pathImageMessage(TypeMessage.information_message)); return; } if (rows2.Length > 0) { this.RadWindowManager1.RadAlert("No se puede eliminar el registro, este esta asociado en variables dependientes, primero " + "debe eliminarlo de variables dependientes para poder realizar esta operación", 400, 200, Utilities.windowTitle(TypeMessage.information_message), null, Utilities.pathImageMessage(TypeMessage.information_message)); return; } DatosEstructuraArchivo d = c.consultarDatosEstructuraArchivoOBJ(idValPermitido, codArchivo, numColumna); RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta c1 = new RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta(); InsertUpdateDelete i = new InsertUpdateDelete(c1.consultarUsuarioXnombre(User.Identity.Name)); i.IUDdatosEstructuraAcrchivo(d, 4); this.RadWindowManager1.RadAlert("Registro eliminado con exito", 400, 200, Utilities.windowTitle(TypeMessage.information_message), null, Utilities.pathImageMessage(TypeMessage.information_message)); cargarGrilla(); } catch(Exception ex){ Logger.generarLogError(ex.Message, new System.Diagnostics.StackFrame(true), ex); this.RadWindowManager1.RadAlert(Utilities.errorMessage(), 400, 200, Utilities.windowTitle(TypeMessage.error_message), null, Utilities.pathImageMessage(TypeMessage.error_message)); } }
private void eliminarExtensionXarchivo(GridEditableItem g) { Int16 idExtension = Convert.ToInt16(g.GetDataKeyValue("id_extension")); string codArchivo = g.GetDataKeyValue("cod_archivo").ToString(); RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta c = new RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta(); Consulta c1 = new Consulta(); InsertUpdateDelete i = new InsertUpdateDelete(c.consultarUsuarioXnombre(User.Identity.Name)); try { ExtensionXarchivo e = new ExtensionXarchivo(c1.consultarArchivoParametrizado(codArchivo),c1.consultarExtensionesOBJ(idExtension)); i.IUDextensionXarchivo(e, 4); this.RadWindowManager1.RadAlert("Valor eliminado correctamente", 400, 200, Utilities.windowTitle(TypeMessage.information_message), null, Utilities.pathImageMessage(TypeMessage.information_message)); cargarGrilla2(); } catch (Exception ex) { Logger.generarLogError(ex.Message, new System.Diagnostics.StackFrame(true), ex); this.RadWindowManager1.RadAlert(Utilities.errorMessage(), 400, 200, Utilities.windowTitle(TypeMessage.error_message), null, Utilities.pathImageMessage(TypeMessage.error_message)); } }
private void SetupInputManager(GridEditableItem editableItem) { var ddlApstaklisontrol = (RadComboBox)editableItem.FindControl("ddlApstaklis"); MethodTour.FillApstDDL(ddlApstaklisontrol, TouristsApstList, 0, TerritoryID); var DateNo = (RadDatePicker)editableItem.FindControl("dteSpecDatumsNo"); DateNo.MinDate = MinSpecDatumsNo; DateNo.MaxDate = MaxSpecDatumsNo; var DateLi = (RadDatePicker)editableItem.FindControl("dteSpecDatumsLi"); DateLi.MinDate = MinSpecDatumsLi; DateLi.MaxDate = MaxSpecDatumsLi; if (editableItem.ItemIndex > -1) { var intTouristId = (int)editableItem.GetDataKeyValue("PolTuristiSaraksts"); var itemTourist = TouristsList.Where(n => n.PolTuristiSaraksts == intTouristId).FirstOrDefault(); ((RadMaskedTextBox)editableItem.FindControl("txtPersKods")).Visible = itemTourist.IsResident; ((RadDatePicker)editableItem.FindControl("dteDzimDate")).Visible = !itemTourist.IsResident; } }
private void guardarDatos(UserControl userControl, GridEditableItem g = null) { Consulta c = new Consulta(); RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta c1 = new RipsValidadorDao.ConnectionDB.AutenticationProvider.Consulta(); InsertUpdateDelete i = new InsertUpdateDelete(c1.consultarUsuarioXnombre(User.Identity.Name)); string mensaje = string.Empty; try { CruceAfiliado c2 = new CruceAfiliado(); c2.descripcion = (userControl.FindControl("txtDescripcion") as RadTextBox).Text.Trim(); c2.prioridad = Convert.ToInt32((userControl.FindControl("txtPrioridad") as RadNumericTextBox).Text); c2.estado = Convert.ToInt16((userControl.FindControl("ddlEstado") as RadDropDownList).SelectedValue); if (validarPrioridad(c2.prioridad)) { if (g == null) { c2.id = 0; i.IUDcruceAfiliado(c2, 2); mensaje = "Datos Guardados Correctamente"; } else { c2.id = Convert.ToInt32(g.GetDataKeyValue("id")); i.IUDcruceAfiliado(c2, 3); mensaje = "Datos Actualizados Correctamente"; } cargarGrilla(); this.RadWindowManager1.RadAlert(mensaje, 400, 200, Utilities.windowTitle(TypeMessage.information_message), null, Utilities.pathImageMessage(TypeMessage.information_message)); } else { this.RadWindowManager1.RadAlert("La prioridad seleccionada para el cruce ya existe, por favor seleccione otro nivel de prioridad", 400, 200, Utilities.windowTitle(TypeMessage.information_message), null, Utilities.pathImageMessage(TypeMessage.information_message)); } } catch (Exception ex) { Logger.generarLogError(ex.Message, new System.Diagnostics.StackFrame(true), ex); this.RadWindowManager1.RadAlert(Utilities.errorMessage(), 400, 200, Utilities.windowTitle(TypeMessage.error_message), null, Utilities.pathImageMessage(TypeMessage.error_message)); } }