public List<Disbursement> CreateDisbursementBySRF(User createdBy, int stationeryRetrievalFormId)
{
try
{
ObjectParameter message = new ObjectParameter("Message", typeof(string));
int errorCode = context.CreateDisbursementsBySRFId(stationeryRetrievalFormId,
createdBy.UserID, message);
if (errorCode == -1)
throw new Exceptions.StationeryRetrievalException(message.Value.ToString());
else
{
return
FindDisbursementByCriteria(new DisbursementSearchDTO()
{
StationeryRetrievalFormID = stationeryRetrievalFormId
});
}
}
catch (Exception e)
{
throw e;
}
}
public StationeryRetrievalForm CreateStationeryRetrievalForm(User createdBy, List<Requisition> requisitions)
{
string requisitionIds = string.Empty;
for (int i = 0; i < requisitions.Count-1; i++)
{
Requisition r = requisitions[i];
requisitionIds += r.RequisitionID + ",";
}
requisitionIds += requisitions[requisitions.Count - 1];
return stationeryRetrievalDAO.CreateStationeryRetrievalForm(createdBy, false, requisitionIds);
}
public User CreateUser(User user)
{
try
{
udao.CreateUser(user);
}
catch (Exception)
{
throw new Exceptions.UserException("User account creation failed.");
}
return user;
}
public static void SendEmail(string subject, string bodyMessage, User user)
{
//SmtpClient client = new SmtpClient("lynx.iss.nus.edu.sg");
SmtpClient client = new SmtpClient("127.0.0.1");
MailAddress fromAddress = new MailAddress("*****@*****.**");
MailMessage message = new MailMessage();
message.From = fromAddress;
message.To.Add(user.Email);
message.Body = bodyMessage;
message.Subject = subject;
message.IsBodyHtml = true;
client.Send(message);
}
protected void Page_Load(object sender, EventArgs e)
{
requisitionManager = new RequisitionManager();
currentUser = Utilities.Membership.GetCurrentLoggedInUser();
requisitions = requisitionManager.GetAllUnApprovedRequisitionByDepartmentID(currentUser.DepartmentID);
if (requisitions != null)
{
GridView1.DataSource = requisitions;
DataBind();
}
if (requisitions.Count == 0)
{
ApproveAllButton.Visible = false;
}
}
protected void CreateUserButton_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
// get the user entered data from textboxes
string userName = this.UserName.Text.Trim();
string password = this.Password.Text.Trim();
string email = this.Email.Text.Trim();
string firstName = this.Email.Text.Trim();
string lastName = this.Email.Text.Trim();
int departmentID = int.Parse(this.DepartmentDropDownList.SelectedValue.ToString());
// use the business logic to create user account
try
{
using (BLL.UserManager um = new BLL.UserManager())
{
// populate the data into object
DAL.User user = new DAL.User();
user.UserName = userName;
user.Password = password;
user.Email = email;
user.FirstName = firstName;
user.LastName = lastName;
// DAL.Department department = um.GetDepartmentByID(departmentID);
// user.Department = department;
using (TransactionScope ts = new TransactionScope())
{
MembershipUser membershipUser = Membership.CreateUser(user.UserName,
user.Password, user.Email);
// um.CreateUser(user);
}
}
}
catch (Exception exception)
{
// if something is wrong, display the error message
this.ErrorMessage.Text = exception.Message;
}
}
}
/// <summary>
/// Create Stationery from all requisitions that need to be processed
/// </summary>
/// <param name="createdBy">User who is creating the Stationery Retrieval</param>
/// <param name="requisitions">List of requisitions Id separated by comma</param>
/// <returns></returns>
public StationeryRetrievalForm CreateStationeryRetrievalForm(User createdBy, bool allRequisition, String requisitions)
{
try
{
ObjectParameter newSRFId = new ObjectParameter("NewSRFID", typeof(int));
ObjectParameter message = new ObjectParameter("Message", typeof(string));
int errorCode = context.CreateStationeryRetrievalFormByAllRequisitions(
createdBy.UserID, allRequisition, requisitions, newSRFId, message);
if (errorCode == -1)
throw new Exceptions.StationeryRetrievalException(message.Value.ToString());
else
{
return GetStationeryRetrievalFormByID((int) newSRFId.Value);
}
}
catch (Exception e)
{
throw e;
}
}
public void DeleteUser(User user)
{
try
{
User persistedUser = (from u in context.Users
where u.UserName.ToLower() == user.UserName.ToLower()
select u).FirstOrDefault();
using (TransactionScope ts = new TransactionScope())
{
context.Users.DeleteObject(persistedUser);
context.SaveChanges();
ts.Complete();
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Get Requisitions by Employee
/// </summary>
/// <param name="user">user object</param>
/// <param name="requisitionSearchDTO">requisitionSearchDTO object</param>
/// <returns>List of VW_RequisitionsByEmployee objects</returns>
public List<VW_RequisitionsByEmployee> GetRequisitionByEmployeeID(User user, RequisitionSearchDTO requisitionSearchDTO)
{
try
{
return GetAllRequisitionByEmployee().
Where(re => re.DateRequested.Month == (requisitionSearchDTO.ExactDateRequested.Month == 0 ? re.DateRequested.Month : requisitionSearchDTO.ExactDateRequested.Month)
&& re.DateRequested.Year == (requisitionSearchDTO.ExactDateRequested.Year == 0 ? re.DateRequested.Year : requisitionSearchDTO.ExactDateRequested.Year)
&& re.UserName == (user.UserName == "" ? re.UserName : user.UserName)
)
.ToList<VW_RequisitionsByEmployee>();
}
catch (Exception)
{
throw new RequisitionException("No Data Found");
}
}
public void DeleteUser(User user)
{
try
{
udao.DeleteUser(user);
}
catch (Exception)
{
throw new Exceptions.UserException("User account deletion failed.");
}
}
public User UpdateUser(User user)
{
try
{
udao.UpdateUser(user);
}
catch (Exception)
{
throw new Exceptions.UserException("User account updating failed.");
}
return user;
}
public User EnableUser(User user)
{
if ("administrator".CompareTo(user.UserName.ToLower()) == 0)
{
throw new Exceptions.UserException(@"Oh, ho! You are not allow to enable
the almighty Administrator account!");
}
user.IsEnabled = true;
return this.udao.UpdateUser(user);
}
public List<Disbursement> CreateDisbursementBySRF(User CreatedBy, StationeryRetrievalForm stationeryRetrievalForm)
{
return disbursementDAO.CreateDisbursementBySRF(CreatedBy, stationeryRetrievalForm.StationeryRetrievalFormID);
}
/// <summary>
/// Create a new User object.
/// </summary>
/// <param name="userID">Initial value of the UserID property.</param>
/// <param name="departmentID">Initial value of the DepartmentID property.</param>
/// <param name="userName">Initial value of the UserName property.</param>
/// <param name="membershipProviderKey">Initial value of the MembershipProviderKey property.</param>
/// <param name="email">Initial value of the Email property.</param>
/// <param name="isEnabled">Initial value of the IsEnabled property.</param>
public static User CreateUser(global::System.Int32 userID, global::System.Int32 departmentID, global::System.String userName, global::System.Guid membershipProviderKey, global::System.String email, global::System.Boolean isEnabled)
{
User user = new User();
user.UserID = userID;
user.DepartmentID = departmentID;
user.UserName = userName;
user.MembershipProviderKey = membershipProviderKey;
user.Email = email;
user.IsEnabled = isEnabled;
return user;
}
/// <summary>
/// Deprecated Method for adding a new object to the Users EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToUsers(User user)
{
base.AddObject("Users", user);
}
public StationeryRetrievalForm CreateStationeryRetrievalFormByAllRequisitions(User createdBy)
{
return stationeryRetrievalDAO.CreateStationeryRetrievalForm(createdBy, true, "");
}
