public int DeleteRefferedInfo(RefferedInfo aRefferedInfo)
{
Query = "DELETE FROM RefferedInfo WHERE Id='" + aRefferedInfo.Id + "'";
Command = new SqlCommand(Query, Connection);
int rowAffect = Command.ExecuteNonQuery();
return(rowAffect);
}
public MessageModel DeleteRefferedInfo(RefferedInfo aRefferedInfo)
{
MessageModel aMessageModel = new MessageModel();
aRefferedInfoGatway = new RefferedInfoGatway();
if (aRefferedInfoGatway.DeleteRefferedInfo(aRefferedInfo) > 0)
{
aMessageModel.MessageTitle = "Successfull";
aMessageModel.MessageBody = "Reffered info deleted successfully.";
}
return(aMessageModel);
}
public int SaveRefferedInfo(RefferedInfo aRefferedInfo)
{
Query = "INSERT INTO RefferedInfo(Name,Address,MobileNo,Email,Designation,UserId,Commission)VALUES(@Name,@Address,@MobileNo,@Email,@Designation,@UserId,@Commission)";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("@Name", aRefferedInfo.Name ?? "");
Command.Parameters.AddWithValue("@Address", aRefferedInfo.Address ?? "");
Command.Parameters.AddWithValue("@MobileNo", aRefferedInfo.MobileNo ?? "");
Command.Parameters.AddWithValue("@Email", aRefferedInfo.Email ?? "");
Command.Parameters.AddWithValue("@Designation", aRefferedInfo.Designation ?? "");
Command.Parameters.AddWithValue("@UserId", aRefferedInfo.UserId ?? "");
Command.Parameters.AddWithValue("@Commission", aRefferedInfo.Commission ?? "");
int rowAffect = Command.ExecuteNonQuery();
return(rowAffect);
}
public int UpdateRefferedInfo(RefferedInfo aRefferedInfo)
{
Query = "UPDATE RefferedInfo SET Name=@Name,Address=@Address,MobileNo=@MobileNo,Email=@Email,Designation=@Designation,UserId=@UserId,Commission=@Commission WHERE Id='" + aRefferedInfo.Id + "'";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("@Name", aRefferedInfo.Name ?? "");
Command.Parameters.AddWithValue("@Address", aRefferedInfo.Address ?? "");
Command.Parameters.AddWithValue("@MobileNo", aRefferedInfo.MobileNo ?? "");
Command.Parameters.AddWithValue("@Email", aRefferedInfo.Email ?? "");
Command.Parameters.AddWithValue("@Designation", aRefferedInfo.Designation ?? "");
Command.Parameters.AddWithValue("@UserId", aRefferedInfo.UserId ?? "");
Command.Parameters.AddWithValue("@Commission", aRefferedInfo.Commission ?? "");
int rowAffect = Command.ExecuteNonQuery();
return(rowAffect);
}
private void btnSave_Click(object sender, EventArgs e)
{
aRefferedInfo = new RefferedInfo();
aRefferedInfo.Name = txtName.Text;
aRefferedInfo.Address = txtAddress.Text;
aRefferedInfo.MobileNo = txtMobile.Text;
aRefferedInfo.UserId = lblUserId.Text;
aRefferedInfo.Email = txtEmail.Text;
aRefferedInfo.Designation = txtDesignation.Text;
aRefferedInfo.Commission = txtCommisionPercent.Text;
if (btnSave.Text == "Save")
{
MessageModel aMessageModel = new MessageModel();
aMessageModel = aRefferedInfoManager.SaveRefferedInfo(aRefferedInfo);
if (aMessageModel.MessageTitle == "Successful")
{
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);
}
}
else
{
MessageModel aMessageModel = new MessageModel();
aRefferedInfo.Id = Convert.ToInt32(txtId.Text);
aMessageModel = aRefferedInfoManager.UpdateRefferedInfo(aRefferedInfo);
if (aMessageModel.MessageTitle == "Successful")
{
MetroFramework.MetroMessageBox.Show(this, aMessageModel.MessageBody, aMessageModel.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
Refresh();
}
else
{
MetroFramework.MetroMessageBox.Show(this, aMessageModel.MessageTitle, aMessageModel.MessageBody, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
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)
{
aRefferedInfo = new RefferedInfo();
aRefferedInfo.Id = Convert.ToInt32(txtId.Text);
MessageModel aMessageModel = new MessageModel();
aMessageModel = aRefferedInfoManager.DeleteRefferedInfo(aRefferedInfo);
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);
}
}
}
