private void LoadGrid() { var showAll = (Conversion.TryCastString(this.Page.Request.QueryString["show"]).Equals("all")); this.BindGridView(); this.formGridView.Width = this.GetWidth(); this.pager.RecordCount = FormHelper.GetTotalRecords(this.ViewSchema, this.View); this.pager.PageSize = 10; if (this.PageSize != 0) { this.pager.PageSize = this.PageSize; } if (showAll) { this.pager.PageSize = 1000; } var userNameSessionKey = ConfigurationHelper.GetScrudParameter("UserNameSessionKey"); var officeCodeSessionKey = ConfigurationHelper.GetScrudParameter("OfficeCodeSessionKey"); this.userIdHidden.Value = SessionHelper.GetSessionValueByKey(userNameSessionKey); this.officeCodeHidden.Value = SessionHelper.GetSessionValueByKey(officeCodeSessionKey); }
private void BindGridView() { var showAll = (Conversion.TryCastString(this.Page.Request.QueryString["show"]).Equals("all")); var limit = 10; var offset = 0; if (this.PageSize != 0) { limit = this.PageSize; } if (showAll) { limit = 1000; } if (this.Page.Request["page"] != null) { offset = (Conversion.TryCastInteger(this.Page.Request["page"]) - 1) * limit; } using (var table = FormHelper.GetView(this.ViewSchema, this.View, this.KeyColumn, limit, offset)) { this.formGridView.DataSource = table; this.formGridView.DataBind(); } }
protected void DeleteButton_Click(object sender, EventArgs e) { var id = this.GetSelectedValue(); if (string.IsNullOrWhiteSpace(id)) { return; } if (this.DenyDelete) { this.messageLabel.CssClass = this.GetFailureCssClass(); this.messageLabel.Text = Titles.AccessDenied; return; } try { if (FormHelper.DeleteRecord(this.TableSchema, this.Table, this.KeyColumn, id)) { //Refresh the grid. this.BindGridView(); this.DisplaySuccess(); } } catch (MixERPException ex) { this.DisplayError(ex); //Swallow } }
protected void GoButton_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(this.GetSchema())) { return; } if (string.IsNullOrWhiteSpace(this.GetView())) { return; } using (var table = FormHelper.GetTable(this.GetSchema(), this.GetView(), this.filterDropDownList.SelectedItem.Value, this.filterTextBox.Text, 10)) { this.searchGridView.DataSource = table; this.searchGridView.DataBind(); } }
protected void DeleteButton_Click(object sender, EventArgs e) { var id = this.GetSelectedValue(); if (string.IsNullOrWhiteSpace(id)) { return; } if (this.DenyDelete) { this.messageLabel.CssClass = "failure"; this.messageLabel.Text = ScrudResource.AccessDenied; return; } if (FormHelper.DeleteRecord(this.TableSchema, this.Table, this.KeyColumn, id)) { //Refresh the grid. this.BindGridView(); this.DisplaySuccess(); } }
protected void EditButton_Click(object sender, EventArgs e) { var id = this.GetSelectedValue(); if (string.IsNullOrWhiteSpace(id)) { return; } using (var table = FormHelper.GetTable(this.TableSchema, this.Table, this.KeyColumn, id)) { if (table.Rows.Count.Equals(1)) { //Clear the form container. this.formContainer.Controls.Clear(); //Load the form again in the container with values //retrieved from database. this.LoadForm(this.formContainer, table); this.gridPanel.Attributes["style"] = "display:none;"; this.formPanel.Attributes["style"] = "display:block;"; } } }
// ReSharper disable once UnusedParameter.Local private void Save(bool closeForm) { var userIdSessionKey = ConfigurationHelper.GetScrudParameter("UserIdSessionKey"); if (!(Conversion.TryCastInteger(SessionHelper.GetSessionValueByKey(userIdSessionKey)) > 0)) { throw new InvalidOperationException("The user id session key is invalid or incorrectly configured."); } var list = this.GetFormCollection(true); var id = this.GetSelectedValue(); lastValueHiddenTextBox.Text = id; var userId = Conversion.TryCastInteger(this.Page.Session[userIdSessionKey]); if (string.IsNullOrWhiteSpace(id)) { if (this.DenyAdd) { this.messageLabel.CssClass = "failure"; this.messageLabel.Text = ScrudResource.AccessDenied; } else { var lastValue = FormHelper.InsertRecord(userId, this.TableSchema, this.Table, list, this.imageColumn); if (lastValue > 0) { lastValueHiddenTextBox.Text = lastValue.ToString(CultureInfo.InvariantCulture); //Clear the form container. this.formContainer.Controls.Clear(); using (var table = new DataTable()) { //Load the form again. this.LoadForm(this.formContainer, table); } //Refresh the grid. this.BindGridView(); this.DisplaySuccess(); } } } else { if (this.DenyEdit) { this.messageLabel.CssClass = "failure"; this.messageLabel.Text = ScrudResource.AccessDenied; } else { if (FormHelper.UpdateRecord(userId, this.TableSchema, this.Table, list, this.KeyColumn, id, this.imageColumn)) { //Clear the form container. this.formContainer.Controls.Clear(); //Load the form again. using (var table = new DataTable()) { table.Locale = Thread.CurrentThread.CurrentCulture; this.LoadForm(this.formContainer, table); } //Refresh the grid. this.BindGridView(); this.DisplaySuccess(); } else { this.messageLabel.CssClass = "failure"; this.messageLabel.Text = ScrudResource.UnknownError; } } } }
protected void SaveButton_Click(object sender, EventArgs e) { this.Page.Validate(); if (!this.Page.IsValid) { return; } if (this.SaveButtonClick != null) { this.SaveButtonClick(sender, e); return; } var userIdSessionKey = ConfigurationHelper.GetScrudParameter("UserIdSessionKey"); if (!(Conversion.TryCastInteger(SessionHelper.GetSessionValueByKey(userIdSessionKey)) > 0)) { throw new InvalidOperationException("The user id session key is invalid or incorrectly configured."); } var list = this.GetFormCollection(true); var id = this.GetSelectedValue(); var userId = Conversion.TryCastInteger(this.Page.Session[userIdSessionKey]); if (string.IsNullOrWhiteSpace(id)) { if (this.DenyAdd) { this.messageLabel.CssClass = "failure"; this.messageLabel.Text = ScrudResource.AccessDenied; } else { if (FormHelper.InsertRecord(userId, this.TableSchema, this.Table, list, this.imageColumn)) { //Clear the form container. this.formContainer.Controls.Clear(); using (var table = new DataTable()) { //Load the form again. this.LoadForm(this.formContainer, table); } //Refresh the grid. this.BindGridView(); this.DisplaySuccess(); } } } else { if (this.DenyEdit) { this.messageLabel.CssClass = "failure"; this.messageLabel.Text = ScrudResource.AccessDenied; } else { if (FormHelper.UpdateRecord(userId, this.TableSchema, this.Table, list, this.KeyColumn, id, this.imageColumn)) { //Clear the form container. this.formContainer.Controls.Clear(); //Load the form again. using (var table = new DataTable()) { table.Locale = Thread.CurrentThread.CurrentCulture; this.LoadForm(this.formContainer, table); } //Refresh the grid. this.BindGridView(); this.DisplaySuccess(); } else { this.messageLabel.CssClass = "failure"; this.messageLabel.Text = ScrudResource.UnknownError; } } } }