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);
}
}
