public ReceiptDetails Details(string Module) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = SQLSelect() + "WHERE Module = @Module;"; cmd.Parameters.AddWithValue("Module", Module); cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); ReceiptDetails Details = new ReceiptDetails(); foreach (System.Data.DataRow dr in dt.Rows) { Details.Module = "" + dr["Module"].ToString(); Details.Text = "" + dr["Text"].ToString(); Details.Value = "" + dr["Value"].ToString(); Details.Orientation = (ReportFormatOrientation)Enum.Parse(typeof(ReportFormatOrientation), dr["Orientation"].ToString()); } return(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Save(ReceiptDetails Details) { try { string SQL = "CALL procSaveReceipt(@ReceiptID, @Module, @Text, @Value, @Orientation, @CreatedOn, @LastModified);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("ReceiptID", Details.ReceiptID); cmd.Parameters.AddWithValue("Module", Details.Module); cmd.Parameters.AddWithValue("Text", Details.Text); cmd.Parameters.AddWithValue("Value", Details.Value); cmd.Parameters.AddWithValue("Orientation", Details.Orientation.ToString("d")); cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn); cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified); return(base.ExecuteNonQuery(cmd)); } catch (Exception ex) { throw base.ThrowException(ex); } }
public void Update(ReceiptDetails Details) { try { Save(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
public System.Data.DataTable ListAsDataTable(ReceiptDetails ReceiptDetails, string SortField = "ReceiptID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = SQLSelect() + "WHERE 1=1 "; if (ReceiptDetails.ReceiptID != 0) { SQL += "AND ReceiptID = @ReceiptID) "; cmd.Parameters.AddWithValue("@ReceiptID", ReceiptDetails.ReceiptID); } if (!string.IsNullOrEmpty(ReceiptDetails.Module)) { SQL += "AND Module = @Module) "; cmd.Parameters.AddWithValue("@Module", ReceiptDetails.Module); } if (!string.IsNullOrEmpty(ReceiptDetails.Value)) { SQL += "AND Value = @Value) "; cmd.Parameters.AddWithValue("@Value", ReceiptDetails.Value); } SQL += "ORDER BY " + SortField + " "; SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC "; SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " "; cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return(dt); } catch (Exception ex) { throw base.ThrowException(ex); } }
public System.Data.DataTable ListAsDataTable(ReceiptDetails ReceiptDetails, string SortField = "ReceiptID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = SQLSelect() + "WHERE 1=1 "; if (ReceiptDetails.ReceiptID != 0) { SQL += "AND ReceiptID = @ReceiptID) "; cmd.Parameters.AddWithValue("@ReceiptID", ReceiptDetails.ReceiptID); } if (!string.IsNullOrEmpty(ReceiptDetails.Module)) { SQL += "AND Module = @Module) "; cmd.Parameters.AddWithValue("@Module", ReceiptDetails.Module); } if (!string.IsNullOrEmpty(ReceiptDetails.Value)) { SQL += "AND Value = @Value) "; cmd.Parameters.AddWithValue("@Value", ReceiptDetails.Value); } SQL += "ORDER BY " + SortField + " "; SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC "; SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " "; cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); return dt; } catch (Exception ex) { throw base.ThrowException(ex); } }
public ReceiptDetails Details(string Module) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL= SQLSelect() + "WHERE Module = @Module;"; cmd.Parameters.AddWithValue("Module", Module); cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); ReceiptDetails Details = new ReceiptDetails(); foreach (System.Data.DataRow dr in dt.Rows) { Details.Module = "" + dr["Module"].ToString(); Details.Text = "" + dr["Text"].ToString(); Details.Value = "" + dr["Value"].ToString(); Details.Orientation = (ReportFormatOrientation) Enum.Parse(typeof(ReportFormatOrientation), dr["Orientation"].ToString()); } return Details; } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Save(ReceiptDetails Details) { try { string SQL = "CALL procSaveReceipt(@ReceiptID, @Module, @Text, @Value, @Orientation, @CreatedOn, @LastModified);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("ReceiptID", Details.ReceiptID); cmd.Parameters.AddWithValue("Module", Details.Module); cmd.Parameters.AddWithValue("Text", Details.Text); cmd.Parameters.AddWithValue("Value", Details.Value); cmd.Parameters.AddWithValue("Orientation", Details.Orientation.ToString("d")); cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn); cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified); return base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
private void SaveRecord() { DropDownList cboOrientationBox; DropDownList cboBox; TextBox txtBox; int iCtr = 1; Receipt clsReceipt = new Receipt(); ReceiptDetails clsDetails = new ReceiptDetails(); clsDetails.Module = "ReportHeaderSpacer"; clsDetails.Value = txtReportHeaderSpacer.Text; clsReceipt.Update(clsDetails); for (iCtr=1;iCtr<=10;iCtr++) { cboOrientationBox = (DropDownList) this.FindControl("cboReportHeaderOrientation" + iCtr); cboBox = (DropDownList) this.FindControl("cboReportHeader" + iCtr); txtBox = (TextBox) this.FindControl("txtReportHeader" + iCtr); clsDetails.Module = "ReportHeader" + iCtr; clsDetails.Text = txtBox.Text; clsDetails.Value = cboBox.SelectedItem.Value.ToString(); clsDetails.Orientation = (ReportFormatOrientation) Enum.Parse(typeof(ReportFormatOrientation),cboOrientationBox.SelectedItem.Value.ToString()); clsReceipt.Update(clsDetails); } for (iCtr=1;iCtr<=10;iCtr++) { cboOrientationBox = (DropDownList) this.FindControl("cboPageHeaderOrientation" + iCtr); cboBox = (DropDownList) this.FindControl("cboPageHeader" + iCtr); txtBox = (TextBox) this.FindControl("txtPageHeader" + iCtr); clsDetails.Module = "PageHeader" + iCtr; clsDetails.Text = txtBox.Text; clsDetails.Value = cboBox.SelectedItem.Value.ToString(); clsDetails.Orientation = (ReportFormatOrientation) Enum.Parse(typeof(ReportFormatOrientation),cboOrientationBox.SelectedItem.Value.ToString()); clsReceipt.Update(clsDetails); } for (iCtr=1;iCtr<=20;iCtr++) { cboOrientationBox = (DropDownList) this.FindControl("cboPageFooterAOrientation" + iCtr); cboBox = (DropDownList) this.FindControl("cboPageFooterA" + iCtr); txtBox = (TextBox) this.FindControl("txtPageFooterA" + iCtr); clsDetails.Module = "PageFooterA" + iCtr; clsDetails.Text = txtBox.Text; clsDetails.Value = cboBox.SelectedItem.Value.ToString(); clsDetails.Orientation = (ReportFormatOrientation) Enum.Parse(typeof(ReportFormatOrientation),cboOrientationBox.SelectedItem.Value.ToString()); clsReceipt.Update(clsDetails); } for (iCtr=1;iCtr<=5;iCtr++) { cboOrientationBox = (DropDownList) this.FindControl("cboPageFooterBOrientation" + iCtr); cboBox = (DropDownList) this.FindControl("cboPageFooterB" + iCtr); txtBox = (TextBox) this.FindControl("txtPageFooterB" + iCtr); clsDetails.Module = "PageFooterB" + iCtr; clsDetails.Text = txtBox.Text; clsDetails.Value = cboBox.SelectedItem.Value.ToString(); clsDetails.Orientation = (ReportFormatOrientation) Enum.Parse(typeof(ReportFormatOrientation),cboOrientationBox.SelectedItem.Value.ToString()); clsReceipt.Update(clsDetails); } for (iCtr=1;iCtr<=5;iCtr++) { cboOrientationBox = (DropDownList) this.FindControl("cboReportFooterOrientation" + iCtr); cboBox = (DropDownList) this.FindControl("cboReportFooter" + iCtr); txtBox = (TextBox) this.FindControl("txtReportFooter" + iCtr); clsDetails.Module = "ReportFooter" + iCtr; clsDetails.Text = txtBox.Text; clsDetails.Value = cboBox.SelectedItem.Value.ToString(); clsDetails.Orientation = (ReportFormatOrientation) Enum.Parse(typeof(ReportFormatOrientation),cboOrientationBox.SelectedItem.Value.ToString()); clsReceipt.Update(clsDetails); } clsDetails.Module = "ReportFooterSpacer"; clsDetails.Value = txtReportFooterSpacer.Text; clsReceipt.Update(clsDetails); clsReceipt.CommitAndDispose(); }