public static void Save(Entity.Common.Block block)
{
using (DataManager oDm = new DataManager())
{
oDm.Add("@pBlockId", SqlDbType.Int, ParameterDirection.InputOutput, block.BlockId);
oDm.Add("@pBlockName", SqlDbType.VarChar, 50, block.BlockName);
oDm.Add("@pDistrictId", SqlDbType.Int, block.DistrictId);
oDm.Add("@pCode", SqlDbType.VarChar, 20, block.Code);
if (block.Remarks == string.Empty)
{
oDm.Add("@pRemarks", SqlDbType.VarChar, 200, DBNull.Value);
}
else
{
oDm.Add("@pRemarks", SqlDbType.VarChar, 200, block.Remarks);
}
oDm.CommandType = CommandType.StoredProcedure;
oDm.ExecuteNonQuery("Block_Save");
block.BlockId = (int)oDm["@pBlockId"].Value;
}
}
public static Entity.Common.Block GetBlockById(int blockId)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@pBlockId", SqlDbType.Int, ParameterDirection.Input, blockId);
SqlDataReader dr = oDm.ExecuteReader("Block_GetById");
Entity.Common.Block block = new Entity.Common.Block();
if (dr.HasRows)
{
while (dr.Read())
{
block.BlockId = blockId;
block.BlockName = (dr[1] == DBNull.Value) ? "" : dr[1].ToString();
block.DistrictId = (dr[2] == DBNull.Value) ? 0 : int.Parse(dr[2].ToString());
block.Code = (dr[3] == DBNull.Value) ? "" : dr[3].ToString();
block.Remarks = (dr[4] == DBNull.Value) ? "" : dr[4].ToString();
}
}
return(block);
}
}
protected void PopulateBlock()
{
BusinessLayer.Common.Block objBlock = new BusinessLayer.Common.Block();
block = objBlock.GetBlockById(BlockId);
if (block != null)
{
BlockId = block.BlockId;
txtBlockName.Text = block.BlockName.ToString();
ddlDistrict.SelectedValue = block.DistrictId.ToString();
txtCode.Text = block.Code.ToString();
txtRemarks.Text = block.Remarks.ToString();
Message.Show = false;
btnSave.Text = "Update";
}
}
public void Save(Entity.Common.Block block)
{
DataAccess.Common.Block.Save(block);
}
