public AddUpdateADFrm(MaintainType type, AdvModel model) { InitializeComponent(); this.advModel = model; this.maintainType = type; this.previousImg = this.advModel.AdvImage; InitControls(); }
private void btnAdd_Click(object sender, EventArgs e) { AdvModel newBrandModel = new AdvModel(); using (AddUpdateADFrm newBrand = new AddUpdateADFrm(MaintainType.New, newBrandModel)) { var dialogResult = newBrand.ShowDialog(); if (dialogResult == DialogResult.OK) { InitControls(); } } }
public bool InsertAdv(string advModelStr) { AdvModel model = JsonUtil.Deserialize <AdvModel>(advModelStr); string sql = $"INSERT INTO Advertisement(AdvTypeId,AdvInnerId,AdvSart,AdvImage) VALUES(?advTypeId,?advInnerId,?advSart,?advImage)"; Dictionary <string, object> p = new Dictionary <string, object>(); p["advImage"] = model.AdvImage; p["advTypeId"] = model.AdvTypeId; p["advInnerId"] = model.AdvInnerId; p["advSart"] = model.AdvSart; int num = DbUtil.Master.ExecuteNonQuery(sql, p); if (num > 0) { return(true); } else { return(false); } }
public bool UpdateAdv(int advId, string advModelStr) { AdvModel model = JsonUtil.Deserialize <AdvModel>(advModelStr); string sql = $"UPDATE Advertisement set AdvImage=?advImage,AdvTypeId=?advTypeId,AdvInnerId=?advInnerId,AdvSart=?advSart WHERE AdvId=?advId"; Dictionary <string, object> p = new Dictionary <string, object>(); p["advImage"] = model.AdvImage; p["advTypeId"] = model.AdvTypeId; p["advInnerId"] = model.AdvInnerId; p["advSart"] = model.AdvSart; p["advId"] = advId; int num = DbUtil.Master.ExecuteNonQuery(sql, p); if (num > 0) { return(true); } else { return(false); } }