public static WarehouseDAL.DataContracts.Munit ToDatMunit(this Munit munit) { return(new WarehouseDAL.DataContracts.Munit() { Id = munit.Id, MunitName = munit.MunitName, IsActive = munit.IsActive }); }
private IList <Munit> GetMunits(int id) { IList <Munit> munitList = null; using (var conn = new SqlConnection(ConnectionParameters.ConnectionString)) { conn.Open(); using (var cmd = new SqlCommand(getMunit, conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; var cmdParamId = new SqlParameter("id", System.Data.SqlDbType.Int); cmdParamId.Value = id; cmd.Parameters.Add(cmdParamId); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { munitList = new List <Munit>(); while (reader.Read()) { Munit newMunit = new Munit(); newMunit.Id = (int)reader["id"]; newMunit.MunitName = (string)reader["name"]; newMunit.IsActive = (bool)reader["IsActive"]; munitList.Add(newMunit); } } } } return(munitList); }
public IList <Munit> GetActiveMunit() { IList <Munit> munitList = null; using (var conn = new SqlConnection(ConnectionParameters.ConnectionString)) { conn.Open(); using (var cmd = new SqlCommand(getActiveMunit, conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { munitList = new List <Munit>(); while (reader.Read()) { Munit newMunit = new Munit(); newMunit.Id = (int)reader["id"]; newMunit.MunitName = (string)reader["name"]; newMunit.IsActive = (bool)reader["isActive"]; munitList.Add(newMunit); } } } } return(munitList); }
public int CreateOrUpdateMunit(Munit munit) { var munitAdaptor = new MunitAdaptor(); var result = munitAdaptor.CreateOrUpdateMunit(munit); return(result); }
public int CreateOrUpdateMunit(Munit munit) { int res = 0; using (var conn = new SqlConnection(ConnectionParameters.ConnectionString)) { conn.Open(); using (var cmd = new SqlCommand(createOrUpdateMunit, conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; var cmdParamId = new SqlParameter("@id", System.Data.SqlDbType.Int); if (munit.Id.HasValue) { cmdParamId.Value = munit.Id.Value; } else { cmdParamId.Value = DBNull.Value; } cmd.Parameters.Add(cmdParamId); SqlParameter pMunitName = new SqlParameter("@name", System.Data.SqlDbType.NVarChar, 10); pMunitName.Value = munit.MunitName; cmd.Parameters.Add(pMunitName); SqlParameter pResult = new SqlParameter("@status", System.Data.SqlDbType.Int); pResult.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(pResult); cmd.ExecuteNonQuery(); res = Convert.ToInt32(pResult.Value); } return(res); } }
public int CreateOrUpdateMunit(Munit munit) { var munitMeneger = new MunitManager(); return(munitMeneger.CreateOrUpdateMunit(munit.ToDatMunit())); }