public bool themBCTT(BCTinhTrangDTO baocao)
{
string query = string.Empty;
query += "INSERT INTO [CTCHIPHICHAMSOCTHANG] ([macttinhtrangcay],[matinhtrangthang],[macay],[maloaicay],[matinhtrang]) ";
query += "VALUES (@macttinhtrangcay,@matinhtrangthang,@macay,@maloaicay,@matinhtrang)";
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@macttinhtrangcay", baocao.MaCTTinhTrangCayPT);
cmd.Parameters.AddWithValue("@matinhtrangthang", baocao.MaTinhTrangThangPT);
cmd.Parameters.AddWithValue("@macay", baocao.MaCayPT);
cmd.Parameters.AddWithValue("@maloaicay", baocao.MaLoaiCayPT);
cmd.Parameters.AddWithValue("@matinhtrang", baocao.MaTinhTrangPT);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(false);
}
}
}
return(true);
}
public List <BCTinhTrangDTO> selectBCTT()
{
string query = string.Empty;
query += "SELECT[mactchiphithang],[machiphithang],[mavattu],[sophieumua],[tongtrigia],[tyle]";
query += "FROM [CTCHIPHICHAMSOCTHANG]";
List <BCTinhTrangDTO> lsBaoCao = new List <BCTinhTrangDTO>();
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
try
{
con.Open();
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
BCTinhTrangDTO BaoCao = new BCTinhTrangDTO();
BaoCao.MaCTTinhTrangCayPT = reader["macttinhtrangcay"].ToString();
BaoCao.MaTinhTrangThangPT = reader["matinhtrangthang"].ToString();
BaoCao.MaCayPT = reader["macay"].ToString();
BaoCao.MaLoaiCayPT = int.Parse(reader["maloaicay"].ToString());
BaoCao.MaTinhTrangPT = int.Parse(reader["matinhtrang"].ToString());
lsBaoCao.Add(BaoCao);
}
}
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(null);
}
}
}
return(lsBaoCao);
}
private bool XuLySoLieu()
{
Result = new List <BCTinhTrangDTO>();
BCTinhTrangDTO Temp;
if (yearBT.Text == "" || monthBT.Text == "")
{
return(false);
}
else if (int.Parse(yearBT.Text) < 0)
{
return(false);
}
else if (int.Parse(monthBT.Text) < 0 || int.Parse(monthBT.Text) >= 12)
{
return(false);
}
DateTime ngayTim = new DateTime(int.Parse(yearBT.Text), int.Parse(monthBT.Text), 1);
int i = 0;
if (listCay == null || listCay.Count == 0)
{
return(false);
}
for (i = 0; i < listCay.Count(); i++)
{
Temp = new BCTinhTrangDTO();
Temp.MaCTTinhTrangCayPT = yearBT.Text + monthBT.Text + listCay[i].MaCayCanhPT;
Temp.MaTinhTrangThangPT = yearBT.Text + monthBT.Text + i.ToString();
Temp.MaCayPT = listCay[i].MaCayCanhPT;
Temp.MaLoaiCayPT = listCay[i].MaLoaiCayCanhPT;
Temp.MaTinhTrangPT = listCay[i].TinhTrangPT;
Temp.TenCayPT = listCay[i].TenCayPT;
Temp.TenLoaiCayPT = listloaiCay[listCay[i].MaLoaiCayCanhPT - 1].TenLoaiCayPT;
Temp.TenTinhTrangPT = listTinhTrang[listCay[i].MaLoaiCayCanhPT - 1].TenTinhTrangPT;
Temp.NgaytrongPT = listCay[i].NgayTrongPT;
Result.Add(Temp);
}
return(true);
}
public bool them(BCTinhTrangDTO thang)
{
bool result = tinhTrangDAL.themBCTT(thang);
return(result);
}
