protected void btnSave_Click(object sender, EventArgs e)
{
string FName = txtFName.Text;
string LName = txtLName.Text;
string Phone = txtPhone.Text;
string Email = txtEmail.Text;
string status = ddlStatus.SelectedItem.Text;
Boolean blnStatus = Boolean.Parse(status);
dbHelper data = new dbHelper();
int Result = data.InsertData(FName, LName, Phone, Email, blnStatus);
if (Result == 1)
{
lblError.Text = "Data Inserted Successfully";
}
else
{
lblError.Text = "Inserting Data Failed";
}
LoadGrid();
ClearTextFields();
pnlNewRecord.Visible = false;
}
//Delete record
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
//Label lbldeleteid = (Label)row.FindControl("ID");
int ID = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
// int ID = Convert.ToInt32(lbldeleteid);
dbHelper data = new dbHelper();
try
{
Boolean result = data.DeleteData(ID);
LoadGrid();
if (result == true)
{
lblError.Text = "Row Deleted successfully";
}
else
{
lblError.Text = "Deleting row failed";
}
}catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
//Load Grid
private void LoadGrid()
{
dbHelper data = new dbHelper();
GridView1.DataSource = data.GetResultList();
GridView1.DataBind();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int ID = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
//GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
GridViewRow row = GridView1.Rows[e.RowIndex];
string FName = ((TextBox)(row.Cells[1].Controls[0])).Text;
string LName = ((TextBox)(row.Cells[2].Controls[0])).Text;
string Email = ((TextBox)(row.Cells[3].Controls[0])).Text;
string PhoneNumber = ((TextBox)(row.Cells[4].Controls[0])).Text;
string StatusId = ((TextBox)(row.Cells[5].Controls[0])).Text;
//check for validations
if ((AlphaString(FName) && AlphaString(LName)) == true && (FName != string.Empty & LName != string.Empty))
{
//email
if (EmailValidation(Email.Trim()))
{
lblError.Text = string.Empty;
}
else
{
lblError.Text = "Please provide a valid email address";
lblError.ForeColor = System.Drawing.Color.Red;
return;
}
//phone
if (PhoneNumberValidation(PhoneNumber.Trim()))
{
lblError.Text = string.Empty;
}
else
{
lblError.Text = "Please provide a valid phone Number";
lblError.ForeColor = System.Drawing.Color.Red;
return;
}
//status
if (StatusId == "True" || StatusId == "False")
{
}
else
{
lblError.Text = "Enter either true or false";
lblError.ForeColor = System.Drawing.Color.Red;
return;
}
}
else
{
lblError.Text = "valid First and Last Names are required";
lblError.ForeColor = System.Drawing.Color.Red;
return;
}
//end of validations
Boolean blnstatus = false;
if (StatusId == "true")
{
blnstatus = true;
}
GridView1.EditIndex = -1;
try
{
dbHelper data = new dbHelper();
int Result = data.UpdateData(ID, FName, LName, PhoneNumber, Email, blnstatus);
if (Result == 1)
{
lblError.Text = "Successfull update";
}
else
{
lblError.Text = "update Failed";
}
LoadGrid();
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
