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