protected void rgCustomer_UpdateCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
{
GridEditableItem item = (GridEditableItem)e.Item;
RadTextBox code = (RadTextBox)item.FindControl("hdrcodetxt");
RadTextBox name = (RadTextBox)item.FindControl("name");
RadMaskedTextBox phone = (RadMaskedTextBox)item.FindControl("phone");
RadTextBox address = (RadTextBox)item.FindControl("address");
RadTextBox email = (RadTextBox)item.FindControl("email");
string cpcode = code.Text;
string names = name.Text;
string phones = phone.Text;
string addresses = address.Text;
string emails = email.Text;
if (names == "")
{
ShowMessage("Contact Person Name Cannot be empty");
return;
}
update(names, addresses, phones, emails, cpcode);
//update(names, addresses, codetxt, phone1s, phone2s, cpcode);
}
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 rgProduct_UpdateCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
{
GridEditableItem item = (GridEditableItem)e.Item;
RadTextBox code = (RadTextBox)item.FindControl("hdrcodetxt");
RadTextBox catnames = (RadTextBox)item.FindControl("catname");
RadNumericTextBox amount = (RadNumericTextBox)item.FindControl("amt");
string id = code.Text;
string catname = catnames.Text;
int amounts = Convert.ToInt32(amount.Text);
if (string.IsNullOrEmpty(catname))
{
ShowMessage("Category Name 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;
}
update(catname, amounts, id);
}
protected void rGridTeam_UpdateCommand(object sender, GridCommandEventArgs e)
{
try
{
GridEditableItem eeditedItem = e.Item as GridEditableItem;
SeasonTeamPlayerDomainModel STP = new SeasonTeamPlayerDomainModel();
DraftPlayerBusinessLogicLayer DrBLL = new DraftPlayerBusinessLogicLayer();
STP.SeasonID = Convert.ToInt32((eeditedItem.FindControl("lblSeasonID") as Label).Text);
STP.PlayerGUID = new Guid((eeditedItem.FindControl("lblPlayerGUID") as Label).Text);
STP.TeamID = Convert.ToInt32((eeditedItem.FindControl("lblTeamID") as Label).Text);
int NewTeamID = Convert.ToInt32((eeditedItem.FindControl("rDDSeasonTeam") as RadDropDownList).SelectedValue);
int Points = Convert.ToInt32((eeditedItem.FindControl("rNUMPoints") as RadNumericTextBox).Text);
DrBLL.TradePlayer(STP, NewTeamID, Points);
rGridTeam.Rebind();
}
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.
}
}
/// <summary>
/// Saves the state of to view.
/// </summary>
/// <param name="importTagId">The import tag id.</param>
/// <param name="item">The item.</param>
protected void SaveToViewState(Guid importTagId, GridEditableItem item)
{
var importTag = ((List <ImportTagMap>)ViewState["ImportTags"]).FirstOrDefault(a => a.ID == importTagId) ?? new ImportTagMap();
var siteTagId = ((DictionaryOnDemandComboBox)item.FindControl("dcbSiteTags")).SelectedIdNullable;
var siteTagText = ((DictionaryOnDemandComboBox)item.FindControl("dcbSiteTags")).SelectedText;
if (siteTagId.HasValue)
{
importTag.SiteTagID = ((DictionaryOnDemandComboBox)item.FindControl("dcbSiteTags")).SelectedId;
}
else
{
var contactObjectTypeId = _dataManager.ObjectTypes.SelectByName("tbl_Contact").ID;
var newSiteTagId = Guid.NewGuid();
_dataManager.SiteTags.Add(new tbl_SiteTags
{
ID = newSiteTagId,
UserID = CurrentUser.Instance.ID,
SiteID = _siteId,
Name = siteTagText,
ObjectTypeID = contactObjectTypeId
});
importTag.SiteTagID = newSiteTagId;
}
importTag.Operation = ((RadioButtonList)item.FindControl("rblOperation")).SelectedValue.ToInt();
if (importTag.ID == Guid.Empty)
{
importTag.ID = Guid.NewGuid();
((List <ImportTagMap>)ViewState["ImportTags"]).Add(importTag);
}
}
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 RadGrid1_InsertCommand(object source, GridCommandEventArgs e)
{
GridEditableItem editedItem = e.Item as GridEditableItem;
GridEditManager editMan = editedItem.EditManager;
string label = null;
Int32 class_typ;
Int32 tr_type;
label = (editedItem["trolley_label"].Controls[0] as TextBox).Text;
RadComboBox classtype = (RadComboBox)editedItem.FindControl("trolleyclass_type_RadComboBox");
RadComboBox trolleytype = (RadComboBox)editedItem.FindControl("trolleytype_RadComboBox");
class_typ = Int32.Parse(classtype.SelectedValue);
if (class_typ == 3)//multi trolley
{
tr_type = Int32.Parse(trolleytype.SelectedValue);
}
else
{
tr_type = 0;
}
string displayname = User.Identity.Name;
TrolleyDAO tmgrins = new TrolleyDAO();
decimal trolleyreturnid = tmgrins.Create_trolley(class_typ, tr_type, label, displayname);
//RadGrid1.DataSource = dataSet.Tables[0];
BindData();
}
/// <summary>
/// Saves the state of to view.
/// </summary>
/// <param name="paymentPassRuleCompanyId">The payment pass rule company id.</param>
/// <param name="item">The item.</param>
private void SaveToViewState(Guid paymentPassRuleCompanyId, GridEditableItem item)
{
var paymentPassRuleCompany = ((List <PaymentPassRuleCompanyMap>)ViewState["PaymentPassRuleCompanies"]).Where(s => s.ID == paymentPassRuleCompanyId).FirstOrDefault() ?? new PaymentPassRuleCompanyMap();
var dcbPayer = (DictionaryComboBox)item.FindControl("dcbPayer");
var dcbPayerLegalAccount = (DictionaryComboBox)item.FindControl("dcbPayerLegalAccount");
var dcbRecipient = (DictionaryComboBox)item.FindControl("dcbRecipient");
var dcbRecipientLegalAccount = (DictionaryComboBox)item.FindControl("dcbRecipientLegalAccount");
paymentPassRuleCompany.PayerID = dcbPayer.SelectedIdNullable;
paymentPassRuleCompany.Payer = dcbPayer.SelectedIdNullable != null
? dcbPayer.Text
: "";
paymentPassRuleCompany.PayerLegalAccountID = dcbPayerLegalAccount.SelectedIdNullable;
paymentPassRuleCompany.PayerLegalAccount = dcbPayerLegalAccount.SelectedIdNullable != null ? dcbPayerLegalAccount.Text : "";
paymentPassRuleCompany.RecipientID = dcbRecipient.SelectedIdNullable;
paymentPassRuleCompany.Recipient = dcbRecipient.SelectedIdNullable != null ? dcbRecipient.Text : "";
paymentPassRuleCompany.RecipientLegalAccountID = dcbRecipientLegalAccount.SelectedIdNullable;
paymentPassRuleCompany.RecipientLegalAccount = dcbRecipientLegalAccount.SelectedIdNullable != null
? dcbRecipientLegalAccount.Text
: "";
if (paymentPassRuleCompany.ID == Guid.Empty)
{
paymentPassRuleCompany.ID = Guid.NewGuid();
((List <PaymentPassRuleCompanyMap>)ViewState["PaymentPassRuleCompanies"]).Add(paymentPassRuleCompany);
}
}
protected void rgcandidate_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
GridDataItem dataitem = (GridDataItem)e.Item;
LinkButton lnkViewResume = (LinkButton)dataitem.FindControl("lnkViewResume");
if (lnkViewResume.CommandArgument == "null")
{
lnkViewResume.Visible = false;
}
}
if ((e.Item is GridEditableItem) && (e.Item.IsInEditMode) && (!e.Item.OwnerTableView.IsItemInserted))
{
GridEditableItem edititem = (GridEditableItem)e.Item;
edititem["jobid"].Enabled = false;
edititem["candidatename"].Enabled = false;
edititem["specialization"].Enabled = false;
edititem["experience"].Enabled = false;
RadComboBox rdhrStatus = (RadComboBox)edititem.FindControl("rcbstatus");
rdhrStatus.SelectedValue = ((System.Data.DataRowView)(edititem.DataItem)).Row.ItemArray[25].ToString();
RadComboBox rdfinalstatus = (RadComboBox)edititem.FindControl("rcbfinalstatus");
rdfinalstatus.SelectedValue = ((System.Data.DataRowView)(edititem.DataItem)).Row.ItemArray[27].ToString();
RadEditor rdnotes = (RadEditor)edititem.FindControl("rcbnotes");
rdnotes.Content = ((System.Data.DataRowView)(edititem.DataItem)).Row.ItemArray[28].ToString();
}
}
// client side validation function for hoilday form input controls
public void ValidateHolidays(GridItemEventArgs e)
{
GridEditableItem editForm = (GridEditableItem)e.Item;
ImageButton update = (ImageButton)editForm.FindControl("UpdateButton");
ImageButton insert = (ImageButton)editForm.FindControl("PerformInsertButton");
RadDatePicker dtpExpectedDate = (editForm.FindControl("dtpExpectedDate") as RadDatePicker);
RadComboBox ddlDayType = (editForm.FindControl("ddlDayType") as RadComboBox);
RadTextBox txtDescription = (editForm.FindControl("txtDescription") as RadTextBox);
if (update != null)
{
update.Attributes.Add("onclick", "return ValidateHolidays('" +
dtpExpectedDate.ClientID + "','" +
ddlDayType.ClientID + "','" +
txtDescription.ClientID
+ "')");
}
if (insert != null)
{
insert.Attributes.Add("onclick", "return ValidateHolidays('" +
dtpExpectedDate.ClientID + "','" +
ddlDayType.ClientID + "','" +
txtDescription.ClientID
+ "')");
}
}
private void UpdateDoc(GridEditableItem editedItem)
{
_dc = new EntidadesConosud();
GridEditManager editMan = editedItem.EditManager;
string id = (editMan.GetColumnEditor("Id") as GridTextBoxColumnEditor).Text;
long idHR = Convert.ToInt64(id);
HojasDeRuta _hojaRuta = (from c in _dc.HojasDeRuta
where c.IdHojaDeRuta == idHR
select c).FirstOrDefault();
if (_hojaRuta != null)
{
#region Recupero los Datos Ingresado por el usuario
DateTime?DocFechaEntrega = (editedItem.FindControl("TextBoxFechaEntrega") as RadDatePicker).SelectedDate;
string TextBoxDocComentario = (editedItem.FindControl("TextBoxDocComentario") as TextBox).Text;
#endregion
try
{
_hojaRuta.DocFechaEntrega = DocFechaEntrega;
_hojaRuta.DocComentario = TextBoxDocComentario;
_dc.SaveChanges();
CargarGrilla();
upGrilla.Update();
}
catch (Exception e)
{
ScriptManager.RegisterStartupScript(this.upGrilla, typeof(UpdatePanel), "Error Grabacion", "alert(" + e.Message + ")", true);
}
}
}
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 rgvOrderSteps_ItemCommand(object source, GridCommandEventArgs e)
{
bool bResult = false;
if (e.CommandName == "Update")
{
GridEditableItem edititem = e.Item as GridEditableItem;
GridEditFormItem editform = (GridEditFormItem)e.Item;
RadComboBox rcStatus = edititem.FindControl("ddlCustomerOrderStatus") as RadComboBox;
RadComboBox rcPendingReason = edititem.FindControl("ddlCustomerOrderStatusReason") as RadComboBox;
DataTable dt = new DataTable();
dt = (DataTable)Session["OrderDetails"];
string orderStepCode = dt.Rows[e.Item.ItemIndex]["WOS_OrderStepCode"].ToString().Trim();
orderId = int.Parse(dt.Rows[e.Item.ItemIndex]["CO_OrderId"].ToString().Trim());
string updatedStatus = rcStatus.SelectedValue;
string updatedReason = rcPendingReason.SelectedValue;
bResult = orderbo.UpdateOrderStep(updatedStatus, updatedReason, orderId, orderStepCode);
if (bResult == true)
{
rgvOrderSteps.Controls.Add(new LiteralControl("<strong>Successfully Updated</strong>"));
}
else
{
rgvOrderSteps.Controls.Add(new LiteralControl("<strong>Unable to update value</strong>"));
e.Canceled = true;
}
BindOrderStepsGrid();
}
}
protected void grdProducts_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
GridEditableItem item = e.Item as GridEditableItem;
Products product = e.Item.DataItem as Products;
if (DealProducts != null)
{
ProductsChildRelationship dealProduct = DealProducts.Where(dp => dp.ChildProductId == product.ProductID).FirstOrDefault();
if (dealProduct != null)
{
CheckBox chk = item.FindControl("OptionCheckBox") as CheckBox;
RadNumericTextBox quantity = item.FindControl("Quantity") as RadNumericTextBox;
RadNumericTextBox unitPrice = item.FindControl("UnitPrice") as RadNumericTextBox;
RadNumericTextBox FreeTopping = item.FindControl("FreeTopping") as RadNumericTextBox;
CheckBox isCustomizable = item.FindControl("AllowCustomization") as CheckBox;
chk.Checked = true;
quantity.Text = dealProduct.Quantity.ToString();
unitPrice.Text = dealProduct.UnitPrice.ToString();
FreeTopping.Text = dealProduct.NumberOfFreeTopping.ToString();
isCustomizable.Checked = dealProduct.IsCustomizable;
}
}
}
}
// client side validation function for premium type master input form
public void ValidatePremType(GridItemEventArgs e)
{
GridEditableItem editForm = (GridEditableItem)e.Item;
ImageButton update = (ImageButton)editForm.FindControl("UpdateButton");
ImageButton insert = (ImageButton)editForm.FindControl("PerformInsertButton");
RadTextBox txtpremtype = (editForm.FindControl("txtpremtype") as RadTextBox);
RadTextBox txtpremtypedesc = (editForm.FindControl("txtpremtypedesc") as RadTextBox);
RadComboBox ddlUnitOFPayment = (editForm.FindControl("ddlUnitOFPayment") as RadComboBox);
if (update != null)
{
update.Attributes.Add("onclick", "return ValidatePremType('" +
txtpremtype.ClientID + "','" +
txtpremtypedesc.ClientID + "','" +
ddlUnitOFPayment.ClientID
+ "')");
}
if (insert != null)
{
insert.Attributes.Add("onclick", "return ValidatePremType('" +
txtpremtype.ClientID + "','" +
txtpremtypedesc.ClientID + "','" +
ddlUnitOFPayment.ClientID
+ "')");
}
}
// client side validation function for province input form
public void ValidateProvince(GridItemEventArgs e)
{
GridEditableItem editForm = (GridEditableItem)e.Item;
ImageButton update = (ImageButton)editForm.FindControl("UpdateButton");
ImageButton insert = (ImageButton)editForm.FindControl("PerformInsertButton");
RadTextBox txtprvcod = (editForm.FindControl("txtprvcod") as RadTextBox);
RadTextBox txtprvnam = (editForm.FindControl("txtprvnam") as RadTextBox);
RadTextBox txtprvdsc = (editForm.FindControl("txtprvdsc") as RadTextBox);
if (update != null)
{
update.Attributes.Add("onclick", "return ValidateCity('" +
txtprvcod.ClientID + "','" +
txtprvnam.ClientID + "','" +
txtprvdsc.ClientID
+ "')");
}
if (insert != null)
{
insert.Attributes.Add("onclick", "return ValidateCity('" +
txtprvcod.ClientID + "','" +
txtprvnam.ClientID + "','" +
txtprvdsc.ClientID
+ "')");
}
}
protected void rGridPosition_UpdateCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
{
try
{
PositionDomainModel PosDM = new PositionDomainModel();
GridEditableItem eeditedItem = e.Item as GridEditableItem;
PosDM.PositionID = Convert.ToInt32((eeditedItem.FindControl("lblPositionID") as Label).Text.ToString());
PosDM.PositionTypeID = Convert.ToInt32((eeditedItem.FindControl("lblPositionTypeID") as Label).Text.ToString());
PosDM.PositionName = (eeditedItem.FindControl("lblPositionName") as Label).Text.ToString().Trim();
PosDM.PositionNameLong = (eeditedItem.FindControl("rTXTPositionNameLong") as RadTextBox).Text.ToString().Trim();
PosDM.MaxCount = Convert.ToInt32((eeditedItem.FindControl("rNTBMaxCount") as RadNumericTextBox).Value);
PosBLL.UpdatePosition(PosDM);
}
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 InsertUsuario(GridEditableItem editedItem)
{
long idPlanilla = Convert.ToInt64(ViewState["idsel"]);
#region Recupero los Datos Ingresado por el usuario
GridEditManager editMan = editedItem.EditManager;
string Login_Ingresado = ((TextBox)editedItem.FindControl("LoginTextBox")).Text;
string password_Ingresado = ((TextBox)editedItem.FindControl("PasswordTextBox")).Text;
string IdEmpres_Ingresado = ((RadComboBox)editedItem.FindControl("cboEmpresa")).SelectedValue;
#endregion
try
{
SegUsuario _ItemUsuario = new SegUsuario();
_ItemUsuario.Login = Login_Ingresado;
_ItemUsuario.Password = password_Ingresado;
if (IdEmpres_Ingresado.Trim() != "")
{
_ItemUsuario.IdEmpresa = long.Parse(IdEmpres_Ingresado);
}
Contexto.AddToSegUsuario(_ItemUsuario);
Contexto.SaveChanges();
this.grillaUsuarios.Rebind();
}
catch (Exception e)
{
ScriptManager.RegisterStartupScript(UpdPnlGrilla, typeof(UpdatePanel), "Error Grabacion", "alert(" + e.Message + ")", true);
}
}
protected void rgDetalles_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
if ((e.Item is GridEditableItem) && (e.Item.IsInEditMode))
{
GridEditableItem editItem = (GridEditableItem)e.Item;
this.rgDetalles.Columns.FindByUniqueName("EditCommandColumn").Visible = true;
RadComboBox rcmbFac = editItem.FindControl("rcbSerie") as RadComboBox;
RadNumericTextBox txtFact = editItem.FindControl("txtFact") as RadNumericTextBox;
new CN__Comun().LlenaCombo(sesion.Id_Emp, sesion.Id_Cd_Ver, sesion.Emp_Cnx, "spConsecutivos_Combo", ref rcmbFac);
Control insertbtn = (Control)editItem.FindControl("PerformInsertButton");
if (insertbtn != null)
{
txtFact.Enabled = true;
(e.Item.FindControl("txtFact") as RadNumericTextBox).Enabled = true;
}
}
else
if (e.Item.IsDataBound)
{
GridDataItem item = (GridDataItem)e.Item;
item["EditCommandColumn"].Controls[0].Visible = false;
}
//TODO: AGREGAR PARA PONER EL FOCUS
if (e.Item is GridEditableItem && e.Item.IsInEditMode)
{
GridEditableItem form = (GridEditableItem)e.Item;
RadNumericTextBox dataField = (RadNumericTextBox)form["Factura"].FindControl("txtFact");
dataField.Focus();
}
}
private bool IsValidAreaSelected()
{
bool retVal = true;
foreach (GridItem item in grdLoadRelease.MasterTableView.Items)
{
if (item is GridEditableItem)
{
GridEditableItem editableItem = item as GridDataItem;
CheckBox chlabel = (CheckBox)editableItem.FindControl("SelectRow");
RadComboBox areaid = (RadComboBox)editableItem.FindControl("releaseTo");
if (chlabel.Checked == true)
{
string area_id = areaid.SelectedValue;
if (area_id == "-1")
{
retVal = false;
break;
}
}
}
}
return(retVal);
}
/// <summary>
/// Saves the state of to view.
/// </summary>
/// <param name="taskMemberId">The taskMemberId.</param>
/// <param name="item">The item.</param>
private void SaveToViewState(Guid taskMemberId, GridEditableItem item)
{
var taskMember = ((List <TaskMemberMap>)ViewState["TaskMembers"]).Where(s => s.ID == taskMemberId).FirstOrDefault() ?? new TaskMemberMap();
if (((DictionaryComboBox)item.FindControl("dcbContractor")).SelectedId != Guid.Empty)
{
taskMember.ContractorID = ((DictionaryComboBox)item.FindControl("dcbContractor")).SelectedId;
}
else
{
taskMember.ContractorID = null;
}
taskMember.ContactID = ((ContactComboBox)item.FindControl("ucContact")).SelectedValue;
if (((DictionaryComboBox)item.FindControl("dcbOrder")).SelectedId != Guid.Empty)
{
taskMember.OrderID = ((DictionaryComboBox)item.FindControl("dcbOrder")).SelectedId;
}
taskMember.OrderProductsID = ((OrderProductsComboBox)item.FindControl("ucOrderProduct")).SelectedValue;
taskMember.TaskMemberRoleID = int.Parse(((DropDownList)item.FindControl("ddlTaskMemberRole")).SelectedValue);
taskMember.Comment = ((TextBox)item.FindControl("txtComment")).Text;
taskMember.UserComment = ((TextBox)item.FindControl("txtUserComment")).Text;
taskMember.IsInformed = ((CheckBox)item.FindControl("chxIsInformed")).Checked;
if (taskMember.ID == Guid.Empty)
{
taskMember.ID = Guid.NewGuid();
taskMember.TaskMemberStatusID = (int)TaskMemberStatus.Plan;
((List <TaskMemberMap>)ViewState["TaskMembers"]).Add(taskMember);
}
}
protected void rgTransInProd_UpdateCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
{
GridEditableItem item = (GridEditableItem)e.Item;
RadComboBox cmbprodhdr = (RadComboBox)item.FindControl("RadCmbProdHdr");
RadComboBox cmbtranshdr = (RadComboBox)item.FindControl("RadCmbTransHdr");
RadTextBox code = (RadTextBox)item.FindControl("hdrcodetxt");
RadNumericTextBox amt = (RadNumericTextBox)item.FindControl("amount");
string transcode = cmbtranshdr.SelectedValue;
string prodcode = cmbprodhdr.SelectedValue;
int amount = Convert.ToInt32(amt.Text);
string codes = code.Text;
if (transcode == "")
{
ShowMessage("Transaction Information Cannot be empty");
return;
}
if (prodcode == "")
{
ShowMessage("Product Information Cannot be empty");
return;
}
if (amount == 0)
{
ShowMessage("Product Amount Cannot be empty");
return;
}
update(prodcode, transcode, amount, codes);
}
protected void rgCC_InsertCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
{
try
{
GridEditableItem editedItem = e.Item as GridEditableItem;
Hashtable newValues = new Hashtable();
e.Item.OwnerTableView.ExtractValuesFromItem(newValues, editedItem);
//Load controls
RadTextBox txtEmail = (RadTextBox)editedItem.FindControl("txtEmail");
RadDropDownList ddlType = (RadDropDownList)editedItem.FindControl("ddlType");
//Insert query
var strsql = "INSERT INTO [tbl_Email_CC_Master]([CC_Email_Id],Type_Id) VALUES ('" + txtEmail.Text + "', '" + ddlType.SelectedValue + "');";
int i = DBUtils.ExecuteSQLCommand(new SqlCommand(strsql));
if (i > 0)
{
rmw1.RadAlert("Email: " + txtEmail.Text + " Inserted Successfully", 400, 100, "Success", null);
fnLoadData(true);
}
else
{
rmw1.RadAlert("Insertion Error", 400, 100, "Success", null);
return;
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void rgFieldTrips_InsertCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
Data.Trip newTrip = new Data.Trip();
newTrip.office_id = Convert.ToInt32((item.FindControl("rddlOffice") as RadDropDownList).SelectedValue);
newTrip.user_id = (item.FindControl("rddlAssignedTo2") as RadDropDownList).SelectedValue.ToString();
newTrip.trip_nm = (item.FindControl("rtbTripName2") as RadTextBox).Text;
RadListBox assigned_sites = (item.FindControl("rlbSitesEnd2") as RadListBox);
db.Trips.InsertOnSubmit(newTrip);
db.SubmitChanges();
List <Data.TripSite> tripSites = new List <Data.TripSite>();
foreach (RadListBoxItem site in assigned_sites.Items)
{
tripSites.Add(new Data.TripSite()
{
trip_id = newTrip.trip_id, site_id = Convert.ToInt32(site.Value)
});
}
db.TripSites.InsertAllOnSubmit(tripSites);
db.SubmitChanges();
DisplayMessage(false, "The field trip was added!");
}
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!");
}
protected void rgcandidate_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
GridDataItem item = (GridDataItem)e.Item;
//string CanditateName = (item["candidatename"].Controls[0] as TextBox).Text;
LinkButton lnkDelete = (LinkButton)item.FindControl("lnkDelete");
Label lblcandidatename1 = (Label)item.FindControl("lblcandidatename1");
lnkDelete.OnClientClick = "javascript:return confirm('Are you sure, Do you want to delete " + lblcandidatename1.Text + "?');";
}
if (e.Item is GridDataItem)
{
GridDataItem dataitem = (GridDataItem)e.Item;
LinkButton lnkViewResume = (LinkButton)dataitem.FindControl("lnkViewResume");
if (lnkViewResume.CommandArgument == "null")
{
lnkViewResume.Visible = false;
}
}
if ((e.Item is GridEditableItem) && (e.Item.IsInEditMode) && (!e.Item.OwnerTableView.IsItemInserted))
{
GridEditableItem edititem = (GridEditableItem)e.Item;
edititem["jobid"].Enabled = false;
edititem["candidatename"].Enabled = false;
edititem["specialization"].Enabled = false;
edititem["experience"].Enabled = false;
RadComboBox rdhrStatus = (RadComboBox)edititem.FindControl("rcbstatus");
rdhrStatus.SelectedValue = ((System.Data.DataRowView)(edititem.DataItem)).Row.ItemArray[25].ToString();
RadComboBox rdfinalstatus = (RadComboBox)edititem.FindControl("rcbfinalstatus");
rdfinalstatus.SelectedValue = ((System.Data.DataRowView)(edititem.DataItem)).Row.ItemArray[27].ToString();
RadEditor rdnotes = (RadEditor)edititem.FindControl("rcbnotes");
rdnotes.Content = ((System.Data.DataRowView)(edititem.DataItem)).Row.ItemArray[28].ToString();
}
}
protected void ddlInterestBasis_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList dropdown = (DropDownList)sender;
GridEditableItem editedItem = dropdown.NamingContainer as GridEditableItem;
DropDownList ddlInterestBasis = editedItem.FindControl("ddlInterestBasis") as DropDownList;
HtmlTableRow trCompoundInterest = editedItem.FindControl("trCompoundInterest") as HtmlTableRow;
HtmlTableRow trSimpleInterest = editedItem.FindControl("trSimpleInterest") as HtmlTableRow;
if (ddlInterestBasis.SelectedItem.Value.ToString().Trim() == "CI")
{
trCompoundInterest.Visible = true;
trSimpleInterest.Visible = false;
}
else if (ddlInterestBasis.SelectedItem.Value.ToString().Trim() == "SI") // If Simple Interest
{
trCompoundInterest.Visible = false;
trSimpleInterest.Visible = true;
}
else
{
trCompoundInterest.Visible = false;
trSimpleInterest.Visible = false;
}
}
protected void gridMain_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridEditableItem && e.Item.IsInEditMode)
{
JobsMainID = -1;
Session.Remove("JobsMainID");
Session.Remove("Position1");
Session.Remove("Position2");
GridEditableItem item = e.Item as GridEditableItem;
RadAutoCompleteBox txtPosition1 = item.FindControl("txtPosition1") as RadAutoCompleteBox;
RadAutoCompleteBox txtPosition2 = item.FindControl("txtPosition2") as RadAutoCompleteBox;
RadDropDownList ddlJobsMain = item.FindControl("ddlJobsMain") as RadDropDownList;
RadDropDownList ddlPosition1 = item.FindControl("ddlPosition1") as RadDropDownList;
RadDropDownList ddlPosition2 = item.FindControl("ddlPosition2") as RadDropDownList;
try {
DistanceB currDistance = e.Item.DataItem as DistanceB;
JobsMainController cont = new JobsMainController();
ddlJobsMain.DataSource = cont.GetJobsMain();
ddlJobsMain.DataTextField = "Name";
ddlJobsMain.DataValueField = "ID";
ddlJobsMain.DataBind();
DistancesController dcont = new DistancesController();
List <string> distPos = dcont.GetDistinctPositions();
ddlPosition1.DataSource = distPos;
ddlPosition1.DataBind();
ddlPosition2.DataSource = distPos;
ddlPosition2.DataBind();
if (currDistance != null)
{
txtPosition1.Entries.Add(new AutoCompleteBoxEntry(currDistance.Position1, currDistance.Position1));
txtPosition2.Entries.Add(new AutoCompleteBoxEntry(currDistance.Position2, currDistance.Position2));
ddlJobsMain.SelectedIndex = ddlJobsMain.FindItemByValue(currDistance.JobsMainID.ToString()).Index;
Session["JobsMainID"] = currDistance.JobsMainID;
Session["Position1"] = currDistance.Position1;
Session["Position2"] = currDistance.Position2;
}
else
{
ddlJobsMain.SelectedIndex = 0;
Session["JobsMainID"] = ddlJobsMain.SelectedItem.Value;
}
}
catch (Exception) { }
}
if (e.Item is GridFilteringItem)
{
GridFilteringItem filterItem = (GridFilteringItem)e.Item;
RadDropDownList cflist = (RadDropDownList)filterItem.FindControl("ddlJobsMainFilter");
try {
JobsMainController ccont = new JobsMainController();
cflist.DataSource = ccont.GetJobsMain();
cflist.DataTextField = "Name";
cflist.DataValueField = "ID";
cflist.DataBind();
cflist.Items.Insert(0, new DropDownListItem("Κανένα Φίλτρο", "0"));
}
catch (Exception) { }
}
}
/// <summary>
/// Handles the UpdateCommand event of the gvLocations control.
/// </summary>
/// <param name="source">The source of the event.</param>
/// <param name="e">The <see cref="Telerik.Web.UI.GridCommandEventArgs"/> instance containing the event data.</param>
protected void gvLocations_UpdateCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)
{
if (!PageBase.StopProcessing && Page.IsValid)
{
//Get the GridEditableItem of the RadGrid
GridEditableItem editedItem = e.Item as GridEditableItem;
//string name = (editedItem["Name"].Controls[0] as TextBox).Text;
//string location = (editedItem["Location"].Controls[0] as TextBox).Text;
TextBox name = (TextBox)editedItem.FindControl("tbName");
TextBox location = (TextBox)editedItem.FindControl("tbLocation");
if (name.Text.Trim() != string.Empty || location.Text.Trim() != string.Empty)
{
if (ProjectID == 0)
{
ProjectLocation projectLocation = LocationList[editedItem.ItemIndex];
projectLocation.Location = location.Text.Trim();
projectLocation.Name = name.Text.Trim();
projectLocation.LastUpdatedByUserId = UserID;
projectLocation.LastUpdatedDate = Now;
}
else
{
int projectLocationID = (int)editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["ProjectLocationId"];
DateTime originalLastUpdatedDate = (DateTime)editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["LastUpdatedDate"];
ProjectLocation projectLocation = (from pl in DataContext.ProjectLocations
where pl.ProjectLocationId == projectLocationID && pl.LastUpdatedDate == originalLastUpdatedDate
select pl).FirstOrDefault();
if (projectLocation == null)
{
StageBitzException.ThrowException(new ConcurrencyException(ExceptionOrigin.ProjectDetails, ProjectID));
}
#region Project Notification
if (projectLocation.Location != location.Text.Trim() || projectLocation.Name != name.Text.Trim())
{
DataContext.Notifications.AddObject(CreateNotification(Support.GetCodeIdByCodeValue("OperationType", "EDIT"), string.Format("{0} edited a Project Location.", Support.UserFullName)));
}
#endregion Project Notification
projectLocation.Location = location.Text.Trim();
projectLocation.Name = name.Text.Trim();
projectLocation.LastUpdatedByUserId = UserID;
projectLocation.LastUpdatedDate = Now;
DataContext.SaveChanges();
}
gvLocations.EditIndexes.Clear();
gvLocations.MasterTableView.IsItemInserted = false;
gvLocations.Rebind();
}
}
}
// insert/update function
private void Insert_or_Update_Employee(ref GridCommandEventArgs e, string operation)
{
GridEditableItem editedItem = e.Item as GridEditableItem;
try
{
//Insert new values
Hashtable newValues = new Hashtable();
if (e.Item.OwnerTableView.DataMember == "EmpLeavesDetail")
{
//Insert new values
newValues = new Hashtable();
if (operation == "Update")
{
newValues["@lvcidd"] = (int)editedItem.GetDataKeyValue("levid");
}
GridDataItem parentItem = (GridDataItem)(e.Item.OwnerTableView.ParentItem);
if (parentItem != null)
{
newValues["@lvtidd"] = Convert.ToInt32(parentItem.OwnerTableView.DataKeyValues[parentItem.ItemIndex]["lvtidd"].ToString());
}
GridDataItem secondParentItem = (GridDataItem)(parentItem.OwnerTableView.ParentItem);
if (secondParentItem != null)
{
newValues["@empidd"] = Convert.ToInt32(secondParentItem.OwnerTableView.DataKeyValues[secondParentItem.ItemIndex]["recidd"].ToString());
}
newValues["@lvcbal"] = (editedItem.FindControl("txtBxBalance") as RadNumericTextBox).Text;
newValues["@lvcdat"] = (editedItem.FindControl("dtpdate") as RadDatePicker).SelectedDate;
newValues["@DBMessage"] = "";
string DBMessage = "";
//if (operation == "Insert")
//{
// DBMessage = clsDAL.ExecuteNonQuery_payroll("sp_Payroll_Insert_Employee_EmpLeaves", newValues, "@DBMessage", System.Data.SqlDbType.NVarChar, 255) as string;
//}
//else
if (operation == "Update")
{
DBMessage = clsDAL.ExecuteNonQuery_payroll("sp_payroll_Update_EmployeeLeaveBalance", newValues, "@DBMessage", System.Data.SqlDbType.NVarChar, 255) as string;
}
if ((null != DBMessage) && DBMessage.Contains("ERROR:"))
{
ShowClientMessage(DBMessage, MessageType.Error);
e.Canceled = true;
}
ShowClientMessage("Employee Leave Balance record save successfully.", MessageType.Success);
}
}
catch (Exception ex)
{
ShowClientMessage("Unable to update/insert Employee Leave Balance record. Reason: " + ex.Message, MessageType.Error);
e.Canceled = true;
}
}
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 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 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 static void CleanComboAddNew(GridEditableItem editedItem, bool clearFirstComboFlag)
{
if (clearFirstComboFlag)
{
var ddlGroupAddNew = ((RadComboBox)editedItem.FindControl("ddlGroupAddNew"));
UtilitiesHelpers.Instance.ClearComboData(ddlGroupAddNew);
}
var ddlRegionAddNew = ((RadComboBox)editedItem.FindControl("ddlRegionAddNew"));
UtilitiesHelpers.Instance.ClearComboData(ddlRegionAddNew);
var ddlAreaAddNew = ((RadComboBox)editedItem.FindControl("ddlAreaAddNew"));
UtilitiesHelpers.Instance.ClearComboData(ddlAreaAddNew);
var ddlLocalAddNew = ((RadComboBox)editedItem.FindControl("ddlLocalAddNew"));
UtilitiesHelpers.Instance.ClearComboData(ddlLocalAddNew);
}
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;
}