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); }