public List<Capacity> Capacity_GetByTop(string Top, string Where, string Order)
{
List<Data.Capacity> list = new List<Data.Capacity>();
using (SqlCommand dbCmd = new SqlCommand("sp_Capacity_GetByTop", GetConnection()))
{
Data.Capacity obj = new Data.Capacity();
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@Top", Top));
dbCmd.Parameters.Add(new SqlParameter("@Where", Where));
dbCmd.Parameters.Add(new SqlParameter("@Order", Order));
SqlDataReader dr = dbCmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(obj.CapacityIDataReader(dr));
}
dr.Close();
//conn.Close();
}
else
{
dr.Close();
}
}
return list;
}
public List<Capacity> Capacity_GetByAll()
{
List<Data.Capacity> list = new List<Data.Capacity>();
using (SqlCommand dbCmd = new SqlCommand("sp_Capacity_GetByAll", GetConnection()))
{
Data.Capacity obj = new Data.Capacity();
dbCmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = dbCmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(obj.CapacityIDataReader(dr));
}
dr.Close();
//conn.Close();
}
else
{
dr.Close();
}
}
return list;
}
public Capacity CapacityIDataReader(IDataReader dr)
{
Data.Capacity obj = new Data.Capacity();
obj.Id = (dr["Id"] is DBNull) ? string.Empty : dr["Id"].ToString();
public List<Capacity> Capacity_Paging(string CurentPage, string PageSize)
{
List<Data.Capacity> list = new List<Data.Capacity>();
using (SqlCommand dbCmd = new SqlCommand("sp_Capacity_Paging", GetConnection()))
{
Data.Capacity obj = new Data.Capacity();
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@CurentPage", CurentPage));
dbCmd.Parameters.Add(new SqlParameter("@PageSize", PageSize));
SqlDataReader dr = dbCmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(obj.CapacityIDataReader(dr));
}
dr.Close();
//conn.Close();
}
else
{
dr.Close();
}
}
return list;
}
protected void Update_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Data.Capacity obj = new Data.Capacity();
obj.Id = Id;
obj.Name = txtName.Text;
obj.Ord = txtOrd.Text != "" ? txtOrd.Text : "1";
obj.CreatedDate = DateTimeClass.ConvertDateTime(txtCreatedDate.Text, "MM/dd/yyyy HH:mm:ss");
obj.Active = chkActive.Checked ? "1" : "0";
obj.Title = txtTitle.Text;
obj.Description = txtDescription.Text;
obj.MetaKeyword = txtMetaKeyword.Text;
if (Insert == true)
{
CapacityService.Capacity_Insert(obj);
}
else
{
CapacityService.Capacity_Update(obj);
}
BindGrid();
pnView.Visible = true;
pnUpdate.Visible = false;
Insert = false;
}
}
