public ActionResult actNhapNuocUong(Models.PhieuNhap Pn)
{
Models.Kho ko = dc.Khoes.Where(s => s.nuocuong_id == Pn.nuocuong_id).FirstOrDefault();
dc.PhieuNhaps.Add(Pn);
dc.SaveChanges();
if (ko != null)
{
ko.kho_tongsoluong += Pn.phieunhap_soluong;
ko.phieunhap_id = Pn.phieunhap_id;
ko.nguyenlieu_id = null;
ko.kho_tenkho = "nuocuong";
ko.kho_ngaynhap = Pn.phieunhap_ngaynhap;
ko.kho_ngayhethan = Pn.phieunhap_ngayhethan;
dc.SaveChanges();
return(Redirect("Kho"));
}
else
{
Models.Kho newkho = new Models.Kho();
newkho.nuocuong_id = (int)Pn.nuocuong_id;
newkho.nguyenlieu_id = null;
newkho.kho_tongsoluong = Pn.phieunhap_soluong;
newkho.phieunhap_id = Pn.phieunhap_id;
newkho.kho_ngaynhap = Pn.phieunhap_ngaynhap;
newkho.kho_ngayhethan = Pn.phieunhap_ngayhethan;
newkho.kho_tenkho = "nuocuong";
dc.Khoes.Add(newkho);
dc.SaveChanges();
return(Redirect("Kho"));
}
}
private Models.Kho GetDataKho()
{
Models.Kho k = new Models.Kho();
if (textBox1.Text != "")
{
k.KhoID = int.Parse(textBox1.Text);
}
k.Tenkho = textBox2.Text;
return(k);
}
public void ViewDataKho()
{
if (dataGridView1.CurrentRow != null)
{
int KhoID;
int.TryParse(dataGridView1.CurrentRow.Cells[0].Value.ToString(), out KhoID);
Models.Kho k = lstKho.Find(x => x.KhoID == KhoID);
if (KhoID > 0)
{
textBox1.Text = k.KhoID.ToString();
textBox2.Text = k.Tenkho;
lstSanpham = new SanPhamCollection(KhoID);
GridView_SanPham.DataSource = lstSanpham.Items;
}
}
}
public void ViewData(int _SanphamID)
{
kho = dm.GetDataByID(KhoID);
sp = DataAccess.GetsingleData("Sanpham_ViewbyLuutru", new SqlParameter("@KhoID", KhoID), new SqlParameter("@SanphamID", _SanphamID));
if (sp.Rows.Count > 0)
{
DataRow dr = sp.Rows[0];
textBox1.Text = dr["Tensanpham"].ToString();
textBox3.Text = dr["Soluong"].ToString();
textBox5.Text = _SanphamID.ToString();
}
else
{
textBox1.Text = (listView1.FindItemWithText(_SanphamID.ToString()) != null)?listView1.FindItemWithText(_SanphamID.ToString()).SubItems[1].Text:"";
textBox3.Text = "0";
textBox5.Text = _SanphamID.ToString();
}
textBox2.Text = kho.Tenkho;
}
private Models.Kho GetDataKho()
{
Models.Kho k = new Models.Kho();
if (textBox1.Text != "")
{
k.KhoID = int.Parse(textBox1.Text);
}
k.Tenkho = textBox2.Text;
return k;
}
public void ViewData(int _SanphamID)
{
kho = dm.GetDataByID(KhoID);
sp = DataAccess.GetsingleData("Sanpham_ViewbyLuutru", new SqlParameter("@KhoID", KhoID), new SqlParameter("@SanphamID", _SanphamID));
if (sp.Rows.Count > 0)
{
DataRow dr = sp.Rows[0];
textBox1.Text = dr["Tensanpham"].ToString();
textBox3.Text = dr["Soluong"].ToString();
textBox5.Text = _SanphamID.ToString();
}
else
{
textBox1.Text =(listView1.FindItemWithText(_SanphamID.ToString())!=null)?listView1.FindItemWithText(_SanphamID.ToString()).SubItems[1].Text:"" ;
textBox3.Text = "0";
textBox5.Text = _SanphamID.ToString();
}
textBox2.Text = kho.Tenkho;
}
