/// <summary> /// Update Password /// </summary> /// <param name="data">data</param> /// <returns>number of record is update</returns> public int UpdatePasswordResetManagement(string mail_address, string parameter_value, DateTime apply_time, string company_Code) { PasswordResetManagement data = new PasswordResetManagement() { mail_address = mail_address, parameter_value = parameter_value, apply_time = apply_time, company_code = company_Code }; return(_repository.UpdatePasswordResetManagement(data)); }
/// <summary> /// Update Password ResetManagement table /// </summary> /// <param name="data">data</param> /// <returns>Number record is update</returns> public int UpdatePasswordResetManagement(PasswordResetManagement data) { int res = 0; Sql sql; if (GetEmailInPasswordResetManagementTable(data.mail_address) > 0) { IDictionary <string, object> condition = new Dictionary <string, object>() { { "mail_address", data.mail_address } }; if (Delete <PasswordResetManagement>(condition) > 0) { sql = new Sql(@" INSERT INTO [dbo].[password_reset_management] ( mail_address ,parameter_value ,apply_time ,company_code ) VALUES ( @mail_address ,@parameter_value ,@apply_time ,@company_code )" , new { mail_address = data.mail_address } , new { parameter_value = data.parameter_value } , new { apply_time = data.apply_time } , new { company_code = data.company_code } ); if (_database.Execute(sql) > 0) { var query = "select ident_current('password_reset_management')"; res = _database.ExecuteScalar <int>(query); } } } else { sql = new Sql(@" INSERT INTO [dbo].[password_reset_management] ( mail_address ,parameter_value ,apply_time ,company_code ) VALUES ( @mail_address ,@parameter_value ,@apply_time ,@company_code )" , new { mail_address = data.mail_address } , new { parameter_value = data.parameter_value } , new { apply_time = data.apply_time } , new { company_code = data.company_code } ); if (_database.Execute(sql) > 0) { var query = "select ident_current('password_reset_management')"; res = _database.ExecuteScalar <int>(query); } } return(res); }