Пример #1
0
      protected void grdSalary_ItemDataBound(object sender, GridItemEventArgs e)
      {
         if (e.Item.IsInEditMode && e.Item is GridEditableItem)
         {
            GridEditableItem editedItem = e.Item as GridEditableItem;

            RadComboBox cbCCY = (RadComboBox)editedItem.FindControl("rcbCurrCodeEdit");
            //cbCCY.Width = Unit.Pixel(220);
            RadNumericTextBox tbxSalary = (RadNumericTextBox)editedItem["LocalSalary"].Controls[0];
            tbxSalary.Width = Unit.Pixel(85);
            RadDatePicker dteEff = (RadDatePicker)editedItem["EffectiveDate"].Controls[0];
            dteEff.Width = Unit.Pixel(100);

            using (var ctx = new DBContext())
               cbCCY.DataSource = ctx.getCurrencyCodes();
            cbCCY.DataValueField = "curcode";
            cbCCY.DataTextField = "curcode";
            cbCCY.DataBind();

            if (e.Item.OwnerTableView.IsItemInserted)
            {
               //item is about to be inserted
            }
            else
            {
               //item is about to be edited
               //cbCCY.SelectedValue = ((CurrInfo)editedItem.DataItem).curcode.ToString();

               DataRowView dataView = editedItem.DataItem as DataRowView;
               DataRow row = dataView.Row;
               cbCCY.SelectedValue = row["CurrCode"].ToString();
            }
         }
      }
Пример #2
0
      protected void grdSalary_ItemCommand(object sender, GridCommandEventArgs e)
      {
         string id, code, comment;
         int seq;
         decimal salary;
         DateTime dteEff;

         if (e.Item.IsInEditMode && e.Item is GridEditableItem)
         {
            RadComboBox cbCCY = (RadComboBox)e.Item.FindControl("rcbCurrCodeEdit");
            code = cbCCY.SelectedValue;

            //Prepare new dictionary object
            Hashtable newValues = new Hashtable();

            switch (e.CommandName)
            {
               case RadGrid.PerformInsertCommandName:
                  if (Page.IsValid)       //Check required fields are populated:  Salary & Eff. Date    
                  {
                     GridDataInsertItem item = e.Item as GridDataInsertItem;

                     item.ExtractValues(newValues);

                     RadTab tab = tabAtty.FindTabByText("Personal");
                     RadPageView pgVw = tab.PageView;

                     id = ((RadTextBox)pgVw.FindControl("txtAttyID")).Text;
                     seq = 0;    //value will be determined by stored proc
                     salary = Decimal.Parse(newValues["LocalSalary"].ToString());
                     dteEff = DateTime.Parse(newValues["EffectiveDate"].ToString());
                     comment = (newValues["Comment"] == null ? String.Empty : newValues["Comment"].ToString());

                     var insSal = new Salary { TimeKeep = id, Seq_no = seq, LocalSalary = salary, CurrCode = code, EffectiveDate = dteEff, Comment = comment };

                     using (var ctx = new DBContext())
                        ctx.modifySalary("C", insSal);
                  }
                  break;
               case RadGrid.UpdateCommandName:
                  GridEditableItem editedItem = e.Item as GridEditableItem;

                  //editedItem.SavedOldValues: dictionary holds the old values
                  e.Item.OwnerTableView.ExtractValuesFromItem(newValues, editedItem);

                  id = newValues["TimeKeep"].ToString();
                  seq = int.Parse(newValues["Seq_no"].ToString());
                  salary = Decimal.Parse(newValues["LocalSalary"].ToString());
                  dteEff = DateTime.Parse(newValues["EffectiveDate"].ToString());
                  comment = (newValues["Comment"] == null ? String.Empty : newValues["Comment"].ToString());

                  var updSal = new Salary { TimeKeep = id, Seq_no = seq, LocalSalary = salary, CurrCode = code, EffectiveDate = dteEff, Comment = comment };

                  using (var ctx = new DBContext())
                     ctx.modifySalary("U", updSal);
                  break;
               //case RadGrid.DeleteCommandName:        //AllowAutomaticDeletes="true"             
               //   break;
            }
         }
      }
Пример #3
0
      protected void grdCommittee_ItemCommand(object sender, GridCommandEventArgs e)
      {
         string id;

         #region Iff all fields are bound by GridBoundColumn
         /*
         if (e.Item.IsInEditMode && e.Item is GridEditableItem)
         {
            GridEditableItem editedItem = e.Item as GridEditableItem;

            //Prepare new dictionary object
            Hashtable newValues = new Hashtable();
            e.Item.OwnerTableView.ExtractValuesFromItem(newValues, editedItem);

            int newNum = int.Parse(newValues["cnum"].ToString());
            string newChair = newValues["cchair"].ToString();

            switch (e.CommandName)
            {
               case RadGrid.PerformInsertCommandName:
                  RadTab tab = tabAtty.FindTabByText("Personal");
                  RadPageView pgVw = tab.PageView;

                  id = ((RadTextBox)pgVw.FindControl("txtAttyID")).Text;

                  using (var ctx = new DBContext())
                  {
                     var com = new Committee { tkinit = id, cnum = newNum, cchair = newChair };
                     ctx.Committees.Add(com);
                     ctx.SaveChanges();
                  }
                  break;
               case RadGrid.UpdateCommandName:
                  //editedItem.SavedOldValues: dictionary holds the old values
                  id = editedItem.SavedOldValues["tkinit"].ToString();
                  int oldNum = int.Parse(editedItem.SavedOldValues["cnum"].ToString());

                  var comm = new Committee { tkinit = id, cnum = newNum, cchair = newChair };
                  using (var ctx = new DBContext())
                  {
                     ////*** Notes:  You cannot update the primary key through EF. ***
                     //// A referential integrity constraint violation occurred: A primary key property that is a part of 
                     //// referential integrity constraint cannot be changed when the dependent object is Unchanged 
                     //// unless it is being set to the association's principal object. 
                     //// The principal object must be tracked and not marked for deletion.
                     //var com = ctx.Committees.Find(id, oldNum);
                     //var comMas = ctx.CommitteeMasters.Find(newNum);
                     ////com.cnum = newNum;
                     ////com.cnum = comMas.cnum;
                     //com.CommitteeMaster = comMas;
                     //com.cchair = newChair;
                     //ctx.SaveChanges();

                     ctx.updateCom(comm, oldNum);
                  }
                  break;
               //case RadGrid.DeleteCommandName:        //AllowAutomaticDeletes="true"             
               //   break;
            }
         }
         */
         #endregion

         if (e.Item.IsInEditMode && e.Item is GridEditableItem)
         {
            RadComboBox cbChair = (RadComboBox)e.Item.FindControl("rcbChairEdit");
            RadComboBox cbCode = (RadComboBox)e.Item.FindControl("rcbComCodeEdit");

            int newNum = int.Parse(cbCode.SelectedValue);
            string newChair = cbChair.SelectedValue;

            switch (e.CommandName)
            {
               case RadGrid.PerformInsertCommandName:
                  //e.Item as GridDataInsertItem
                  RadTab tab = tabAtty.FindTabByText("Personal");
                  RadPageView pgVw = tab.PageView;

                  id = ((RadTextBox)pgVw.FindControl("txtAttyID")).Text;

                  using (var ctx = new DBContext())
                  {
                     var com = new Committee { tkinit = id, cnum = newNum, cchair = newChair };
                     ctx.Committees.Add(com);
                     ctx.SaveChanges();
                  }

                  break;
               case RadGrid.UpdateCommandName:
                  GridEditableItem editedItem = e.Item as GridEditableItem;

                  //editedItem.SavedOldValues: dictionary holds the old values
                  id = editedItem.SavedOldValues["tkinit"].ToString();
                  int oldNum = int.Parse(editedItem.SavedOldValues["cnum"].ToString());

                  var comm = new Committee { tkinit = id, cnum = newNum, cchair = newChair };
                  using (var ctx = new DBContext())
                     ctx.updCommittee(comm, oldNum);
                  break;
               //case RadGrid.DeleteCommandName:        //AllowAutomaticDeletes="true"             
               //   break;
            }

         }
      }
Пример #4
0
      protected void grdCommittee_ItemDataBound(object sender, GridItemEventArgs e)
      {
         //if (e.Item.IsInEditMode && e.Item is GridEditFormItem)       //FormTemplate
         if (e.Item.IsInEditMode && e.Item is GridEditableItem)
         {
            GridEditableItem editedItem = e.Item as GridEditableItem;

            RadComboBox cbChair = (RadComboBox)editedItem.FindControl("rcbChairEdit");
            //cbChair.Width = Unit.Pixel(50);      //--> Set in designer
            RadComboBox cbCode = (RadComboBox)editedItem.FindControl("rcbComCodeEdit");
            //cbCode.Width = Unit.Pixel(375);      //--> Set in designer

            using (var ctx = new DBContext())
               cbCode.DataSource = ctx.CommitteeMasters
                                       .OrderBy(x => x.ccode)
                                       .ThenBy(y => y.cdescription)
                                       .Select(p => new
                                       {
                                          ccode = p.ccode.Trim(),
                                          cdescription = p.cdescription.Trim(),
                                          p.cnum
                                       }).ToList();
            cbCode.DataValueField = "cnum";
            cbCode.DataTextField = "ccode";
            cbCode.DataBind();

            if (e.Item.OwnerTableView.IsItemInserted)
            {
               //item is about to be inserted
            }
            else
            {
               //item is about to be edited
               //combo.SelectedValue = ((lw740_bankrate)editedItem.DataItem).Client.ToString();
               DataRowView dataView = editedItem.DataItem as DataRowView;
               DataRow row = dataView.Row;

               cbChair.SelectedValue = row["cchair"].ToString();
               cbCode.SelectedValue = row["cnum"].ToString();
            }
         }

      }
Пример #5
0
      private void BindAttyInfo(string sAttnId)
      {
         #region Personal
         AttyInfo atty;
         using (var ctx = new DBContext())
         {
            atty = ctx.getAtty(sAttnId);
         }

         RadTab tab = tabAtty.FindTabByText("Personal");
         RadPageView pgVw = tab.PageView;

         ((RadTextBox)pgVw.FindControl("txtAttyID")).Text = atty.tstk;                             //Atty Id
         ((RadDatePicker)pgVw.FindControl("txtLastModified")).SelectedDate = atty.LastModified;    //Last Modified
         ((RadTextBox)pgVw.FindControl("txtModifyBy")).Text = atty.tsaudit_op;                     //Modify by
         ((RadTextBox)pgVw.FindControl("txtFullName")).Text = atty.FullName;                       //Full Name
         ((RadTextBox)pgVw.FindControl("txtLocation")).Text = atty.LocDesc;                        //Location description
         //((RadNumericTextBox)pgVw.FindControl("txtStdPrnRate")).Value = atty.tspstd;             //Std Partner Rate
         ((RadNumericTextBox)pgVw.FindControl("txtUnits")).Value = atty.tsunits;                   //Units
         ((RadNumericTextBox)pgVw.FindControl("txtBonus")).Value = atty.tsbonus;                   //Bonus
         ((RadComboBox)pgVw.FindControl("rcbDeparture")).SelectedValue =                           //Departure?
            (atty.tsdeparture ?? string.Empty).Trim();
         ((RadNumericTextBox)pgVw.FindControl("txtAdjUnits")).Value = atty.tsadjunits;             //Adjusted Units
         ((RadDatePicker)pgVw.FindControl("txtDOB")).SelectedDate = atty.tsdob;                    //Date of Birth
         ((RadDatePicker)pgVw.FindControl("txtDepartDate")).SelectedDate = atty.tsdepartdt;        //Departure Date
         ((RadNumericTextBox)pgVw.FindControl("txtUnitValue")).Value = atty.tsunitval;             //Unit Value
         ((RadComboBox)pgVw.FindControl("rcbType")).SelectedValue =                                //Type
            (atty.tstype ?? string.Empty).Trim();
         ((RadMaskedTextBox)pgVw.FindControl("txtClass")).Text = atty.tsclass;                     //Class

         RadNumericTextBox txtIPLvl = (RadNumericTextBox)pgVw.FindControl("txtIPLevel");           //IP Level
         Label lblIPLvl = (Label)pgVw.FindControl("lblIPLevel");
         if (atty.tstype.Trim() == "I")
         {
            //lblIPLvl.Visible =
            //txtIPLvl.Visible = true;
            lblIPLevel.Style["display"] =
            txtIPLevel.Style["display"] = "block";
            txtIPLvl.Value = atty.IPLevel;
         }
         else
         {
            //lblIPLvl.Visible =
            //txtIPLvl.Visible = false;
            lblIPLevel.Style["display"] =
            txtIPLevel.Style["display"] = "none";
         }
         ((RadNumericTextBox)pgVw.FindControl("txtPreFundComp")).Value = atty.tsfund;              //Pre-Fund Compensation
         ((RadComboBox)pgVw.FindControl("rcbRank")).SelectedValue =                                //Rank
            (atty.tstatus ?? string.Empty).Trim();
         //((RadMaskedTextBox)pgVw.FindControl("txtEvalClass")).Text = atty.tsevalclass;           //Evaluation Class, where A=Associate
         if (atty.tstype.Trim() == "A")
         {
            lblEvalClass.Style["display"] =
            txtEvalClass.Style["display"] = "block";
            txtEvalClass.Text = atty.tsevalclass;
         }
         else
         {
            lblEvalClass.Style["display"] =
            txtEvalClass.Style["display"] = "none";
         }
         ((RadNumericTextBox)pgVw.FindControl("txtPrnFund")).Value = atty.tspfund;                 //Partner Fund
         ((RadTextBox)pgVw.FindControl("txtPrinPracGroup")).Text = atty.tsppgroup;                 //Principal Practice Group
         //((RadDatePicker)pgVw.FindControl("txtAdminDate")).SelectedDate = atty.tsepadmindt;      //Equity Partner Admission Date, where E=Equity
         if (atty.tstype.Trim() == "E")
         {
            lblAdminDate.Style["display"] =
            txtAdminDate.Style["display"] = "block";
            txtAdminDate.SelectedDate = atty.tsepadmindt;
         }
         else
         {
            lblAdminDate.Style["display"] =
            txtAdminDate.Style["display"] = "none";
         }
         ((RadTextBox)pgVw.FindControl("txtBar")).Text = atty.tsBarState;                          //Bar
         ((RadTextBox)pgVw.FindControl("txtComment")).Text = atty.tscomment;                       //Comment

         //Only levels 1 & 2 are allowed to edit
         switch (ViewState["Access"].ToString())
         {
            case "1":      //Edit all attys
               txtUnits.Focus();    //Give focus to 1st editable field 

               foreach (var ctl in pgVw.Controls.OfType<ImageButton>())
                  ((ImageButton)ctl).Visible = true;

               grdCommittee.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.Bottom;
               grdSalary.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.Bottom;
               break;
            case "2":      //Edit associates only 
               txtDOB.Focus();

               foreach (var ctl in pgVw.Controls.OfType<ImageButton>())
                  ((ImageButton)ctl).Visible = true;

               grdCommittee.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.Bottom;
               //grdSalary.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.Bottom;
               break;
         }
         #endregion

         SqlCommittee.SelectParameters["tkinit"].DefaultValue = sAttnId;
         SqlSalary.SelectParameters["TimeKeep"].DefaultValue = sAttnId;

         //If grids were left in "uncommitted" state, 
         //RequiredFieldValidation errors on grdSalary on subsequent atty retrievals
         grdCommittee.MasterTableView.IsItemInserted = false;     
         grdCommittee.Rebind();
         //grdSalary.MasterTableView.ClearEditItems();
         grdSalary.MasterTableView.IsItemInserted = false;
         grdSalary.Rebind();

         //Show "Personal" tab
         tabAtty.SelectedIndex = 0;
         PagePersonal.Selected = true;
      }
Пример #6
0
      protected void btnDtlUpdate_Click(object sender, System.Web.UI.ImageClickEventArgs e)
      {
         //http://stackoverflow.com/questions/12879198/how-can-i-update-a-detached-entity-in-ef-cf-multi-tier-application
         //context.Entry(user).Property(u => u.Body).IsModified = true;
         //DataContext.Entry(entity).State = System.Data.EntityState.Modified;
         //http://msdn.microsoft.com/en-us/data/jj592676.aspx

         if (Page.IsValid)
         {
            RadTab tab = tabAtty.FindTabByText("Personal");
            RadPageView pgVw = tab.PageView;

            string id = ((RadTextBox)pgVw.FindControl("txtAttyID")).Text;

            if (!String.IsNullOrEmpty(id))
            {
               using (var ctx = new DBContext())
               {
                  var atty = ctx.Attorneys.Find(id);

                  atty.tsaudit_op = ntID;
                  atty.LastModified = DateTime.Now;
                  //atty.ProperCaseName = ((RadTextBox)pgVw.FindControl("txtFullName")).Text;
                  //NO need to update location code: tsloc
                  //atty.tspstd = ((RadNumericTextBox)pgVw.FindControl("txtStdPrnRate")).Value;          //Std Partner Rate
                  atty.tsunits = ((RadNumericTextBox)pgVw.FindControl("txtUnits")).Value;                //Units
                  atty.tsbonus = ((RadNumericTextBox)pgVw.FindControl("txtBonus")).Value;                //Bonus

                  atty.tsdeparture = ((RadComboBox)pgVw.FindControl("rcbDeparture")).SelectedValue;      //Departure?
                  atty.tsadjunits = ((RadNumericTextBox)pgVw.FindControl("txtAdjUnits")).Value;          //Adjusted Units
                  atty.tsdob = ((RadDatePicker)pgVw.FindControl("txtDOB")).DateInput.SelectedDate;       //Date of Birth
                  atty.tsdepartdt = (atty.tsdeparture == "Y" ?                                           //Departure Date
                        ((RadDatePicker)pgVw.FindControl("txtDepartDate")).DateInput.SelectedDate : null);
                  atty.tsunitval = ((RadNumericTextBox)pgVw.FindControl("txtUnitValue")).Value;          //Unit Value
                  atty.tstype = ((RadComboBox)pgVw.FindControl("rcbType")).SelectedValue;                //Type
                  if (atty.tstype == "I")                                                                //IP Level - Allowable values: 1-8, but no validation
                  {                                                                                      //[MinValue="1"; MaxValue="8"]
                     int n = 1;
                     if (int.TryParse(((RadNumericTextBox)pgVw.FindControl("txtIPLevel")).Text, out n))
                        atty.IPLevel = n;
                  }
                  else
                  {
                     atty.IPLevel = null;
                  }
                  atty.tsclass = ((RadMaskedTextBox)pgVw.FindControl("txtClass")).Text.Trim();           //Class
                  atty.tsfund = ((RadNumericTextBox)pgVw.FindControl("txtPreFundComp")).Value;           //Pre-Fund Compensation
                  atty.tstatus = ((RadComboBox)pgVw.FindControl("rcbRank")).SelectedValue;               //Rank
                  atty.tsevalclass = ((RadMaskedTextBox)pgVw.FindControl("txtEvalClass")).Text.Trim();   //Evaluation Class
                  atty.tspfund = ((RadNumericTextBox)pgVw.FindControl("txtPrnFund")).Value;              //Partner Fund
                  //atty.tsppgroup = ((RadTextBox)pgVw.FindControl("txtPrinPracGroup")).Text;            //Principal Practice Group [Read-only]
                  //atty.tsepadmindt = ((RadDatePicker)pgVw.FindControl("txtAdminDate")).DateInput.SelectedDate;   //Equity Partner Admission Date [Read-only]
                  //atty.tsBarState = ((RadTextBox)pgVw.FindControl("txtBar")).Text;                     //Bar [Read-only]
                  atty.tscomment = ((RadTextBox)pgVw.FindControl("txtComment")).Text;                    //Comment
                  ctx.SaveChanges();

                  //ctx.LogUser(ntID, Global.REPORT_ID);

                  RadWindowManager1.RadAlert("Personal info updated", 225, 125, "Personal", "");

                  //*** Joanne Joe's request: Upon saving the record, please clear the screen of data ***
                  ResetAttyInfo();
                  //    1. Afterward, clear attorney option selected
                  foreach (GridDataItem dataItem in grdAtty.MasterTableView.Items)
                  {
                     RadioButton rb = (dataItem.FindControl("rbAtty") as RadioButton);
                     rb.Checked = false;
                     dataItem.Selected = false;
                  }
               }
            }
         }
      }
Пример #7
0
      /* Not needed
      protected void grdAtty_ItemDataBound(object sender, GridItemEventArgs e)
      {
         if (e.Item.IsInEditMode && e.Item is GridEditFormItem)      //FormTemplate
         // OR
         //if (e.Item.IsInEditMode && e.Item is GridEditableItem)
         {
            GridEditableItem editedItem = e.Item as GridEditableItem;
            RadGrid grid = (RadGrid)editedItem.FindControl("grdNewAtty");

            if (e.Item.OwnerTableView.IsItemInserted)
            {
               //This event occurs twice - before & after the actual insertion
               //*** item is about to be inserted ***
               //Populate controls in EditForm Template
               grid.DataBind();
            }
            else
            {
               //item is about to be edited
            }
         }
      }
      */

      protected void grdAtty_ItemCommand(object sender, GridCommandEventArgs e)
      {
         switch (e.CommandName)
         {
            //case RadGrid.InitInsertCommandName:             //"InitInsert"
            case RadGrid.FilterCommandName:
            case RadGrid.PageCommandName:
            case RadGrid.CancelCommandName:
               ResetAttyInfo();
               break;
            case RadGrid.PerformInsertCommandName:          //"PerformInsert"
               //GridDataInsertItem editItem = (GridDataInsertItem)grdAtty.MasterTableView.GetInsertItem();
               //string OrderId = (editItem["OrderID"].Controls[0] as TextBox).Text;
               //string ShipName = (editItem["ShipName"].Controls[0] as TextBox).Text;
               //DateTime OrderDate = Convert.ToDateTime((editItem["OrderDate"].Controls[0] as RadDatePicker).SelectedDate);

               /*
               //Automatic EditForms
               // http://www.telerik.com/community/forums/aspnet-ajax/grid/extracting-values-from-edited-items-in-a-radgrid-editform.aspx
               // http://demos.telerik.com/aspnet-ajax/grid/examples/dataediting/templateformupdate/defaultvb.aspx
               GridEditableItem editItem = e.Item as GridEditableItem;

               RadGrid grid = e.Item.FindControl("grdNewAtty") as RadGrid;

               //When using custom edit forms from template or user control, the ExtractValuesFromitem() method won't work for you, 
               //as it can extract values only from auto-generated grid edit forms
               Hashtable newValues = new Hashtable();
               e.Item.OwnerTableView.ExtractValuesFromItem(newValues, editItem);

               string sID = newValues["AttyID"].ToString();
               */

               GridEditFormInsertItem insItem = e.Item as GridEditFormInsertItem;
               GridTableView vw = insItem.FindControl("grdNewAtty").Controls[1] as GridTableView;

               foreach (GridDataItem item in vw.Items)
               {
                  RadioButton rb = (item["rbNewAttyTemplateColumn"].FindControl("rbNewAtty") as RadioButton);

                  if (rb.Checked)
                  {
                     string sType;
                     switch (item["TitleCode"].Text)
                     {
                        case "0":                        //Type: lw_pdsm.tstype
                        case "1":                        //   E:	Equity			   0-1
                           sType = "E";                  //   I:	Income
                           break;                        //   C:	Counsel			   2
                        case "2":                        //   O:	Of Counsel
                           sType = "C";                  //   A:	Associate		   3
                           break;
                        case "3":
                        default:
                           sType = "A";
                           break;
                     }

                     var atty = new Attorney
                     {
                        tstk = item["AttyID"].Text,
                        tsloc = item["Loc"].Text,     //Not nullable       
                        tsunits = 99999,              //Units
                        tsadjunits = 0,               //Adjusted Value
                        tsunitval = 0,                //Unit Value
                        tsfund = 0,                   //Pre-Fund Compensation
                        tspfund = 0,                  //Partner Fund
                        tsbonus = 0,                  //Bonus
                        tstype = sType,               //Type: Must be 'E','I','C','O','A' to be displayed; see uspLW1190_Attys
                        tstatus = "2",                //Rank
                        tsaudit_op = ntID,            //Modified by
                        LastModified = DateTime.Now   //Last Modifed
                     };

                     using (var ctx = new DBContext())
                     {
                        ctx.Attorneys.Add(atty);
                        ctx.SaveChanges();

                        //ctx.LogUser(ntID, Global.REPORT_ID);
                     }

                     Debug.WriteLine("grdAtty_ItemCommand --> ID:{0}, Location:{1}, Last:{2}, First:{3}, Title:{4}", item["AttyID"].Text, item["Loc"].Text, item["LastName"].Text, item["FirstName"].Text, item["Title"].Text);

                     //http://www.telerik.com/help/aspnet-ajax/grid-operate-with-filter-expression-manually.html
                     //Need to set [grdAtty.EnableLinqExpressions = false;] ELSE have to set 
                     //[grdAtty.MasterTableView.FilterExpression = "(it["Atty ID"].ToString().ToUpper().Contains("04819".ToUpper()))";]

                     //grdAtty.MasterTableView.FilterExpression = "([Atty ID] LIKE \'%" + item["AttyID"].Text + "%\')";
                     grdAtty.MasterTableView.FilterExpression = "([Atty ID] = \'" + item["AttyID"].Text + "\')";        //"([Atty ID] = '04592')"

                     GridColumn column = grdAtty.MasterTableView.GetColumnSafe("AttyID");
                     column.CurrentFilterFunction = GridKnownFunction.EqualTo;
                     column.CurrentFilterValue = item["AttyID"].Text;

                     grdAtty.MasterTableView.Rebind();

                     ResetAttyInfo();
                     break;
                  }
               }

               break;
            case RadGrid.DeleteCommandName:
               GridEditableItem editItem = e.Item as GridEditableItem;
               var pId = editItem.GetDataKeyValue("Atty ID").ToString();
               //OR e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["Atty ID"]

               using (var ctx = new DBContext())
               {
                  var atty = ctx.Attorneys.Find(pId);
                  // *** For cascade delete, explicitly load committees & salaries related to a given atty. ***
                  //ctx.Entry(atty).Collection(c => c.Committees).Load();    
                  //ctx.Entry(atty).Collection(s => s.Salaries).Load();
                  ctx.Entry(atty).Collection("Committees").Load();
                  ctx.Entry(atty).Collection("Salaries").Load();

                  ctx.Attorneys.Remove(atty);
                  ctx.SaveChanges();

                  //ctx.LogUser(ntID, Global.REPORT_ID);
               }

               //Clear filters
               foreach (GridColumn col in grdAtty.MasterTableView.Columns)
               {
                  col.CurrentFilterFunction = GridKnownFunction.NoFilter;
                  col.CurrentFilterValue = string.Empty;
               }
               grdAtty.MasterTableView.FilterExpression = string.Empty;
               grdAtty.MasterTableView.Rebind();

               ResetAttyInfo();
               break;
         }
      }
Пример #8
0
      protected void btnExportExcel_Click(object sender, EventArgs e)
      {
         //After page set idle for a while, the license object lost. 
         //To avoid the evaluation copy issue, we have to set license on every click
         Aspose.Cells.License license = new Aspose.Cells.License();
         license.SetLicense("Aspose.Total.lic");

         DataTable dtMain;

         using (var ctx = new DBContext())
         { 
            dtMain = ctx.getExportAttys();
            //ctx.LogUser(ntID, Global.REPORT_ID);
         }

         //Create a new worksheet
         Workbook workbook = new Workbook();
         Worksheet worksheet = workbook.Worksheets[0];
         Cells cells = worksheet.Cells;

         //Import data                
         cells.ImportDataTable(dtMain, true, 5, 0);

         //Create range and styles for the headings               
         Aspose.Cells.Style stl1 = workbook.Styles[workbook.Styles.Add()];
         stl1.VerticalAlignment = TextAlignmentType.Center;
         stl1.Font.Color = Color.Blue;
         stl1.Font.IsBold = true;
         stl1.Font.Name = "Arial";
         stl1.Font.Size = 10;
         StyleFlag flg = new StyleFlag();
         flg.Font = true;

         Range rngHd = cells.CreateRange("A1", "Z6");
         rngHd.ApplyStyle(stl1, flg);

         //Format the columns
         worksheet.AutoFitColumns();

         /*** TESTING ***
         // http://www.aspose.com/docs/display/cellsnet/Setting+Display+Formats+of+Numbers+and+Dates
         Aspose.Cells.Style stl2 = workbook.Styles[workbook.Styles.Add()];
         StyleFlag flg2 = new StyleFlag();
         stl2.Number = 15;
         cells.Columns[6].ApplyStyle(stl2, flg2);
         *** END TESTING ***/

         cells.SetColumnWidth(10, 45);    //Primary Practice Group
         cells.SetColumnWidth(11, 45);    //Bar

         // Populate header                
         cells[0, 0].PutValue("Report:");
         cells[0, 1].PutValue("LW1190 Brown Book Maintenance");

         TimeZoneInfo localZone = TimeZoneInfo.Local;
         string strRunDate = String.Format("{0:MM/dd/yyyy hh:mm tt}", DateTime.Now) +
                  " (" + ((localZone.IsDaylightSavingTime(DateTime.Now)) ? localZone.DaylightName : localZone.StandardName) + ")";
         cells[1, 0].PutValue("Run Date:");
         cells[1, 1].PutValue(strRunDate);

         cells[2, 0].PutValue("Report Type:");
         cells[2, 1].PutValue("Associates");

         //Save file to the client
         string sExcel = "LW1190";
         worksheet.Name = sExcel;
         sExcel += "_" + String.Format("{0:MM_dd_yyyy_hh_mm_ss_tt}", DateTime.Now) + ".xls";
         workbook.Save(this.Response, sExcel, ContentDisposition.Attachment, new XlsSaveOptions(SaveFormat.Excel97To2003));
      }
Пример #9
0
 protected void grdCommMstr_ItemCommand(object sender, GridCommandEventArgs e)
 {
    switch (e.CommandName)
    {
       case RadGrid.PerformInsertCommandName:
       case RadGrid.UpdateCommandName:
       case RadGrid.DeleteCommandName:
          using (var ctx = new DBContext())
             //ctx.LogUser(ntID, Global.REPORT_ID);
          break;
    }
 }