public BoothInfoDTO populate_all(SqlDataReader reader) { try { BoothInfoDTO dto = new BoothInfoDTO(); BranchInfoDTO oBranchInfoDTO = new BranchInfoDTO(); BranchTypeInfoDTO oBranchTypeInfoDTO = new BranchTypeInfoDTO(); oBranchTypeInfoDTO.BT_Name = (string)reader["BType_Name"]; oBranchInfoDTO.BranchCode = (string)reader["BranchCode"]; oBranchInfoDTO.BranchName = (string)reader["BranchName"]; oBranchInfoDTO.ContactPerson = (string)reader["ContactPerson"]; oBranchInfoDTO.BranchAddress = (string)reader["BranchAddress"]; oBranchInfoDTO.Telephone1 = (string)reader["Telephone1"]; oBranchInfoDTO.Telephone2 = (string)reader["Telephone2"]; oBranchInfoDTO.Fax = (string)reader["Fax"]; oBranchInfoDTO.EMail = (string)reader["EMail"]; oBranchInfoDTO.CashInSafeLimit = (decimal)reader["CashInSafeLimit"]; dto.BoothNo = (Int16)reader["BoothNo"]; dto.BoothCashLimit = (decimal)reader["BoothCashLimit"]; dto.BoothStatus = (bool)reader["BoothStatus"]; dto.MachineID = (string)reader["MachineID"]; dto.BranchCode = oBranchInfoDTO; dto.BranchCode.BranchTypeInfoDTO = oBranchTypeInfoDTO; return(dto); } catch (Exception Exp) { throw Exp; } }
public override void Delete(object obj) { BranchTypeInfoDTO oSupplierInfoDTO = (BranchTypeInfoDTO)obj; SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString()); String sql = "Delete BranchTypeInfo where BT_PK=@BT_PK"; SqlCommand objCmdDelete = sqlConn.CreateCommand(); objCmdDelete.CommandText = sql; try { objCmdDelete.Parameters.Add("@BT_PK", SqlDbType.UniqueIdentifier, 16); objCmdDelete.Parameters["@BT_PK"].Value = (Guid)oSupplierInfoDTO.PrimaryKey; sqlConn.Open(); objCmdDelete.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { objCmdDelete.Dispose(); objCmdDelete.Cancel(); sqlConn.Dispose(); sqlConn.Close(); } }
private void getPKCode(BranchTypeInfoDTO obj) { SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString()); string strPKCode = null; int PKSL = 0; string sqlSelect = "Select isnull(Max(BT_Code),0)+1 From BranchTypeInfo"; SqlCommand objCmd = sqlConn.CreateCommand(); objCmd.CommandText = sqlSelect; try { sqlConn.Open(); PKSL = (int)objCmd.ExecuteScalar(); } catch (Exception Exp) { throw Exp; } finally { objCmd.Dispose(); objCmd.Cancel(); sqlConn.Dispose(); sqlConn.Close(); } strPKCode = PKSL.ToString("0"); obj.BT_Code = strPKCode; //return strPKCode; }
protected void btnAdd_Click(object sender, EventArgs e) { if (this.lblErrorMessage.Text.Length != 0) { this.lblErrorMessage.Text = ""; } if (this.txtBT_Name.Text.Length == 0) { this.lblErrorMessage.Text = "Branch type name field can not be blank."; this.txtBT_Name.Focus(); return; } BranchTypeInfoDTO btdto = Populate(); try { Facade facade = Facade.GetInstance(); IBranchTypeInfoBL oBranchTypeInfoBL = facade.createBranchTypeBL(); oBranchTypeInfoBL.addNewBranchTypeRecord(btdto); this.lblErrorMessage.Text = "Data Save Successfully."; } catch (Exception Exp) { lblErrorMessage.Text = cls.ErrorString(Exp); } GridView1.DataBind(); ControlState_Refresh(); }
protected void GridView1_RowEditing(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "Edit") { BranchTypeInfoDTO oBranchTypeInfoDTO = new BranchTypeInfoDTO(); int index = Convert.ToInt32(e.CommandArgument); GridViewRow row = this.GridView1.Rows[index]; this.txtBT_Name.Text = Server.HtmlDecode(row.Cells[2].Text); //this.Text = Server.HtmlDecode(row.Cells[].Text); DataKey dk = this.GridView1.DataKeys[index]; this.txtBT_PK.Value = dk.Value.ToString(); Facade facade = Facade.GetInstance(); oBranchTypeInfoDTO = facade.getBranchTypeInfo((Guid)TypeDescriptor.GetConverter(oBranchTypeInfoDTO.PrimaryKey).ConvertFromString(this.txtBT_PK.Value)); this.txtBT_Code.Text = oBranchTypeInfoDTO.BT_Code; this.txtBT_Name.Text = oBranchTypeInfoDTO.BT_Name; this.btnAdd.Text = "Update"; this.txtBT_Name.Focus(); } } catch (Exception Exp) { lblErrorMessage.Text = cls.ErrorString(Exp); } }
protected void GridView1_RowEditing(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "Edit") { BranchInfoDTO odto = new BranchInfoDTO(); int index = Convert.ToInt32(e.CommandArgument); GridViewRow row = GridView1.Rows[index]; DataKey dk = GridView1.DataKeys[index]; this.txtBR_PK.Value = dk.Value.ToString(); Facade facade = Facade.GetInstance(); odto = facade.getBranchInfoDTO((Guid)TypeDescriptor.GetConverter(odto.PrimaryKey).ConvertFromString(this.txtBR_PK.Value)); this.txtBranchCode.Text = odto.BranchCode; BranchTypeInfoDTO btDto = new BranchTypeInfoDTO(); btDto = facade.getBranchTypeInfo((Guid)odto.BT_PK); if (btDto.PrimaryKey.ToString() == "00000000-0000-0000-0000-000000000000") { this.ddlBranchType.SelectedValue = ""; } else { this.ddlBranchType.SelectedValue = btDto.PrimaryKey.ToString(); } this.txtBranchName.Text = odto.BranchName; this.txtContactPerson.Text = odto.ContactPerson; this.txtContactPersonPhone.Text = odto.ContactPersonPhone; this.txtBranchPrefix.Text = odto.BranchPrefix; this.txtBranchAddress.Text = odto.BranchAddress; this.txtTelephone1.Text = odto.Telephone1; this.txtTelephone2.Text = odto.Telephone2; this.txtTelephone3.Text = odto.Telephone3; this.txtFax.Text = odto.Fax; this.txtEMail.Text = odto.EMail; this.txtCashInSafeLimit.Text = odto.CashInSafeLimit.ToString(); this.btnAdd.Text = "Update"; this.txtBranchName.Focus(); //this.Text = Server.HtmlDecode(row.Cells[].Text); } } catch (Exception Exp) { lblErrorMessage.Text = cls.ErrorString(Exp); } }
public BranchTypeInfoDTO findByPKDTO(Guid pk) { BranchTypeInfoDTO oBranchTypeInfoDTO = new BranchTypeInfoDTO(); //oBranchTypeInfoDTO.PrimaryKey = pk; string sqlSelect = "Select BT_PK,BT_Code,BT_Name,EntryBy,EntryDate From BranchTypeInfo where BT_PK=@BT_PK"; SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString()); SqlCommand objCmd = sqlConn.CreateCommand(); objCmd.CommandText = sqlSelect; objCmd.Connection = sqlConn; try { objCmd.Parameters.Add("@BT_PK", SqlDbType.UniqueIdentifier, 16); objCmd.Parameters["@BT_PK"].Value = pk; sqlConn.Open(); SqlDataReader thisReader = objCmd.ExecuteReader(); while (thisReader.Read()) { oBranchTypeInfoDTO = populate(thisReader); } thisReader.Close(); thisReader.Dispose(); } catch (Exception ex) { throw ex; } finally { objCmd.Dispose(); objCmd.Cancel(); sqlConn.Dispose(); sqlConn.Close(); } return(oBranchTypeInfoDTO); }
public BranchTypeInfoDTO populate(SqlDataReader reader) { try { BranchTypeInfoDTO dto = new BranchTypeInfoDTO(); dto.PrimaryKey = (Guid)reader["BT_PK"]; dto.BT_Code = (string)reader["BT_Code"]; dto.BT_Name = (string)reader["BT_Name"]; dto.EntryBy = (string)reader["EntryBy"]; dto.EntryDate = (DateTime)reader["EntryDate"]; return(dto); } catch (Exception Exp) { throw Exp; } }
public List <BranchTypeInfoDTO> getBranchTypeInfoData() { string sqlSelect = "Select BT_PK,BT_Code,BT_Name,EntryBy,EntryDate From BranchTypeInfo order by BT_Code"; SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString()); List <BranchTypeInfoDTO> oArrayList = new List <BranchTypeInfoDTO>(); SqlCommand objCmd = sqlConn.CreateCommand(); objCmd.CommandText = sqlSelect; objCmd.Connection = sqlConn; try { sqlConn.Open(); SqlDataReader thisReader = objCmd.ExecuteReader(); while (thisReader.Read()) { BranchTypeInfoDTO oBranchTypeInfoDTO = populate(thisReader); oArrayList.Add(oBranchTypeInfoDTO); } thisReader.Close(); thisReader.Dispose(); } catch (Exception ex) { throw ex; } finally { objCmd.Dispose(); objCmd.Cancel(); sqlConn.Dispose(); sqlConn.Close(); } return(oArrayList); }
private BranchTypeInfoDTO Populate() { try { BranchTypeInfoDTO dto = new BranchTypeInfoDTO(); if (this.txtBT_PK.Value.ToString() != "") { dto.PrimaryKey = (Guid)TypeDescriptor.GetConverter(dto.PrimaryKey).ConvertFromString(this.txtBT_PK.Value); } dto.BT_Code = this.txtBT_Code.Text; dto.BT_Name = this.txtBT_Name.Text; dto.EntryBy = Constants.DEFULT_USER; dto.EntryDate = DateTime.Today; return(dto); } catch (Exception Exp) { throw Exp; } }
public override void Save(object obj) { BranchTypeInfoDTO oBranchTypeInfoDTO = (BranchTypeInfoDTO)obj; SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString()); SqlCommand objCmd = sqlConn.CreateCommand(); if (oBranchTypeInfoDTO.PrimaryKey.ToString() == "00000000-0000-0000-0000-000000000000") { //string strset = getPKCode(oProductCategoryInfoDTO); String sql = "Insert Into BranchTypeInfo(BT_Code,BT_Name,EntryBy,EntryDate) values(@BT_Code,@BT_Name,@EntryBy,@EntryDate)"; try { getPKCode(oBranchTypeInfoDTO); objCmd.CommandText = sql; objCmd.Parameters.Add(new SqlParameter("@BT_Code", SqlDbType.VarChar, 1)); objCmd.Parameters.Add(new SqlParameter("@BT_Name", SqlDbType.VarChar, 50)); objCmd.Parameters.Add(new SqlParameter("@EntryBy", SqlDbType.VarChar, 5)); objCmd.Parameters.Add(new SqlParameter("@EntryDate", SqlDbType.DateTime)); objCmd.Parameters["@BT_Code"].Value = Convert.ToString(oBranchTypeInfoDTO.BT_Code); objCmd.Parameters["@BT_Name"].Value = Convert.ToString(oBranchTypeInfoDTO.BT_Name); objCmd.Parameters["@EntryBy"].Value = Convert.ToString(oBranchTypeInfoDTO.EntryBy); objCmd.Parameters["@EntryDate"].Value = Convert.ToDateTime(oBranchTypeInfoDTO.EntryDate); sqlConn.Open(); objCmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { objCmd.Dispose(); objCmd.Cancel(); sqlConn.Close(); sqlConn.Dispose(); } } else { String sql = "Update BranchTypeInfo set BT_Name=@BT_Name,EntryBy=@EntryBy,EntryDate=@EntryDate where BT_PK=@BT_PK"; try { objCmd.CommandText = sql; objCmd.Parameters.Add(new SqlParameter("@BT_PK", SqlDbType.UniqueIdentifier, 16)); objCmd.Parameters.Add(new SqlParameter("@BT_Name", SqlDbType.VarChar, 50)); objCmd.Parameters.Add(new SqlParameter("@EntryBy", SqlDbType.VarChar, 5)); objCmd.Parameters.Add(new SqlParameter("@EntryDate", SqlDbType.DateTime)); objCmd.Parameters["@BT_PK"].Value = (Guid)oBranchTypeInfoDTO.PrimaryKey; objCmd.Parameters["@BT_Name"].Value = Convert.ToString(oBranchTypeInfoDTO.BT_Name); objCmd.Parameters["@EntryBy"].Value = Convert.ToString(oBranchTypeInfoDTO.EntryBy); objCmd.Parameters["@EntryDate"].Value = Convert.ToDateTime(oBranchTypeInfoDTO.EntryDate); sqlConn.Open(); objCmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { objCmd.Dispose(); objCmd.Cancel(); sqlConn.Dispose(); sqlConn.Close(); } } }