private void saveButton_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(cmbUserName.Text))
{
MessageBox.Show("Please Select user as COO Name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (string.IsNullOrEmpty(cmbCompanyName.Text))
{
MessageBox.Show("Please enter Company Name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
COOManager aManager = new COOManager();
ModelCOO amCOO = new ModelCOO();
amCOO.MUserId = mUserId;
amCOO.CompanyId = companyId;
amCOO.JoiningDate = Convert.ToDateTime(txtJoiningDate.Value, System.Globalization.CultureInfo.GetCultureInfo("hi-IN").DateTimeFormat);
amCOO.CreationDate = DateTime.UtcNow;
amCOO.UserId = userId;
string msg = aManager.SaveCOO(amCOO);
MessageBox.Show(msg);
Reset();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public string SaveCOO(ModelCOO amCOO)
{
connection.Open();
string qry = string.Format("INSERT INTO COO(CompanyId,JoiningDate,CreationDate,UserId) VALUES(@d1,@d2,@d3,@d4)");
SqlCommand cmd = new SqlCommand(qry, connection);
cmd.Parameters.AddWithValue("@d1", amCOO.CompanyId);
cmd.Parameters.AddWithValue("@d2", amCOO.JoiningDate);
cmd.Parameters.AddWithValue("@d3", amCOO.CreationDate);
cmd.Parameters.AddWithValue("@d4", amCOO.UserId);
int affectedRows = cmd.ExecuteNonQuery();
if (affectedRows > 0)
{
return("Suucessfully Saved");
}
else
{
return("Data is not in a Correct Format");
}
}
public string SaveCOO(ModelCOO amCOO)
{
return(aCooGateway.SaveCOO(amCOO));
}
