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