public DataSet Account_check(save_account obj) { DataSet ds = new DataSet(); string strQuer = ""; strQuer = "set dateformat dmy; select save_email,save_mobile from save_account where save_email='" + obj.save_email + "' and save_mobile='" + obj.save_mobile + "' "; try { ds = ExecuteSelectQuery(strQuer); } catch (Exception ee) { ds = null; } return(ds); }
public bool Account_savebtn(save_account objSaa) { bool flag = false; string strQuer = ""; strQuer = "set dateformat dmy; insert into save_account ([save_name],[save_Username],[save_mobile],[save_email],[save_password],[save_confirmpassword],[save_gender],[save_age])values('" + objSaa.save_name + "','" + objSaa.save_Username + "','" + objSaa.save_mobile + "','" + objSaa.save_email + "','" + objSaa.save_password + "','" + objSaa.save_confirmpassword + "','" + objSaa.save_gender + "','" + objSaa.save_age + "' where save_status=1);select @@Identity"; try { ExecuteSelectQuery(strQuer); flag = true; } catch (Exception ee) { flag = false; } return(flag); }
public bool Update_save_account(save_account obj_save_account) { bool flag = false; string strQuery = ""; strQuery = " set dateformat dmy;Update save_account set save_name = N'" + obj_save_account.save_name + "', save_ModifiedOn = getdate(), save_ModifiedBy = '" + obj_save_account.save_AddedBy + "' where save_id = '" + obj_save_account.save_id + "' and save_status = '" + obj_save_account.save_status + "' "; if (obj_save_account != null) { ExecuteSelectQuery(strQuery); flag = true; } else { //ExecuteSelectQuerywithTransaction(strQuery); flag = true; } return(flag); }
protected void btnSave_Click(object sender, EventArgs e) { save_account obj_save_account = new save_account(); try { obj_save_account.save_id = Convert.ToInt32(hf_save_id.Value); } catch { obj_save_account.save_id = 0; } if (txtPersonName.Text.Trim() == "") { MessageBox.Show("Please Provide Name!!"); txtPersonName.Focus(); return; } if (txtUserName.Text.Trim() == "") { MessageBox.Show("Please Provide User Name!!"); txtUserName.Focus(); return; } if (txtMobile.Text.Trim() == "") { MessageBox.Show("Please Provide Mobile Number!!"); txtMobile.Focus(); return; } if (txtEmail.Text.Trim() == "") { MessageBox.Show("Please Provide Email!!"); txtEmail.Focus(); } if (txtPassword.Text.Trim() == "") { MessageBox.Show("Please Provide Password!!"); txtPassword.Focus(); } if (txtConfirmPassword.Text.Trim() == "") { MessageBox.Show("Please Confirm Password!!"); txtConfirmPassword.Focus(); } if (ddlGender.SelectedValue == "0") { MessageBox.Show("Please select Gender!!"); ddlGender.Focus(); } if (txtAge.Text.Trim() == "") { MessageBox.Show("Please Fill Age!!"); txtAge.Focus(); } obj_save_account.save_name = txtPersonName.Text.Trim(); obj_save_account.save_Username = txtUserName.Text.Trim(); obj_save_account.save_mobile = txtMobile.Text.Trim(); obj_save_account.save_email = txtEmail.Text.Trim(); obj_save_account.save_password = txtPassword.Text.Trim(); obj_save_account.save_confirmpassword = txtConfirmPassword.Text.Trim(); obj_save_account.save_gender = ddlGender.Text.Trim(); obj_save_account.save_age = txtAge.Text.Trim(); DataSet sa = new DataLayer().Account_check(obj_save_account); if (hf_save_id == null) { if (sa != null && sa.Tables.Count > 0 && sa.Tables[0].Rows.Count > 0) { MessageBox.Show("Email already Exist OR Mobile alredy Exist!!"); } else if (new DataLayer().Account_savebtn(obj_save_account)) { MessageBox.Show("Account Created Successfully!!"); } } else { int save_id = 0; DataSet ds = new DataSet(); ds = (new DataLayer()).Edit(Convert.ToInt32(save_id)); if ((new DataLayer()).Update_save_account(obj_save_account)) { MessageBox.Show("Account Updated Successfully!!"); return; } else { MessageBox.Show("Error In Account Updation!!"); return; } } }