private void saveInfo_Click_1(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection(CS))
{
con.Open();
try
{
if (saveInfo.Text == "INSERT")
{
if (!CountryDA.CountryNameCheck(textName.Text))
{
CountryDA.Insert(textName.Text, textDes.Text, dateTimePicker.Value);
MessageBox.Show("Data inserted Successfully", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information);
Reset();
EditPanel.Visible = false;
viewPanel.Visible = false;
}
else
{
MessageBox.Show($"Country Name {textName.Text} Already Exsist");
}
}
else if (saveInfo.Text == "UPDATE")
{
if (COUNTRYID > 0)
{
if (!CountryDA.DuplicateCheck(textName.Text, COUNTRYID))
{
CountryDA.Update(textName.Text, textDes.Text, dateTimePicker.Value, this.COUNTRYID);
MessageBox.Show("Data Updated successfully", "Updated", MessageBoxButtons.OK, MessageBoxIcon.Information);
Reset();
EditPanel.Visible = false;
}
else
{
MessageBox.Show($"Country Name {textName.Text} Already Exsist");
}
}
else
{
MessageBox.Show("Please Select a Country to update the info", "Select?", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
}
}
public ResultEntity <CountryEntity> Update(CountryEntity countryEntity)
{
var validationResult = new ResultEntity <CountryEntity>();
using (var countryDA = new CountryDA())
{
var resultUpdate = countryDA.Update(countryEntity);
if (resultUpdate <= 0)
{
validationResult.Warning.Add("Failed Updating Country!");
return(validationResult);
}
validationResult.Value = countryEntity;
}
return(validationResult);
}
//protected void btnImg_Click(object sender, ImageClickEventArgs e)
//{
// editPanel.Visible = true;
// if (Calendar1.Visible)
// {
// Calendar1.Visible = false;
// }
// else
// {
// Calendar1.Visible = true;
// }
//}
//protected void Calendar1_SelectionChanged(object sender, EventArgs e)
//{
// editPanel.Visible = true;
// //Calendar1.Visible = false;
// txtCreateDate.Text = Calendar1.SelectedDate.ToShortDateString();
//}
protected void btnSave_Click(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection(CS))
{
con.Open();
try
{
if (btnSave.Text == "INSERT")
{
DateTime dateTime = DateTime.Parse(datepicker.Value);
if (Page.IsValid)
{
if (!CountryDA.CountryNameCheck(txtCountryName.Text))
{
CountryDA.Insert(txtCountryName.Text, txtDescription.Text, dateTime);
lblMessage.Text = "Data Inserted successfully";
ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Insert is successfull')", true);
Reset();
editPanel.Visible = false;
viewPanel.Visible = false;
}
else
{
lblMessage.Text = $"Country Name {txtCountryName.Text} Already Exists. Data Can not be inserted!";
ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Country name already exists.Data Can not be inserted!')", true);
}
}
}
else if (btnSave.Text == "UPDATE")
{
DateTime dateTime = DateTime.Parse(datepicker.Value);
int COUNTRYID;
COUNTRYID = Convert.ToInt32(gdvCountry.SelectedRow.Cells[0].Text);
if (COUNTRYID > 0)
{
if (!CountryDA.DuplicateCheck(txtCountryName.Text, COUNTRYID))
{
if (Page.IsValid)
{
CountryDA.Update(txtCountryName.Text, txtDescription.Text, dateTime, COUNTRYID);
ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Data updated successfully')", true);
lblMessage.Text = "Data Updated successfully";
editPanel.Visible = false;
Reset();
}
}
else
{
lblMessage.Text = $"Country Name {txtCountryName.Text} Already Exists. Data Can not be updated!";
ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Country name already exists.Data Can not be inserted!')", true);
}
}
else
{
lblMessage.Text = "Please Select a Country to update the info ";
}
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
}
}
public void Put(string countryName, string description, DateTime createDate, int countryId)
{
CountryDA.Update(countryName, description, createDate, countryId);
}
