private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (txtName.Text.Trim() == string.Empty)
{
Message.ShowMessage(MyMessages.MessageType.MissingInfo, "Please Enter Unit Title.");
txtName.Focus();
return;
}
int vShares = 0;
int.TryParse(txtTotalShare.Text, out vShares);
decimal vPerShare = 0;
decimal.TryParse(txtPerSharePrice.Text, out vPerShare);
if (vShares == 0)
{
Message.ShowMessage(MyMessages.MessageType.MissingInfo, "Please Enter Total Number of Shares.");
txtTotalShare.Focus();
return;
}
Objects.ShareScheme obj = new Objects.ShareScheme();
obj.SchemeID = int.Parse(txtID.Text);
obj.SchemeTitle = txtName.Text.Trim();
obj.EntryDate = dtEntryDate.Value;
obj.TotalShares = vShares;
obj.PerShareValue = vPerShare;
obj.Remarks = txtRemarks.Text;
obj.UserID = vUserID;
if (!vOpenMode)
{
objDAL.InsertRecord(obj);
}
else
{
// UPdate
objDAL.UpdateRecord(obj);
}
Message.ShowMessage(MyMessages.MessageType.SaveRecord);
LoadGrid();
btnClear_Click(sender, e);
}
catch (Exception exc)
{
Message.ShowMessage(MyMessages.MessageType.Error, exc.Message);
}
}
public void InsertRecord(Objects.ShareScheme obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_ShareSchemeInsert";
cmd.Parameters.AddWithValue("@SchemeTitle", obj.SchemeTitle);
cmd.Parameters.AddWithValue("@EntryDate", obj.EntryDate);
cmd.Parameters.AddWithValue("@TotalShares", obj.TotalShares);
cmd.Parameters.AddWithValue("@PerShareValue", obj.PerShareValue);
cmd.Parameters.AddWithValue("@Remarks", obj.Remarks);
cmd.Parameters.AddWithValue("@UserID", obj.UserID);
new Database(connectionstring).ExecuteNonQueryOnly(cmd);
}
catch (Exception exc)
{
throw exc;
}
}
