public static void CrearValidador(GridEditableItem item, string editorColumna, string idControl)
{
var editor = (GridTextBoxColumnEditor)item.EditManager.GetColumnEditor(editorColumna);
var cell = (TableCell)editor.TextBoxControl.Parent;
var validator = new RequiredFieldValidator();
editor.TextBoxControl.ID = idControl;
validator.ControlToValidate = editor.TextBoxControl.ID;
validator.Display = ValidatorDisplay.Dynamic;
validator.ErrorMessage = @"<span style='display: inline; float: right'><img src='../Imagenes/Controles/imgError.gif' title='Este campo es requerido.' alt='' /></span>";
cell.Controls.Add(validator);
}
public void HideErrorMessage(GridEditableItem item)
{
Panel pnlErrorMessage = item.FindControl("pnlErrorMessage") as Panel;
Literal ltErrorMessage = item.FindControl("ltErrorMessage") as Literal;
if (pnlErrorMessage != null &&
ltErrorMessage != null)
{
pnlErrorMessage.Visible = false;
ltErrorMessage.Text = string.Empty;
}
}
public void ShowErrorMessage(GridEditableItem item, string errorMessage)
{
Panel pnlErrorMessage = item.FindControl("pnlErrorMessage") as Panel;
Literal ltErrorMessage = item.FindControl("ltErrorMessage") as Literal;
if (pnlErrorMessage != null &&
ltErrorMessage != null)
{
pnlErrorMessage.Visible = true;
ltErrorMessage.Text = errorMessage;
}
}
public override void FillValues(System.Collections.IDictionary newValues, GridEditableItem editableItem)
{
string controlIDName = "chb" + base.UniqueName;
foreach (TableCell cell in editableItem.Cells)
{
CheckBox chb = (CheckBox)cell.FindControl(controlIDName);
if (null != chb)
{
string strValue = chb.Checked ? this.CheckedValue : this.UnCheckedValue;
object value = strValue.ConvertTo(this.TargetDataType);//validation
if (value != null)
newValues[base.DataField] = value;
break;
}
}
}
public override void FillValues(System.Collections.IDictionary newValues, GridEditableItem editableItem)
{
string controlIDName = "txt" + base.UniqueName;
TextBox txt = null;
foreach (TableCell cell in editableItem.Cells)
{
txt = (TextBox)cell.FindControl(controlIDName);
if (null != txt)
break;
}
if (null != txt)
{
object value = txt.Text.ConvertTo(this.TargetDataType);//validation
if (value != null)
newValues[base.DataField] = value;
}
}
protected void grdSurvey_UpdateCommand(object sender, GridCommandEventArgs e)
{
try
{
GridEditableItem editedItem = e.Item as GridEditableItem;
string s = "Select COUNT(*) From SpecPriorityByLineTemp Where (Deleted IS NULL OR Deleted = 0) AND LineID = " + ((RadDropDownList)(editedItem["LineName"].Controls[1])).SelectedValue;
s += " AND SpecialtyID = " + ((RadDropDownList)(editedItem["SpecialityCode"].Controls[1])).SelectedValue;
SqlCommand cmd = new SqlCommand(s, new SqlConnection(dsSaving.ConnectionString));
cmd.Connection.Open();
int i = int.Parse(cmd.ExecuteScalar().ToString());
if (i > 1)
{
lblStatus.Text = "This transaction is already exist";
return;
}
dsSaving.UpdateParameters[0].DefaultValue = ((Label)(editedItem["RecID"].Controls[1])).Text;
dsSaving.UpdateParameters[1].DefaultValue = ((RadDropDownList)(editedItem["LineName"].Controls[1])).SelectedValue;
dsSaving.UpdateParameters[2].DefaultValue = ((RadDropDownList)(editedItem["SpecialityCode"].Controls[1])).SelectedValue;
dsSaving.UpdateParameters[3].DefaultValue = ((TextBox)(editedItem["SpecValue"].Controls[1])).Text;
if ((((CheckBox)(editedItem["Deleted"].Controls[1])).Checked).ToString() == "True")
{
dsSaving.UpdateParameters[4].DefaultValue = Boolean.TrueString;
}
else
{
dsSaving.UpdateParameters[4].DefaultValue = Boolean.FalseString;
}
dsSaving.Update();
lblStatus.Text = "Updated Successfully";
}
catch (Exception ex)
{
lblStatus.Text = "Update Failed: " + ex.Message;
}
}
protected void RadProjectGrid_InsertCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
RadComboBox rcbOwner = item.FindControl("rcbOwner") as RadComboBox;
int ownerId = Convert.ToInt32(rcbOwner.SelectedValue);
String name = (item.FindControl("tbName") as RadTextBox).Text;
String description = (item.FindControl("tbDescription") as RadTextBox).Text;
DateTime?startDate = (e.Item.FindControl("RadDatePickerStartDate") as RadDatePicker).SelectedDate;
DateTime?dueDate = (e.Item.FindControl("RadDatePickerEndDate") as RadDatePicker).SelectedDate;
Project project = new Project();
project.ownerId = ownerId;
project.name = name;
project.description = description;
project.startDate = startDate;
project.dueDate = dueDate;
_db.Projects.Add(project);
_db.SaveChanges();
}
protected void gvTipoVisa_DeleteCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem editColumn = (GridEditableItem)e.Item;
int idToDelete = Convert.ToInt32(e.Item.OwnerTableView.DataKeyValues[editColumn.ItemIndex]["ID"]);
TipoVisaBll objBllSave = new TipoVisaBll();
TipoVisa objEntity = new TipoVisa();
objEntity.Id = idToDelete;
objEntity.IdUltimaModificacion = this.IdUserCurrent;
if (!objBllSave.Delete(objEntity))
{
this.gvTipoVisa.Rebind();
string mensaje = string.Format("{0}", objBllSave.Error);
erroresCarga.Text = mensaje;
}
else
{
this.gvTipoVisa.Rebind();
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
//store the changed values from grid to dataset
StoreValuesToDataSet();
GridTableView grdTableVw = grdImportDetails.MasterTableView;
GridDataItemCollection itemCollection = grdTableVw.Items;
foreach (GridItem gridItem in itemCollection)
{
if (!(gridItem is GridEditableItem))
{
continue;
}
GridEditableItem item = gridItem as GridEditableItem;
HtmlInputCheckBox chkSelected = item["DeleteCol"].FindControl("chkDeleteCol") as HtmlInputCheckBox;
if (chkSelected == null)
{
continue;
}
if (!chkSelected.Checked)
{
continue;
}
int idRow = ApplicationConstants.INT_NULL_VALUE;
if (int.TryParse(item["RowNumber"].Text, out idRow))
{
DataRow[] dr = DsLogs.Tables[0].Select("IdImport=" + IdImport + " and IdRow=" + idRow);
dr[0].Delete();
}
}
}
catch (Exception ex)
{
ShowError(new IndException(ex));
}
}
protected void grid_ItemDetail_UpdateCommand(object source, GridCommandEventArgs e)
{
int RowID = e.Item.DataSetIndex;
GridEditableItem editedItem = e.Item as GridEditableItem;
DataTable dt_ItemLines = (DataTable)Session["dt_ItemLines"];
decimal Quantity = Convert.ToDecimal(((RadNumericTextBox)editedItem["Quantity"].FindControl("tbQuantity")).Text.Trim());
decimal Amount = Convert.ToDecimal(((RadNumericTextBox)editedItem["Amount"].FindControl("tbAmount")).Text.Trim());
dt_ItemLines.Rows[RowID]["Quantity"] = Quantity;
dt_ItemLines.Rows[RowID]["Amount"] = Amount;
if (dt_ItemLines.Rows[RowID]["Edit"].ToString() == "")
{
dt_ItemLines.Rows[RowID]["Edit"] = "Update";
Session["dt_ItemLines"] = dt_ItemLines;
}
CalculateMRC(12);
grid_ItemDetail.Rebind();
}
// client side validation function for shift detail form input controls
public void ValidateShiftDetail(GridItemEventArgs e)
{
GridEditableItem editForm = (GridEditableItem)e.Item;
ImageButton update = (ImageButton)editForm.FindControl("UpdateButton");
ImageButton insert = (ImageButton)editForm.FindControl("PerformInsertButton");
RadComboBox ddlDayType = (editForm.FindControl("ddlDayType") as RadComboBox);
RadTimePicker tpkrTimeIn = (editForm.FindControl("tpkrTimeIn") as RadTimePicker);
RadTimePicker tpkrTimeOut = (editForm.FindControl("tpkrTimeOut") as RadTimePicker);
RadTimePicker tpkrLateArrival = (editForm.FindControl("tpkrLateArrival") as RadTimePicker);
RadTimePicker tpkrLeaveEarly = (editForm.FindControl("tpkrLeaveEarly") as RadTimePicker);
RadTimePicker tpkrOvertimeStart = (editForm.FindControl("tpkrOvertimeStart") as RadTimePicker);
RadTimePicker tpkrNightShiftStart = (editForm.FindControl("tpkrNightShiftStart") as RadTimePicker);
if (update != null)
{
update.Attributes.Add("onclick", "return ValidateShiftDetail('" +
ddlDayType.ClientID + "','" +
tpkrTimeIn.ClientID + "','" +
tpkrTimeOut.ClientID + "','" +
tpkrLateArrival.ClientID + "','" +
tpkrLeaveEarly.ClientID + "','" +
tpkrOvertimeStart.ClientID + "','" +
tpkrNightShiftStart.ClientID
+ "')");
}
if (insert != null)
{
insert.Attributes.Add("onclick", "return ValidateShiftDetail('" +
ddlDayType.ClientID + "','" +
tpkrTimeIn.ClientID + "','" +
tpkrTimeOut.ClientID + "','" +
tpkrLateArrival.ClientID + "','" +
tpkrLeaveEarly.ClientID + "','" +
tpkrOvertimeStart.ClientID + "','" +
tpkrNightShiftStart.ClientID
+ "')");
}
}
protected void RadGrid1_UpdateCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem gei = e.Item as GridEditableItem;
string Id = (gei["IdUnique"].FindControl("IdLabel") as Label).Text;
string Name = (gei["NameUnique"].FindControl("NameTextBox") as TextBox).Text;
string Job = (gei["JobUnique"].FindControl("JobTextBox") as TextBox).Text;
string Salary = (gei["SalaryUnique"].FindControl("SalaryTextBox") as TextBox).Text;
//string Manager = (gei["ManagerNameUnique"].FindControl("ManagerTextBox") as TextBox).Text;
string Manager = (gei["ManagerNameUnique"].
FindControl("ManagerRadComboBox") as RadComboBox).SelectedValue;
EmployeeDataContract edc = GetAppropriateDataObject();
edc.Employees = (edc.Employees.Select(item =>
{
Employee emp = item;
if (item.Id.ToString() == Id)
{
if (item.ManagerName != Manager)
{
emp.ManagerName = Manager;
}
if (item.Job != Job)
{
emp.Job = Job;
}
if (item.Name != Name)
{
emp.Name = Name;
}
if (item.Salary.ToString() != Salary)
{
emp.Salary = double.Parse(Salary);
}
}
return(emp);
})).ToList <Employee>();
Session["data"] = edc;
}
protected void rgAbsentReason_ItemCreated(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
try
{
if (e.Item is GridEditableItem && e.Item.IsInEditMode)
{
GridEditableItem item = e.Item as GridEditableItem;
if (item != null)
{
TextBox txtName = item["Reason"].FindControl("txtReason") as TextBox;
if (txtName != null)
{
TableCell cell = (TableCell)txtName.Parent;
RequiredFieldValidator validator = new RequiredFieldValidator();
if (cell != null)
{
txtName.ID = "txtReason";
validator.ControlToValidate = txtName.ID;
validator.ErrorMessage = "Please Enter Reason\n";
validator.SetFocusOnError = true;
validator.Display = ValidatorDisplay.None;
}
ValidationSummary validationsum = new ValidationSummary();
validationsum.ID = "validationsum1";
validationsum.ShowMessageBox = true;
validationsum.ShowSummary = false;
validationsum.DisplayMode = ValidationSummaryDisplayMode.SingleParagraph;
cell.Controls.Add(validator);
cell.Controls.Add(validationsum);
}
}
}
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.AbsentReason, "rgAbsentReason_ItemCreated", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
}
}
protected void rdPreguntaRanking_UpdateCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)
{
GridEditableItem editedItem = e.Item as GridEditableItem;
string sCodPregRanking = editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["cod_preg_ranking"].ToString();
string sPregRanking = (editedItem["PregRanking"].Controls[0] as TextBox).Text;
try
{
DBConn oConn = new DBConn();
if (oConn.Open())
{
AppPregRanking oPregRanking = new AppPregRanking(ref oConn);
oPregRanking.CodPregRanking = sCodPregRanking;
oPregRanking.PregRanking = sPregRanking;
oPregRanking.Accion = "EDITAR";
oPregRanking.Put();
if (string.IsNullOrEmpty(oPregRanking.Error))
{
oPregRanking.SerializaTblPregRanking(ref oConn, Server.MapPath(".") + @"\binary\");
}
else
{
rdPreguntaRanking.Controls.Add(new LiteralControl("Unable to insert Employee. Reason: " + oPregRanking.Error));
e.Canceled = true;
}
oConn.Close();
}
else
{
rdPreguntaRanking.Controls.Add(new LiteralControl("Unable to insert Employee. Reason: " + oConn.Error));
e.Canceled = true;
}
}
catch (Exception ex)
{
rdPreguntaRanking.Controls.Add(new LiteralControl("Unable to insert Employee. Reason: " + ex.Message));
e.Canceled = true;
}
}
protected void UpdateRoles(GridEditableItem editedItem)
{
long idRol = Convert.ToInt64(ViewState["idsel"]);
SegRol _Rol = (from c in Contexto.SegRol where c.IdSegRol == idRol select c).FirstOrDefault();
if (_Rol != null)
{
GridEditManager editMan = editedItem.EditManager;
string Login = (editedItem.FindControl("LoginTextBox") as TextBox).Text;
try
{
_Rol.Descripcion = Login;
Contexto.SaveChanges();
this.grillaRoles.Rebind();
}
catch (Exception e)
{
ScriptManager.RegisterStartupScript(UpdPnlGrilla, typeof(UpdatePanel), "Error Grabacion", "alert(" + e.Message + ")", true);
}
}
}
// client side validation function for premium type master input form
public void ValidateHoursType(GridItemEventArgs e)
{
GridEditableItem editForm = (GridEditableItem)e.Item;
ImageButton update = (ImageButton)editForm.FindControl("UpdateButton");
ImageButton insert = (ImageButton)editForm.FindControl("PerformInsertButton");
RadTextBox txthourtypecode = (editForm.FindControl("txthourtypecode") as RadTextBox);
RadTextBox txthourtypedescription = (editForm.FindControl("txthourtypedescription") as RadTextBox);
RadTextBox txthourtypedescription2 = (editForm.FindControl("txthourtypedescription2") as RadTextBox);
CheckBox cbSpecVal = (editForm.FindControl("cbSpecVal") as CheckBox);
RadNumericTextBox txtfromval = (editForm.FindControl("txtfromval") as RadNumericTextBox);
RadNumericTextBox txttoval = (editForm.FindControl("txttoval") as RadNumericTextBox);
RadNumericTextBox txtdefval = (editForm.FindControl("txtdefval") as RadNumericTextBox);
if (update != null)
{
update.Attributes.Add("onclick", "return ValidateHoursType('" +
txthourtypecode.ClientID + "','" +
txthourtypedescription.ClientID + "','" +
txthourtypedescription2.ClientID + "','" +
cbSpecVal.ClientID + "','" +
txtfromval.ClientID + "','" +
txttoval.ClientID + "','" +
txtdefval.ClientID
+ "')");
}
if (insert != null)
{
insert.Attributes.Add("onclick", "return ValidateHoursType('" +
txthourtypecode.ClientID + "','" +
txthourtypedescription.ClientID + "','" +
txthourtypedescription2.ClientID + "','" +
cbSpecVal.ClientID + "','" +
txtfromval.ClientID + "','" +
txttoval.ClientID + "','" +
txtdefval.ClientID
+ "')");
}
}
private void RestoreSelectedItems()
{
Dictionary <int, bool> selectedItems = SessionManager.GetSessionValueNoRedirect(this, SELECTED_ITEMS) as Dictionary <int, bool>;
if (selectedItems == null)
{
return;
}
foreach (KeyValuePair <int, bool> pair in selectedItems)
{
int idAssociate = pair.Key;
GridTableView grdTableVw = grdFollowUpBudget.MasterTableView;
GridDataItemCollection itemCollection = grdTableVw.Items;
foreach (GridItem gridItem in itemCollection)
{
if (!(gridItem is GridEditableItem))
{
continue;
}
GridEditableItem item = gridItem as GridEditableItem;
//CheckBox chkSelected = item["SelectWPCol"].FindControl("chkWPCol") as CheckBox;
CheckBox chkSelected = item["SelectBudgetCol"].FindControl("chkDeleteCol") as CheckBox;
if (chkSelected == null)
{
continue;
}
int currentAssociate = ApplicationConstants.INT_NULL_VALUE;
if (int.TryParse(item["IdAssociate"].Text, out currentAssociate))
{
if (currentAssociate == idAssociate)
{
chkSelected.Checked = true;
}
}
}
}
}
protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)
{
hidden_EditIndex.Text = e.Item.ItemIndex.ToString();
if (e.CommandName == RadGrid.CancelCommandName)
{
hidden_EditIndex.Text = "";
}
if (e.CommandName == RadGrid.EditCommandName)
{
string tempID = e.Item.OriginalClientID;
hidden_EditComboBoxID.Text = tempID + "_RadComboBox1";
}
if (e.CommandName == RadGrid.InitInsertCommandName)
{
e.Canceled = true;
//添加 设置默认值
System.Collections.Specialized.ListDictionary newValues = new System.Collections.Specialized.ListDictionary();
newValues["Amount"] = "2.22";
//Insert the item and rebind
e.Item.OwnerTableView.InsertItem(newValues);
GridEditableItem insertedItem = e.Item.OwnerTableView.GetInsertItem();
RadComboBox Txt_SubjectName = insertedItem.FindControl("RadComboBox1") as RadComboBox;
hidden_EditComboBoxID.Text = Txt_SubjectName.ClientID;
}
//if (e.CommandName == RadGrid.InitInsertCommandName)
//{
// e.Canceled = true;
// e.Item.OwnerTableView.InsertItem();
// GridEditableItem insertedItem = e.Item.OwnerTableView.GetInsertItem();
// TextBox Txt_SubjectName = insertedItem.FindControl("Txt_SubjectName") as TextBox;
// Txt_SubjectName.Text = hidden_SelectedSubjectName.Text;
//}
}
protected void rGridTrade_UpdIns(object sender, GridCommandEventArgs e, string Action)
{
try
{
GridEditableItem eeditedItem = e.Item as GridEditableItem;
TradeDomainModel TradeDM = new TradeDomainModel();
if (Action == "Update")
{
TradeDM.TradeGUID = new Guid((eeditedItem.FindControl("lblTradeGUID") as Label).Text.ToString());
}
TradeDM.SeasonID = Convert.ToInt32((eeditedItem.FindControl("rDDSeason") as RadDropDownList).SelectedValue.ToString());
RadCalendar rCal = (RadCalendar)eeditedItem.FindControl("rCALProposedDate");
TradeDM.ProposedDate = rCal.SelectedDate;
TradeDM.TeamID = Convert.ToInt32((eeditedItem.FindControl("rDDTeam") as RadDropDownList).SelectedValue.ToString());
TradeDM.TradeStatusID = Convert.ToInt32((eeditedItem.FindControl("rDDTradeStatus") as RadDropDownList).SelectedValue.ToString());
if (Action == "Update")
{
TradeBLL.UpdateTrade(TradeDM);
}
else if (Action == "Insert")
{
TradeBLL.InsertTrade(TradeDM);
}
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
string errMethod = sf.GetMethod().Name.ToString(); // Get the current method name
string errMsg = "600"; // Gotta pass something, we're retro-fitting an existing method
Session["LastException"] = ex; // Throw the exception in the session variable, will be used in error page
string url = string.Format(ConfigurationManager.AppSettings["ErrorPageURL"], errMethod, errMsg); //Set the URL
Response.Redirect(url); // Go to the error page.
}
}
protected void dropdownImportance_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
RadComboBox dropdownImportance = (RadComboBox)sender;
GridEditableItem editedItem = (GridEditableItem)dropdownImportance.NamingContainer;
RadComboBox dropdownNeedAtEntry = editedItem.FindControl("dropdownNeedAtEntry") as RadComboBox;
RadComboBox dropdownDistinguishingValue = editedItem.FindControl("dropdownDistinguishingValue") as RadComboBox;
long jQFactorID = (long)editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["JQFactorID"];
JobAnalysisDutyKSAFactor currentKSAFactor = new JobAnalysisDutyKSAFactor(jQFactorID);
if (currentKSAFactor != null)
{
if (dropdownImportance.SelectedValue != "")
{
currentKSAFactor.ImportanceID = (enumImportanceScale)ControlUtility.GetDropdownValue(dropdownImportance);
}
if (dropdownNeedAtEntry.SelectedValue != "")
{
currentKSAFactor.NeedAtEntryID = (enumNeedAtEntryScale)ControlUtility.GetDropdownValue(dropdownNeedAtEntry);
}
if (dropdownDistinguishingValue.SelectedValue != "")
{
currentKSAFactor.DistinguishingValueScaleID = (enumDistinguishingValueScale)ControlUtility.GetDropdownValue(dropdownDistinguishingValue);
}
currentKSAFactor.UpdatedByID = base.CurrentUserID;
currentKSAFactor.UpdateScaleAndFinalInformation();
bindData();
}
}
catch (Exception ex)
{
base.HandleException(ex);
}
}
protected void rgHospitals_InsertCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
Data.Hospital h = new Data.Hospital();
try
{
h.hospital_nm = (item.FindControl("tbHospitalNm") as TextBox).Text;
h.street_addrs = (item.FindControl("tbStreetAddrs1") as TextBox).Text;
h.city = (item.FindControl("tbCity1") as TextBox).Text;
h.state = (item.FindControl("tbState1") as TextBox).Text;
h.zip = (item.FindControl("tbZip1") as TextBox).Text;
h.ph_no = (item.FindControl("tbPhoneNo1") as TextBox).Text;
h.dec_lat_va = Convert.ToDouble((item.FindControl("tbLat") as TextBox).Text);
h.dec_long_va = Convert.ToDouble((item.FindControl("tbLong") as TextBox).Text);
h.wsc_id = WSCID;
}
catch (Exception ex)
{
DisplayHospitalMessage(true, "You must complete all form fields!");
e.Canceled = true;
return;
}
try
{
db.Hospitals.InsertOnSubmit(h);
db.SubmitChanges();
DisplayHospitalMessage(false, "The hospital was added!");
}
catch (Exception ex)
{
DisplayHospitalMessage(true, "Unable to add hospital. Reason: " + ex.Message);
e.Canceled = true;
}
}
protected void rgShoppingList_UpdateCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
{
GridEditableItem item = (GridEditableItem)e.Item;
RadTextBox code = (RadTextBox)item.FindControl("hdrcodetxt");
RadTextBox notes = (RadTextBox)item.FindControl("notes");
RadDatePicker transdate = (RadDatePicker)item.FindControl("transdate");
RadNumericTextBox amount = (RadNumericTextBox)item.FindControl("amount");
string id = code.Text;
string notess = notes.Text;
DateTime transdates = Convert.ToDateTime(transdate.SelectedDate);
Double amounts = Convert.ToDouble(amount.Text);
if (notess == "")
{
ShowMessage("Notes Cannot be empty");
return;
}
//var validateprodcode = validatetransaction(prodcode);
//if (validateprodcode.Rows.Count > 0)
//{
// ShowMessage("already used in transaction");
// return;
//}
if (amounts == 0)
{
ShowMessage("Please fill amount");
return;
}
if (transdate.SelectedDate == null)
{
ShowMessage("Please fill transaction date");
return;
}
update(notess, amounts, transdates, id);
}
protected void InsertPlanilla(GridEditableItem editedItem)
{
long idPlanilla = Convert.ToInt64(ViewState["idsel"]);
#region Recupero los Datos Ingresado por el usuario
GridEditManager editMan = editedItem.EditManager;
string codigo_Ingresado = (editMan.GetColumnEditor("Codigo") as GridTextBoxColumnEditor).Text;
string Descripcion_Ingresado = (editMan.GetColumnEditor("Descripcion") as GridTextBoxColumnEditor).Text;
string Categoria_Ingresado = (editMan.GetColumnEditor("IdCategoria") as GridDropDownColumnEditor).SelectedValue;
string Riesgo_Ingresado = ((RadComboBox)editedItem.FindControl("cboRiesgos")).SelectedValue;
string Grado_Ingresado = ((RadComboBox)editedItem.FindControl("cboGrados")).SelectedValue;
string Rol_Ingresado = ((RadComboBox)editedItem.FindControl("cboRoles")).SelectedValue;
#endregion
try
{
Plantilla _ItemPlanilla = new Plantilla();
_ItemPlanilla.Codigo = codigo_Ingresado;
_ItemPlanilla.Descripcion = Descripcion_Ingresado;
_ItemPlanilla.IdCategoria = long.Parse(Categoria_Ingresado);
_ItemPlanilla.Riesgo = Riesgo_Ingresado;
_ItemPlanilla.Grado = int.Parse(Grado_Ingresado);
RolesPlanilla _rolPlantilla = new RolesPlanilla();
_rolPlantilla.IdRol = long.Parse(Rol_Ingresado);
_rolPlantilla.Plantilla = _ItemPlanilla;
_ItemPlanilla.RolesPlanilla.Add(_rolPlantilla);
Contexto.AddToPlantilla(_ItemPlanilla);
Contexto.SaveChanges();
this.RadGrid1.Rebind();
}
catch (Exception e)
{
ScriptManager.RegisterStartupScript(updpnlGrilla, typeof(UpdatePanel), "Error Grabacion", "alert(" + e.Message + ")", true);
}
}
//***
//*** RadGridBoxes_ItemCreated
protected void RadGridBoxes_ItemCreated(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
try
{
if (e.Item is GridEditableItem && e.Item.IsDataBound)
{
if (e.Item is GridEditFormInsertItem || e.Item is GridDataInsertItem) // insert item
{
RadGridBoxes.MasterTableView.GetColumn("EditCommandColumn").Display = true;
RadGridBoxes.MasterTableView.GetColumn("edit").Display = false;
GridEditableItem item = e.Item as GridEditableItem;
RadDatePicker add_po_dateRDP = (RadDatePicker)item.FindControl("add_po_dateRDP");
add_po_dateRDP.SelectedDate = DateTime.Now;
RadComboBox add_item_idRCB = (RadComboBox)item.FindControl("add_item_idRCB");
ArrayList fields = new ArrayList();
fields.Add("item_id");
fields.Add("item_name");
Dictionary <string, string> conditions = new Dictionary <string, string>();
conditions.Add("active", "true");
using (SqlConnection con = new SqlConnection(Controller.connection))
{
using (SqlCommand cmd = new SqlCommand())
{
con.Open();
add_item_idRCB.DataSource = Controller.SelectFrom(cmd, con, "CNRS_Item", fields, conditions, new ArrayList(), false, false, "");
add_item_idRCB.DataBind();
}
}
}
}
}
catch (Exception ex)
{
Controller.SaveErrors(Path.GetFileName(Request.PhysicalPath), ex.Message, System.Reflection.MethodInfo.GetCurrentMethod().Name);
}
}
// client side validation function for premium type master input form
public void ValidateExpenseType(GridItemEventArgs e)
{
GridEditableItem editForm = (GridEditableItem)e.Item;
//ImageButton update = (ImageButton)editForm.FindControl("UpdateButton");
ImageButton insert = (ImageButton)editForm.FindControl("PerformInsertButton");
RadTextBox txtexptcod = (editForm.FindControl("txtexptcod") as RadTextBox);
RadTextBox txtexpttitle = (editForm.FindControl("txtexpttitle") as RadTextBox);
CheckBox cbSpecVal = (editForm.FindControl("cbSpecVal") as CheckBox);
RadNumericTextBox txtfromval = (editForm.FindControl("txtfromval") as RadNumericTextBox);
RadNumericTextBox txttoval = (editForm.FindControl("txttoval") as RadNumericTextBox);
RadComboBox ddlMeasurmentType = (editForm.FindControl("ddlMeasurmentType") as RadComboBox);
RadTextBox txtUnitType = (editForm.FindControl("txtUnitType") as RadTextBox);
RadNumericTextBox txtUnitValue = (editForm.FindControl("txtUnitValue") as RadNumericTextBox);
//if (update != null)
//{
// update.Attributes.Add("onclick", "return ValidateExpenseType('" +
// txtexptcod.ClientID + "','" +
// txtexpttitle.ClientID
// + "')");
//}
if (insert != null)
{
insert.Attributes.Add("onclick", "return ValidateExpenseType('" +
txtexptcod.ClientID + "','" +
txtexpttitle.ClientID + "','" +
cbSpecVal.ClientID + "','" +
ddlMeasurmentType.ClientID + "','" +
txtUnitType.ClientID + "','" +
txtUnitValue.ClientID + "','" +
txtfromval.ClientID + "','" +
txttoval.ClientID
+ "')");
}
}
protected void grdBranches_ItemCommand(object source, GridCommandEventArgs e)
{
txtError.Text = string.Empty;
if (e.CommandName == RadGrid.InitInsertCommandName)
{
Response.Redirect("AddBranch.aspx");
}
else if (e.CommandName == RadGrid.EditCommandName)
{
GridEditableItem item = e.Item as GridEditableItem;
int id = (int)item.GetDataKeyValue("BranchID");
Response.Redirect("AddBranch.aspx?id=" + id);
}
else if (e.CommandName == RadGrid.DeleteCommandName)
{
GridEditableItem item = e.Item as GridEditableItem;
int id = (int)item.GetDataKeyValue("BranchID");
Branch bb = (from b in entities.Branches
where b.BranchID == id
select b).FirstOrDefault();
if (bb != null)
{
if (bb.ProductsInBranches.Count == 0)
{
using (TransactionScope transaction = new TransactionScope())
{
entities.Branches.Remove(bb);
entities.SaveChanges();
transaction.Complete();
}
}
else
{
txtError.Text = "You cannot delete Branch because this branch is linked with product(s).";
}
}
}
}
protected void rgNotaCargoEspecialDet_UpdateCommand(object sender, GridCommandEventArgs e)
{
NotaCargoDet facturaDet = new NotaCargoDet();
try
{
GridEditableItem insertedItem = (GridEditableItem)e.Item;
Sesion sesion = (Sesion)Session["Sesion" + Session.SessionID];
facturaDet.Id_Emp = sesion.Id_Emp;
facturaDet.Id_Cd = sesion.Id_Cd_Ver;
facturaDet.Id_Nca = 0; //se debe volver asignar cuando se guarda la orden de compra, cuando actualiza queda igual
facturaDet.Id_NcaDet = 0;
facturaDet.Id_CteExt = Convert.ToInt32(this.HD_Cliente.Value); //cliente de datos generales de la factura
facturaDet.Id_Prd = Convert.ToInt32((insertedItem.FindControl("txtId_Prd") as RadNumericTextBox).Value);
facturaDet.Nca_Importe = Convert.ToDouble((insertedItem.FindControl("txtNca_Importe") as RadNumericTextBox).Value.HasValue ? (insertedItem.FindControl("txtNca_Importe") as RadNumericTextBox).Value : 0);
facturaDet.Clp_Release = (insertedItem.FindControl("txtClp_ReleaseEdit") as RadTextBox).Text;
//datos del producto de la orden de compra
facturaDet.Producto = new Producto();
facturaDet.Producto.Id_Prd = Convert.ToInt32((insertedItem.FindControl("cmbProducto") as RadComboBox).SelectedValue);
facturaDet.Producto.Id_Emp = sesion.Id_Emp;
facturaDet.Producto.Id_Cd = sesion.Id_Cd_Ver;
facturaDet.Producto.Id_PrdEsp = (insertedItem.FindControl("txtId_PrdEsp") as RadTextBox).Text; ///<------
facturaDet.Producto.Prd_Descripcion = (insertedItem.FindControl("cmbProducto") as RadComboBox).Text;
facturaDet.Producto.Prd_DescripcionEspecial = (insertedItem.FindControl("txtPrd_Descripcion") as RadTextBox).Text;
facturaDet.Producto.Prd_Presentacion = (insertedItem.FindControl("txtPrd_Presentacion") as RadTextBox).Text;
facturaDet.Producto.Prd_UniNe = (insertedItem.FindControl("txtPrd_UniNe") as RadTextBox).Text;
//agregar producto de orden de compra a la lista
this.ListaProductosFacturaEspecial_ModificarProducto(facturaDet, e.Item.ItemIndex);
}
catch (Exception ex)
{
string mensaje = string.Concat(ex.Message, "rgFacturaEspecial_insert_error");
this.DisplayMensajeAlerta(mensaje);
}
}
/// <summary>
/// Saves the state of to view.
/// </summary>
/// <param name="item">The item.</param>
private void SaveToViewState(GridEditableItem item)
{
var invoiceShipment = new ShipmentMap();
invoiceShipment.ID = ((DictionaryOnDemandComboBox)item.FindControl("dcbShipments")).SelectedId;
var shipment = _dataManager.Shipment.SelectById(invoiceShipment.ID);
invoiceShipment.CreatedAt = shipment.CreatedAt;
invoiceShipment.ShipmentTypeID = shipment.ShipmentTypeID;
invoiceShipment.Note = shipment.Note;
invoiceShipment.Number = shipment.Number;
if (InvoiceShipmentsList.SingleOrDefault(o => o.ID == invoiceShipment.ID) == null)
{
InvoiceShipmentsList.Add(invoiceShipment);
}
if (InvoiceShipmentsChanged != null)
{
InvoiceShipmentsChanged(this, new EventArgs());
}
}
protected void grdProducts_ItemCreated(object sender, GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
GridEditableItem item = e.Item as GridEditableItem;
Image img = item.FindControl("Image1") as Image;
int id = (int)item.GetDataKeyValue("ProductID");
Product product = (from p in entities.Products
where p.ProductID == id
select p).FirstOrDefault();
if (!product.IsSpecial)
{
item.Cells[0].Text = string.Empty;
}
else if (product.IsSpecial)
{
if (img != null)
{
img.Visible = false;
}
}
}
}
protected void m_dgvGrid_InsertCommand(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_start = DateTime(values["Start"]);
m_end = DateTime(values["End"]);
var exceptionTypeID = Int((e.Item.FindControl("m_cboExceptionTypes") as RadComboBox).SelectedValue);
m_attendanceExceptionType = AttendanceExceptionType(exceptionTypeID);
if (!m_employee.AddAttendanceException(m_start, m_end, m_attendanceExceptionType, String(values["Remarks"])))
{
e.Canceled = true;
DisplayError("Failed to add entry.", m_lblError);
}
}
protected void RadGrid1_InsertCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem gei = e.Item as GridEditableItem;
string _Id = (gei["IdUnique"].FindControl("IdTextBox") as TextBox).Text;
string _Name = (gei["NameUnique"].FindControl("NameTextBox") as TextBox).Text;
string _Job = (gei["JobUnique"].FindControl("JobTextBox") as TextBox).Text;
string _Salary = (gei["SalaryUnique"].FindControl("SalaryTextBox") as TextBox).Text;
string _Manager = (gei["ManagerNameUnique"].
FindControl("ManagerRadComboBox") as RadComboBox).SelectedValue;
EmployeeDataContract edc = GetAppropriateDataObject();
edc.Employees.Add(new Employee()
{
Id = int.Parse(_Id == "" ? "0" : _Id),
Name = _Name ?? "",
Job = _Job ?? "",
Salary = double.Parse(_Salary == "" ? "0" : _Salary),
ManagerName = _Manager ?? ""
});
Session["data"] = edc;
}
protected void RadGrid1_OnInsertCommand(object sender, GridCommandEventArgs e)
{
newValue = new Hashtable();
editableItem = e.Item as GridEditableItem;
e.Item.OwnerTableView.ExtractValuesFromItem(newValue, editableItem);
var presenter = new PMLoaiPhong(this);
var txtgiangay = e.Item.FindControl("txtgiangay") as RadNumericTextBox;
var txtgiadem = e.Item.FindControl("txtgiadem") as RadNumericTextBox;
if (txtgiangay != null)
{
GiaNgay = Convert.ToDecimal(txtgiangay.Text);
}
if (txtgiadem != null)
{
GiaDem = Convert.ToDecimal(txtgiadem.Text);
}
Message = presenter.Inseart() ? "Thêm thành công" : "Thêm thất bại";
if (Message == "Thêm thành công")
{
}
}
protected void RadGrid2_UpdateCommand(object source, GridCommandEventArgs e)
{
GridEditableItem editedItem = e.Item as GridEditableItem;
GridEditManager editMan = editedItem.EditManager;
string criterion_name = editedItem.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["criterion_name"].ToString();
Int32 wt_int;
string wt_str = null;
wt_str = (editedItem.FindControl("TB1") as TextBox).Text;
//wt_str = (editedItem["criterion_weighting"].Controls[0] as TextBox).Text;
//wt_str = (editedItem["TB1"].Controls[0] as TextBox).Text;
wt_int = Int32.Parse(wt_str);
PackPriorityDAO packpriority_dao = new PackPriorityDAO();
Decimal status = packpriority_dao.Update_packpriority(criterion_name, wt_int);
this.Bindgrid();
}
protected void OnItemDataBoundHandler(object sender, GridItemEventArgs e)
{
if (e.Item.IsInEditMode)
{
GridEditableItem item = (GridEditableItem)e.Item;
if (!(e.Item is IGridInsertItem))
{
RadComboBox combo = (RadComboBox)item.FindControl("RadComboBox1");
RadComboBoxItem selectedItem = new RadComboBoxItem();
selectedItem.Text = ((DataRowView)e.Item.DataItem)["CompanyName"].ToString();
selectedItem.Value = ((DataRowView)e.Item.DataItem)["SupplierID"].ToString();
selectedItem.Attributes.Add("ContactName", ((DataRowView)e.Item.DataItem)["ContactName"].ToString());
combo.Items.Add(selectedItem);
selectedItem.DataBind();
Session["SupplierID"] = selectedItem.Value;
}
}
}
/// <summary>
/// Saves the state of to view.
/// </summary>
/// <param name="item">The item.</param>
private void SaveToViewState(GridEditableItem item)
{
var shipmentInvoice = new InvoiceMap();
shipmentInvoice.ID = ((DictionaryOnDemandComboBox)item.FindControl("dcbInvoices")).SelectedId;
var invoice = _dataManager.Invoice.SelectById(shipmentInvoice.ID);
shipmentInvoice.CreatedAt = invoice.CreatedAt;
shipmentInvoice.InvoiceTypeID = invoice.InvoiceTypeID;
shipmentInvoice.Note = invoice.Note;
shipmentInvoice.Number = invoice.Number;
if (ShipmentInvoicesList.SingleOrDefault(o => o.ID == shipmentInvoice.ID) == null)
{
ShipmentInvoicesList.Add(shipmentInvoice);
}
if (ShipmentInvoicesChanged != null)
{
ShipmentInvoicesChanged(this, new EventArgs());
}
}
protected void grdTouristsList_ItemCreated(object sender, GridItemEventArgs e)
{
if (e.Item is GridEditableItem && (e.Item.IsInEditMode))
{
EditableItem = (GridEditableItem)e.Item;
SetupInputManager(EditableItem);
}
}
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 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));
}
}
private void OnViewAssociatedClaims(GridEditableItem[] printedItems)
{
if (this.ViewAssociatedClaims != null)
{
this.ViewAssociatedClaims(this, new EditableGridPrintEventArgs(printedItems));
}
}
private void OnPredeterminedPrintNew(GridEditableItem[] printedItems)
{
if (this.PredeterminedPrintNew != null)
{
this.PredeterminedPrintNew(this, new EditableGridPrintEventArgs(printedItems));
}
}
public EditableGridPrintEventArgs(GridEditableItem[] items)
{
this.m_printedItems = items;
}
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));
}
}
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 OnConfirm(GridEditableItem[] ConfirmItems)
{
if (this.Confirm != null)
{
this.Confirm(this, new EditableGridMoveEventArgs(ConfirmItems));
}
}
private void OnDeleteItem(GridEditableItem editedItem)
{
if (this.Delete != null)
{
this.Delete(this, new EditableGridDeleteEventArgs(editedItem));
}
}
private void OnMoveDown(GridEditableItem[] MovedDownItems)
{
if (this.MoveDown != null)
{
this.MoveDown(this, new EditableGridMoveEventArgs(MovedDownItems));
}
}
private void OnMoveUp(GridEditableItem[] MovedUpItems)
{
if (this.MoveUp != null)
{
this.MoveUp(this, new EditableGridMoveEventArgs(MovedUpItems));
}
}
public EditableGridDeleteEventArgs(GridEditableItem item)
{
this.deletedItem = item;
}
public EditableGridMoveEventArgs(GridEditableItem[] items)
{
this.movedItems = items;
}
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));
}
}
public override void FillValues(System.Collections.IDictionary newValues, GridEditableItem editableItem)
{
string controlIDName = "cbx" + base.UniqueName;
RadDropDownList cbx = null;
foreach (TableCell cell in editableItem.Cells)
{
cbx = (RadDropDownList)cell.FindControl(controlIDName);
if (null != cbx)
break;
}
if (null != cbx)
{
newValues[base.DataField] = cbx.SelectedValue;
}
//base.FillValues(newValues, editableItem);
}
private void OnPrint(GridEditableItem[] printedItems)
{
if (this.Print != null)
{
this.Print(this, new EditableGridPrintEventArgs(printedItems));
}
}
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;
}
}
public void FillEmailAddressLabels(GridEditableItem editItem)
{
UserControl userControl = (UserControl)editItem.FindControl(GridEditFormItem.EditFormUserControlID);
Label lblNotifyAssigneeValue = (Label)userControl.FindControl("lblNotifyAssigneeValue");
Label lblNotifyRequesterValue = (Label)userControl.FindControl("lblNotifyRequesterValue");
Label lblNotifyStandardValue = (Label)userControl.FindControl("lblNotifyStandardValue");
Label lblEmailsSentTo = (Label)userControl.FindControl("lblEmailsSentTo");
RadComboBox ddlAssignedToEdit = (RadComboBox)userControl.FindControl("ddlAssignedToEdit");
RadComboBox ddlRequestedByEdit = (RadComboBox)userControl.FindControl("ddlRequestedByEdit");
RadDropDownList ddlCompanyEdit = (RadDropDownList)userControl.FindControl("ddlCompanyEdit");
RadComboBox ddlNotifyOther = (RadComboBox)userControl.FindControl("ddlNotifyOther");
CheckBox cbNotifyStandard = (CheckBox)userControl.FindControl("cbNotifyStandard");
CheckBox cbNotifyAssignee = (CheckBox)userControl.FindControl("cbNotifyAssignee");
CheckBox cbNotifyRequester = (CheckBox)userControl.FindControl("cbNotifyRequester");
CheckBox cbNotifyOther = (CheckBox)userControl.FindControl("cbNotifyOther");
lblNotifyAssigneeValue.Text = ddlAssignedToEdit.SelectedIndex != -1 ? ddlAssignedToEdit.SelectedItem.Text : "";
lblNotifyRequesterValue.Text = ddlRequestedByEdit.SelectedIndex != -1 ? ddlRequestedByEdit.SelectedItem.Text : "";
lblNotifyStandardValue.Text = ddlCompanyEdit.SelectedText;
List<String> listEmails = new List<String>();
if (cbNotifyStandard.Checked)
{
using (FormContext ctx = new FormContext())
{
if (ctx.EmailAddresses.Any(x => x.Status == 1 && x.TForm.FormName == "Order Cancellation" && x.Company == ddlCompanyEdit.SelectedText))
{
ICollection<EmailAddress> emailAddresses = ctx.EmailAddresses.Where(x => x.Status == 1 && x.TForm.FormName == "Order Cancellation" && x.Company == ddlCompanyEdit.SelectedText).ToList();
if (emailAddresses.Count() > 0)
{
foreach (EmailAddress email in emailAddresses)
{
listEmails.Add(email.Address);
}
}
}
}
}
if (cbNotifyAssignee.Checked)
{
if (lblNotifyAssigneeValue.Text != "")
{
listEmails.Add(lblNotifyAssigneeValue.Text);
}
}
if (cbNotifyRequester.Checked)
{
if (lblNotifyRequesterValue.Text != "")
{
listEmails.Add(lblNotifyRequesterValue.Text);
}
}
if (cbNotifyOther.Checked)
{
var notifyOtherList = ddlNotifyOther.CheckedItems;
if (notifyOtherList.Any())
{
foreach (var item in notifyOtherList)
{
if (item.Text != null)
{
listEmails.Add(item.Text);
}
}
}
}
string emailList = "";
foreach (string email in listEmails)
{
emailList += email + ", ";
}
if (emailList.Length >= 2)
{
if (emailList.Substring(emailList.Length - 2, 2) == ", ")
{
emailList = emailList.Substring(0, emailList.Length - 2);
}
}
lblEmailsSentTo.Text = emailList;
}
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 ChiefComplainceSetupInputManager(GridEditableItem editableItem)
{
try
{
// style DurationYY column's textbox
var textBox = ((GridTextBoxColumnEditor)editableItem.EditManager.GetColumnEditor("DurationYY")).TextBoxControl;
InputSetting inputSetting = ChiefComRadInputManager.GetSettingByBehaviorID("YYNumericTextBoxSetting");
inputSetting.InitializeOnClient = true;
inputSetting.TargetControls.Add(new TargetInput(textBox.UniqueID, true));
inputSetting.Validation.IsRequired = true;
// style DurationMM column's textbox
textBox = ((GridTextBoxColumnEditor)editableItem.EditManager.GetColumnEditor("DurationMM")).TextBoxControl;
inputSetting = ChiefComRadInputManager.GetSettingByBehaviorID("MMNumericTextBoxSetting");
inputSetting.InitializeOnClient = true;
inputSetting.TargetControls.Add(new TargetInput(textBox.UniqueID, true));
inputSetting.Validation.IsRequired = true;
// style DurationDD column's textbox
textBox = ((GridTextBoxColumnEditor)editableItem.EditManager.GetColumnEditor("DurationDD")).TextBoxControl;
inputSetting = ChiefComRadInputManager.GetSettingByBehaviorID("DDNumericTextBoxSetting");
inputSetting.InitializeOnClient = true;
inputSetting.TargetControls.Add(new TargetInput(textBox.UniqueID, true));
inputSetting.Validation.IsRequired = true;
}
catch (System.Exception)
{
ShowErrorMessage();
}
}
private void OnCommandChanged(GridEditableItem dataItem, GridCrudCommandType commandType)
{
EventHandler<GridCrudCommandEventArgs> handler = this.CommandChanged;
if (handler != null)
handler(this, new GridCrudCommandEventArgs(dataItem, commandType));
}
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 TreatmentSetupInputManager(GridEditableItem editableItem)
{
try
{
// style MedQty column's textbox
var textBox = ((GridTextBoxColumnEditor)editableItem.EditManager.GetColumnEditor("MedQty")).TextBoxControl;
InputSetting inputSetting = TreatmentRadInputManager.GetSettingByBehaviorID("MedQtyNumericTextBoxSetting");
inputSetting.InitializeOnClient = true;
inputSetting.TargetControls.Add(new TargetInput(textBox.UniqueID, true));
inputSetting.Validation.IsRequired = true;
}
catch (System.Exception)
{
ShowErrorMessage();
}
}
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
{
CruceAfiliadoColumna c2 = new CruceAfiliadoColumna();
c2.estado = Convert.ToInt16((userControl.FindControl("ddlEstado") as RadDropDownList).SelectedValue);
c2.columnaCruce = c.consultarColumnaCruceOBJ(Convert.ToInt32((userControl.FindControl("ddlColumna") as RadDropDownList).SelectedValue));
c2.cruceAfiliado = c.consultarCruceAfiliadoOBJ(Convert.ToInt32(ViewState["idCruce"]));
if (g == null)
{
if (c.consultarCruceAfiliadoColumnaOBJ(c2.cruceAfiliado.id, c2.columnaCruce.id) == null)
{
i.IUDcruceAfiliadoColumna(c2, 2);
mensaje = "Datos Guardados Correctamente";
}
else
{
this.RadWindowManager1.RadAlert("La columna que intenta asignar al cruce, ya hace parte de esté y no se puede duplicar, Favor seleccionar otra columna",
400, 200, Utilities.windowTitle(TypeMessage.information_message), null, Utilities.pathImageMessage(TypeMessage.information_message));
return;
}
}
else
{
i.IUDcruceAfiliadoColumna(c2, 3);
mensaje = "Datos Actualizados Correctamente";
}
cargarGrilla();
this.RadWindowManager1.RadAlert(mensaje, 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));
}
}
