public int DeleteDiscountAuthority(DiscountAuthority aDiscountAuthority)
{
Query = "DELETE FROM DiscountAuthority WHERE Id='" + aDiscountAuthority.Id + "'";
Command = new SqlCommand(Query, Connection);
int rowAffect = Command.ExecuteNonQuery();
return(rowAffect);
}
public MessageModel DeleteDiscountAuthority(DiscountAuthority aDiscountAuthority)
{
MessageModel aMessageModel = new MessageModel();
aDiscountAuthorityGatway = new DiscountAuthorityGatway();
if (aDiscountAuthorityGatway.DeleteDiscountAuthority(aDiscountAuthority) > 0)
{
aMessageModel.MessageTitle = "Successfull";
aMessageModel.MessageBody = "Discount authority information deleted successfully.";
}
return(aMessageModel);
}
public int UpdateDiscountAuthority(DiscountAuthority aDiscountAuthority)
{
Query = "UPDATE DiscountAuthority SET Name=@Name,Address=@Address,MobileNo=@MobileNo,Email=@Email,Designation=@Designation,UserId=@UserId WHERE Id='" + aDiscountAuthority.Id + "'";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("@Name", aDiscountAuthority.Name ?? "");
Command.Parameters.AddWithValue("@Address", aDiscountAuthority.Address ?? "");
Command.Parameters.AddWithValue("@MobileNo", aDiscountAuthority.MobileNo ?? "");
Command.Parameters.AddWithValue("@Email", aDiscountAuthority.Email ?? "");
Command.Parameters.AddWithValue("@Designation", aDiscountAuthority.Designation ?? "");
Command.Parameters.AddWithValue("@UserId", aDiscountAuthority.UserId ?? "");
int rowAffect = Command.ExecuteNonQuery();
return(rowAffect);
}
public int SaveDiscountAuthority(DiscountAuthority aDiscountAuthority)
{
Query = "INSERT INTO DiscountAuthority (Name,Address,MobileNo,Email,Designation,UserId) VALUES (@Name,@Address,@MobileNo,@Email,@Designation,@UserId)";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("@Name", aDiscountAuthority.Name ?? "");
Command.Parameters.AddWithValue("@Address", aDiscountAuthority.Address ?? "");
Command.Parameters.AddWithValue("@MobileNo", aDiscountAuthority.MobileNo ?? "");
Command.Parameters.AddWithValue("@Email", aDiscountAuthority.Email ?? "");
Command.Parameters.AddWithValue("@Designation", aDiscountAuthority.Designation ?? "");
Command.Parameters.AddWithValue("@UserId", aDiscountAuthority.UserId ?? "");
int rowAffect = Command.ExecuteNonQuery();
return(rowAffect);
}
public MessageModel SaveDiscountAuthority(DiscountAuthority aDiscountAuthority)
{
MessageModel aMessageModel = new MessageModel();
aDiscountAuthorityGatway = new DiscountAuthorityGatway();
if (aDiscountAuthorityGatway.SaveDiscountAuthority(aDiscountAuthority) > 0)
{
aMessageModel.MessageTitle = "Successful";
aMessageModel.MessageBody = "Discount authority information saved successfully.";
return(aMessageModel);
}
else
{
aMessageModel.MessageTitle = "Error!";
aMessageModel.MessageBody = "Discount authority Saved to failed.";
}
return(aMessageModel);
}
private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult dr = MetroFramework.MetroMessageBox.Show(this, "Are you sure to delete row?", "Confirmation Message",
MessageBoxButtons.YesNo, MessageBoxIcon.Stop);
if (dr == DialogResult.Yes)
{
aDiscountAuthority = new DiscountAuthority();
aDiscountAuthority.Id = Convert.ToInt32(txtId.Text);
MessageModel aMessageModel = new MessageModel();
aMessageModel = aDiscountAuthorityManager.DeleteDiscountAuthority(aDiscountAuthority);
if (aMessageModel.MessageTitle == "Successfull")
{
MetroFramework.MetroMessageBox.Show(this, aMessageModel.MessageBody, aMessageModel.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
Refresh();
}
else
{
MetroFramework.MetroMessageBox.Show(this, aMessageModel.MessageBody, aMessageModel.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
public DiscountAuthorityUi()
{
InitializeComponent();
aDiscountAuthorityManager = new DiscountAuthorityManager();
aDiscountAuthority = new DiscountAuthority();
}
