/// <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);
}
