bool SaveRecord()
{
bool IsSave = false;
BusinessEntities.BE_PasswordChange NewBEObj = new BusinessEntities.BE_PasswordChange();
NewBEObj.UserID = GlobalVaribles.UserID;
NewBEObj.NewPassword = txtNewPassword.Text;
IsSave = NewDALLObj.SaveRecord(NewBEObj);
return(IsSave);
}
public bool SaveRecord(BusinessEntities.BE_PasswordChange NewBEObj)
{
bool IsSave = false;
SqlConnection Conn = new SqlConnection(ConnString);
SqlCommand cmd = new SqlCommand();
try
{
string Qry = @"Update Users
set
Password='******'where UserID='" + NewBEObj.UserID + "' ";
if (Conn.State == ConnectionState.Closed)
{
Conn.Open();
}
cmd.Connection = Conn;
cmd.CommandText = Qry;
//cmd.Parameters.AddWithValue("@UserID",NewBEObj.UserID);
//cmd.Parameters.AddWithValue("@NewPassword",NewBEObj.NewPassword);
IsSave = DataAccess.InserRecord(Qry);
//int i = cmd.ExecuteNonQuery();
//if (i != 0)
//{
// IsSave = true;
//}
//else
//{
// IsSave = false;
//}
}
catch (Exception ex)
{
IsSave = false;
throw ex;
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
Conn.Dispose();
cmd.Dispose();
Conn.ConnectionString = null;
}
return(IsSave);
}