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