public bool HetHan(BANGGIA bg)
{
int ngay = int.Parse(bg.NGAY_APDUNG.Substring(8, 2));
// 2008-03-09
int thang = int.Parse(bg.NGAY_APDUNG.Substring(5, 2));
int nam = int.Parse(bg.NGAY_APDUNG.Substring(0, 4));
DateTime current = DateTime.Now;
if (current.Year > nam)
{
return(true);
}
else if (current.Year < nam)
{
return(false);
}
if (current.Month > thang)
{
return(true);
}
else if (current.Month < thang)
{
return(false);
}
if (current.Day > ngay)
{
return(true);
}
else if (current.Day < ngay)
{
return(false);
}
return(false);
}
public ActionResult Edit(BANGGIA bg)
{
int id = int.Parse(Url.RequestContext.RouteData.Values["id"].ToString());
var check = db.BANGGIAs.Where(g => g.ID_BANGGIA == id).FirstOrDefault();
check.ID_SACH = bg.ID_SACH;
check.NGAY_APDUNG = bg.NGAY_APDUNG;
if (bg.GIATRI >= 0)
{
check.TANG_GIAM = true;
}
else
{
var check2 = db.SACHes.Where(s => s.ID_SACH == bg.ID_SACH).FirstOrDefault();
if ((check2.GIA_BAN + bg.GIATRI) < 0)
{
return(RedirectToAction("Index"));
}
check.TANG_GIAM = false;
}
if (check.TANG_GIAM == false)
{
check.GIATRI = bg.GIATRI * (-1);
}
else
{
check.GIATRI = bg.GIATRI;
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
public frmCapNhatBangGia(UC_BangKeTongHopBangGia frm, BANGGIA objbanggia)
{
InitializeComponent();
uc_tonghopbanggia = frm;
_banggia = objbanggia;
txtMaBangGia.Text = objbanggia.ID;
txtTenBangGia.Text = objbanggia.Name_ListPrice;
dateNgayTao.DateTime = objbanggia.Refdate;
lookUpLoaiGia.EditValue = objbanggia.RefType;
dateBatDau.DateTime = objbanggia.StartDate;
dateHetHan.DateTime = objbanggia.StopDate;
chkDangDung.Checked = objbanggia.Active;
InitLookUp_LoaiBang();
ReadXml_User();
gridView1.Invalidate();
gridView1.IndicatorWidth = 40;
gridControl1.DataSource = new BANGGIA_DETAILController().BANGGIA_DETAIL_Get(objbanggia.ID);
}
public string ThemBangGia(DataTable dtable, BANGGIA objBANGGIA)
{
string Trave = "0";
try
{
string consString = DataProvider.ConnectionString;
using (SqlConnection con = new SqlConnection(consString))
{
using (SqlCommand cmd = new SqlCommand("Table_Insert_BangGia"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@tableBangGia", dtable);
cmd.Parameters.AddWithValue("@ID", objBANGGIA.ID);
cmd.Parameters.AddWithValue("@Name_ListPrice", objBANGGIA.Name_ListPrice);
cmd.Parameters.AddWithValue("@Refdate", objBANGGIA.Refdate);
cmd.Parameters.AddWithValue("@RefType", objBANGGIA.RefType);
cmd.Parameters.AddWithValue("@StartDate", objBANGGIA.StartDate);
cmd.Parameters.AddWithValue("@StopDate", objBANGGIA.StopDate);
cmd.Parameters.AddWithValue("@Active", objBANGGIA.Active);
cmd.Parameters.AddWithValue("@CreateBy", objBANGGIA.CreateBy);
cmd.Parameters.AddWithValue("@Createdate", objBANGGIA.Createdate);
cmd.Parameters.AddWithValue("@ModifyBy", objBANGGIA.ModifyBy);
cmd.Parameters.AddWithValue("@ModifyDate", objBANGGIA.ModifyDate);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
Trave = "1";
}
catch (Exception ex)
{
Trave = ex.ToString();
}
return(Trave);
}
public ActionResult Create(ListAutoPrice obj)
{
string ngayApDung = obj.ngayApDung;
bool tangGiam = obj.tangGiam == "down" ? false : true;
double giaTri = obj.giaTri;
bool donVi = obj.donVi == "VND" ? true : false;
ListAutoPrice newObj = new ListAutoPrice();
foreach (var item in db.SACHes.ToList())
{
var check = db.BANGGIAs.Where(bg => bg.ID_SACH == item.ID_SACH).FirstOrDefault();
if (check == null)
{
newObj.lsDepend.Add(item);
}
}
// Ko nhận dc ls
foreach (var item in newObj.lsDepend)
{
BANGGIA newBG = new BANGGIA();
newBG.ID_SACH = item.ID_SACH;
newBG.NGAY_APDUNG = ngayApDung;
newBG.TANG_GIAM = tangGiam;
if (donVi)
{
newBG.GIATRI = giaTri;
}
else
{
newBG.GIATRI = (item.GIA_BAN * giaTri) / 100;
}
db.BANGGIAs.Add(newBG);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
