public static ResultStatus UpdateUser(User user)
{
ResultStatus result = ResultStatus.Null;
try
{
using (SC_DBDataContext dc = new SC_DBDataContext())
{
var dbUser = dc.Users.SingleOrDefault(u => u.UserId == user.UserId);
if (dbUser != null)
{
dbUser.IncorporationDate = user.IncorporationDate;
dbUser.Industry = user.Industry;
dbUser.LoanPurpose = user.LoanPurpose;
dbUser.RequestedAmount = user.RequestedAmount;
dbUser.Revenue = user.Revenue;
dc.SubmitChanges();
result = ResultStatus.Success;
}
else
{
result = ResultStatus.RecordNotFound;
}
}
}
catch (Exception ex)
{
throw;
}
return(result);
}
public static ResultStatus DeleteUser(int userId)
{
ResultStatus result = ResultStatus.Null;
try
{
using (SC_DBDataContext dc = new SC_DBDataContext())
{
var dbUser = dc.Users.SingleOrDefault(u => u.UserId == userId);
if (dbUser != null)
{
dc.Users.DeleteOnSubmit(dbUser);
dc.SubmitChanges();
result = ResultStatus.Success;
}
else
{
result = ResultStatus.RecordNotFound;
}
}
}
catch (Exception ex)
{
throw;
}
return(result);
}
public static int AddUser(UserBase user)
{
int UserId = 0;
try
{
using (SC_DBDataContext dc = new SC_DBDataContext())
{
var newUser = new User()
{
IncorporationDate = user.IncorporationDate,
Industry = user.Industry,
LoanPurpose = user.LoanPurpose,
RequestedAmount = user.RequestedAmount,
Revenue = user.Revenue
};
dc.Users.InsertOnSubmit(newUser);
dc.SubmitChanges();
UserId = newUser.UserId;
}
}
catch (Exception ex)
{
throw;
}
return(UserId);
}
