public BranchInfoDTO populate(SqlDataReader reader)
{
try
{
BranchInfoDTO dto = new BranchInfoDTO();
dto.PrimaryKey = (Guid)reader["BR_PK"];
dto.BT_PK = (Guid)reader["BT_PK"];
dto.BranchCode = (string)reader["BranchCode"];
dto.BranchName = (string)reader["BranchName"];
dto.ContactPerson = (string)reader["ContactPerson"];
dto.ContactPersonPhone = (string)reader["ContactPersonPhone"];
dto.BranchPrefix = (string)reader["BranchPrefix"];
dto.BranchAddress = (string)reader["BranchAddress"];
dto.Telephone1 = (string)reader["Telephone1"];
dto.Telephone2 = (string)reader["Telephone2"];
dto.Telephone3 = (string)reader["Telephone3"];
dto.Fax = (string)reader["Fax"];
dto.EMail = (string)reader["EMail"];
dto.CashInSafeLimit = (Decimal)reader["CashInSafeLimit"];
////dto = (string)reader[""];
dto.EntryBy = (string)reader["EntryBy"];
dto.EntryDate = (DateTime)reader["EntryDate"];
return(dto);
}
catch (Exception Exp)
{
throw Exp;
}
}
private string Get_BranchInfoCode(BranchInfoDTO Obj)
{
string brcode = null;
int brcodeno = 0;
SqlConnection objmycon = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString());
try
{
SqlCommand objcmd = new SqlCommand();
objcmd.CommandText = "Select Isnull(Max(cast(BranchCode as int)),0 )+1 from BranchInfo";
objmycon.Open();
objcmd.Connection = objmycon;
brcodeno = (int)objcmd.ExecuteScalar();
}
catch (Exception Exp)
{
throw Exp;
}
finally
{
objmycon.Close();
}
brcode = brcodeno.ToString("000");
return(brcode);
}
private BranchInfoDTO Populate()
{
string strBT_PK;
BranchInfoDTO dto = new BranchInfoDTO();
if (this.txtBR_PK.Value.ToString() != "")
{
dto.PrimaryKey = (Guid)TypeDescriptor.GetConverter(dto.PrimaryKey).ConvertFromString(this.txtBR_PK.Value);
}
Guid nullGuid = Guid.NewGuid();
nullGuid = (Guid)TypeDescriptor.GetConverter(nullGuid).ConvertFromString("00000000-0000-0000-0000-000000000000");
strBT_PK = (string)this.ddlBranchType.SelectedValue;
dto.BT_PK = strBT_PK == string.Empty ? nullGuid : (Guid)TypeDescriptor.GetConverter(dto.BT_PK).ConvertFromString(strBT_PK);
dto.BranchCode = this.txtBranchCode.Text;
dto.BranchName = this.txtBranchName.Text;
dto.ContactPerson = this.txtContactPerson.Text;
dto.ContactPersonPhone = this.txtContactPersonPhone.Text;
dto.BranchPrefix = this.txtBranchPrefix.Text;
dto.BranchAddress = this.txtBranchAddress.Text;
dto.Telephone1 = this.txtTelephone1.Text;
dto.Telephone2 = this.txtTelephone2.Text;
dto.Telephone3 = this.txtTelephone3.Text;
dto.Fax = this.txtFax.Text;
dto.EMail = this.txtEMail.Text;
dto.CashInSafeLimit = (Decimal)TypeDescriptor.GetConverter(dto.CashInSafeLimit).ConvertFromString(this.txtCashInSafeLimit.Text);
dto.EntryBy = Constants.DEFULT_USER;
dto.EntryDate = DateTime.Today;
return(dto);
}
public override void Delete(object obj)
{
BranchInfoDTO oProductUnitInfoDto = (BranchInfoDTO)obj;
SqlConnection objmycon = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString());
SqlCommand objcmd = new SqlCommand();
objcmd.CommandText = "Delete From BranchInfo WHERE BR_PK=@BR_PK";
objcmd.Parameters.Add(new SqlParameter("@BR_PK", SqlDbType.UniqueIdentifier, 16));
objcmd.Parameters["@BR_PK"].Value = (Guid)oProductUnitInfoDto.PrimaryKey;
objcmd.Connection = objmycon;
try
{
objmycon.Open();
objcmd.ExecuteNonQuery();
}
catch (Exception Exp)
{
throw Exp;
}
finally
{
objmycon.Close();
//objCmdDelete.Dispose();
//objCmdDelete.Cancel();
}
}
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;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (this.lblErrorMessage.Text.Length != 0)
{
this.lblErrorMessage.Text = "";
}
if (this.txtBranchName.Text.Length == 0)
{
this.lblErrorMessage.Text = "Branch Name field can not be blank. Please Insert";
txtBranchName.Focus();
return;
}
else if (this.txtBranchAddress.Text.Length == 0)
{
this.lblErrorMessage.Text = "Branch Address field can not be blank. Please Insert";
this.txtBranchAddress.Focus();
return;
}
else if (this.txtCashInSafeLimit.Text.Length == 0)
{
this.lblErrorMessage.Text = "Cash In Safe Limit field can not be blank.You must enter a number.";
this.txtCashInSafeLimit.Focus();
return;
}
try
{
BranchInfoDTO brdto = Populate();
IBranchInfoBL brFacade = Facade.GetInstance().createBranchBL();
brFacade.addNewBranch(brdto);
this.lblErrorMessage.Text = "Data Save Successfully.";
this.txtBR_PK.Value = "";
int codeno = 0;
string num;
int brcodeno = Convert.ToInt32(brdto.BranchCode);
codeno = (brcodeno + 1);
num = codeno.ToString("000");
GridView1.DataBind();
}
catch (Exception Exp)
{
lblErrorMessage.Text = cls.ErrorString(Exp);
}
finally
{
Initilize_Page_Control();
}
}
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 BranchInfoDTO findByPK(Guid pk)
{
BranchInfoDTO oBranchInfoDTO = new BranchInfoDTO();
string sqlSelect = "Select BR_PK,BT_PK,BranchCode,BranchName,ContactPerson,ContactPersonPhone,BranchPrefix,BranchAddress,Telephone1,Telephone2,Telephone3,Fax,EMail,CashInSafeLimit,EntryBy,EntryDate From BranchInfo where BR_PK=@BR_PK";
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString());
SqlCommand objCmd = sqlConn.CreateCommand();
try
{
objCmd.CommandText = sqlSelect;
objCmd.Connection = sqlConn;
objCmd.Parameters.Add("@BR_PK", SqlDbType.UniqueIdentifier, 16);
objCmd.Parameters["@BR_PK"].Value = pk;
sqlConn.Open();
SqlDataReader thisReader = objCmd.ExecuteReader();
while (thisReader.Read())
{
oBranchInfoDTO = populate(thisReader);
}
thisReader.Close();
thisReader.Dispose();
}
catch (Exception Exp)
{
throw Exp;
}
finally
{
objCmd.Dispose();
objCmd.Cancel();
sqlConn.Dispose();
sqlConn.Close();
}
return(oBranchInfoDTO);
}
protected void GridView1_RowEdting(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "Edit")
{
BoothInfoDTO oBoothInfoDTO = new BoothInfoDTO();
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = GridView1.Rows[index];
DataKey xx = this.GridView1.DataKeys[index];
this.txtHideFieldPK.Value = xx.Value.ToString();
Facade facade = Facade.GetInstance();
oBoothInfoDTO = facade.getBoothInfoDTO((Guid)TypeDescriptor.GetConverter(oBoothInfoDTO.PrimaryKey).ConvertFromString(this.txtHideFieldPK.Value));
this.txtCashLimit.Text = oBoothInfoDTO.BoothCashLimit.ToString();
this.chkBoothStatus.Checked = oBoothInfoDTO.BoothStatus;
BranchInfoDTO bDto = new BranchInfoDTO();
bDto = facade.getBranchInfoDTO((Guid)oBoothInfoDTO.BR_PK);
if (bDto.PrimaryKey.ToString() == "00000000-0000-0000-0000-000000000000")
{
this.ddlBranchName.SelectedValue = "";
}
else
{
this.ddlBranchName.SelectedValue = bDto.PrimaryKey.ToString();
}
this.lblErrorMessage.Text = "";
this.btnSave.Text = "Update";
}
}
catch (Exception Exp)
{
lblErrorMessage.Text = cls.ErrorString(Exp);
}
}
public List <BranchInfoDTO> GetBranchInfo()
{
List <BranchInfoDTO> productUnitList = new List <BranchInfoDTO>();
SqlConnection objmycon = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString());
SqlCommand objcmd = new SqlCommand();
try
{
objcmd.Connection = objmycon;
objcmd.CommandText = "SELECT BR_PK,BT_PK,BranchCode,BranchName,ContactPerson,ContactPersonPhone,BranchPrefix,BranchAddress,Telephone1,Telephone2,Telephone3,Fax,EMail,CashInSafeLimit,EntryBy,EntryDate FROM BranchInfo ORDER BY BranchCode DESC";
objmycon.Open();
SqlDataReader thisReader = objcmd.ExecuteReader();
while (thisReader.Read())
{
BranchInfoDTO oProductUnitInfoDto = populate(thisReader);
productUnitList.Add(oProductUnitInfoDto);
}
thisReader.Close();
thisReader.Dispose();
}
catch (Exception ex)
{
throw ex;
}
finally
{
objcmd.Dispose();
objcmd.Cancel();
objmycon.Close();
}
return(productUnitList);
}
public override void Save(object Obj)
{
BranchInfoDTO btInfo = (BranchInfoDTO)Obj;
SqlConnection objmycon = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString());
try
{
SqlCommand objcmd = new SqlCommand();
if (btInfo.PrimaryKey.ToString() == "00000000-0000-0000-0000-000000000000")
{
btInfo.BranchCode = Get_BranchInfoCode(btInfo);
objcmd.CommandText = "Insert Into BranchInfo(BT_PK,BranchCode,BranchName,ContactPerson,ContactPersonPhone,BranchPrefix,BranchAddress,Telephone1,Telephone2,Telephone3,Fax,EMail,CashInSafeLimit,EntryBy,EntryDate) Values(@BT_PK,@BranchCode,@BranchName,@ContactPerson,@ContactPersonPhone,@BranchPrefix,@BranchAddress,@Telephone1,@Telephone2,@Telephone3,@Fax,@EMail,@CashInSafeLimit,@EntryBy,@EntryDate)";
objcmd.Parameters.Add(new SqlParameter("@BT_PK", SqlDbType.UniqueIdentifier, 16));
objcmd.Parameters.Add(new SqlParameter("@BranchCode", SqlDbType.VarChar, 3));
objcmd.Parameters.Add(new SqlParameter("@BranchName", SqlDbType.VarChar, 50));
objcmd.Parameters.Add(new SqlParameter("@ContactPerson", SqlDbType.VarChar, 50));
objcmd.Parameters.Add(new SqlParameter("@ContactPersonPhone", SqlDbType.VarChar, 15));
objcmd.Parameters.Add(new SqlParameter("@BranchPrefix", SqlDbType.VarChar, 3));
objcmd.Parameters.Add(new SqlParameter("@BranchAddress", SqlDbType.VarChar, 150));
objcmd.Parameters.Add(new SqlParameter("@Telephone1", SqlDbType.VarChar, 15));
objcmd.Parameters.Add(new SqlParameter("@Telephone2", SqlDbType.VarChar, 15));
objcmd.Parameters.Add(new SqlParameter("@Telephone3", SqlDbType.VarChar, 15));
objcmd.Parameters.Add(new SqlParameter("@Fax", SqlDbType.VarChar, 25));
objcmd.Parameters.Add(new SqlParameter("@EMail", SqlDbType.VarChar, 25));
objcmd.Parameters.Add(new SqlParameter("@CashInSafeLimit", SqlDbType.VarChar, 9));
//objcmd.Parameters.Add(new SqlParameter("@", SqlDbType.VarChar, ));
objcmd.Parameters.Add(new SqlParameter("@EntryBy", SqlDbType.VarChar, 5));
objcmd.Parameters.Add(new SqlParameter("@EntryDate", SqlDbType.DateTime, 8));
objcmd.Parameters["@BT_PK"].Value = (Guid)btInfo.BT_PK;
objcmd.Parameters["@BranchCode"].Value = (string)btInfo.BranchCode;
objcmd.Parameters["@BranchName"].Value = (string)btInfo.BranchName;
objcmd.Parameters["@ContactPerson"].Value = (string)btInfo.ContactPerson;
objcmd.Parameters["@ContactPersonPhone"].Value = (string)btInfo.ContactPersonPhone;
objcmd.Parameters["@BranchPrefix"].Value = (string)btInfo.BranchPrefix;
objcmd.Parameters["@BranchAddress"].Value = (string)btInfo.BranchAddress;
objcmd.Parameters["@Telephone1"].Value = (string)btInfo.Telephone1;
objcmd.Parameters["@Telephone2"].Value = (string)btInfo.Telephone2;
objcmd.Parameters["@Telephone3"].Value = (string)btInfo.Telephone3;
objcmd.Parameters["@Fax"].Value = (string)btInfo.Fax;
objcmd.Parameters["@EMail"].Value = (string)btInfo.EMail;
objcmd.Parameters["@CashInSafeLimit"].Value = (Decimal)btInfo.CashInSafeLimit;
//objcmd.Parameters["@"].Value = (string)brInfo.
objcmd.Parameters["@EntryBy"].Value = (string)btInfo.EntryBy;
objcmd.Parameters["@EntryDate"].Value = (DateTime)btInfo.EntryDate;
}
else
{
objcmd.CommandText = "Update BranchInfo set BT_PK=@BT_PK, BranchName=@BranchName,ContactPerson=@ContactPerson,ContactPersonPhone=@ContactPersonPhone,BranchPrefix=@BranchPrefix,BranchAddress=@BranchAddress,Telephone1=@Telephone1,Telephone2=@Telephone2,Telephone3=@Telephone3,Fax=@Fax,EMail=@EMail,CashInSafeLimit=@CashInSafeLimit where BR_PK=@BR_PK";
objcmd.Parameters.Add(new SqlParameter("@BR_PK", SqlDbType.UniqueIdentifier, 16));
objcmd.Parameters.Add(new SqlParameter("@BT_PK", SqlDbType.UniqueIdentifier, 16));
objcmd.Parameters.Add(new SqlParameter("@BranchName", SqlDbType.VarChar, 50));
objcmd.Parameters.Add(new SqlParameter("@ContactPerson", SqlDbType.VarChar, 50));
objcmd.Parameters.Add(new SqlParameter("@ContactPersonPhone", SqlDbType.VarChar, 15));
objcmd.Parameters.Add(new SqlParameter("@BranchPrefix", SqlDbType.VarChar, 3));
objcmd.Parameters.Add(new SqlParameter("@BranchAddress", SqlDbType.VarChar, 150));
objcmd.Parameters.Add(new SqlParameter("@Telephone1", SqlDbType.VarChar, 15));
objcmd.Parameters.Add(new SqlParameter("@Telephone2", SqlDbType.VarChar, 15));
objcmd.Parameters.Add(new SqlParameter("@Telephone3", SqlDbType.VarChar, 15));
objcmd.Parameters.Add(new SqlParameter("@Fax", SqlDbType.VarChar, 25));
objcmd.Parameters.Add(new SqlParameter("@EMail", SqlDbType.VarChar, 25));
objcmd.Parameters.Add(new SqlParameter("@CashInSafeLimit", SqlDbType.Decimal, 9));
objcmd.Parameters["@BR_PK"].Value = (Guid)btInfo.PrimaryKey;
objcmd.Parameters["@BT_PK"].Value = (Guid)btInfo.BT_PK;
objcmd.Parameters["@BranchName"].Value = (string)btInfo.BranchName;
objcmd.Parameters["@ContactPerson"].Value = (string)btInfo.ContactPerson;
objcmd.Parameters["@ContactPersonPhone"].Value = (string)btInfo.ContactPersonPhone;
objcmd.Parameters["@BranchPrefix"].Value = (string)btInfo.BranchPrefix;
objcmd.Parameters["@BranchAddress"].Value = (string)btInfo.BranchAddress;
objcmd.Parameters["@Telephone1"].Value = (string)btInfo.Telephone1;
objcmd.Parameters["@Telephone2"].Value = (string)btInfo.Telephone2;
objcmd.Parameters["@Telephone3"].Value = (string)btInfo.Telephone3;
objcmd.Parameters["@Fax"].Value = (string)btInfo.Fax;
objcmd.Parameters["@EMail"].Value = (string)btInfo.EMail;
objcmd.Parameters["@CashInSafeLimit"].Value = (Decimal)btInfo.CashInSafeLimit;
}
objcmd.Connection = objmycon;
objmycon.Open();
objcmd.ExecuteNonQuery();
}
catch (Exception Exp)
{
throw Exp;
}
finally
{
objmycon.Close();
}
}
