public bool DeleteMessage(int messageId, int userId, int deletedBy) { bool success = false; SqlParameter[] messageParamater = new SqlParameter[] { new SqlParameter("@message_id", DbType.Int32) }; messageParamater[0].Value = messageId; using (SqlConnection conn = new SqlConnection(SQLHelper.CONNECTION_STRING)) { conn.Open(); using (SqlTransaction sqlTran = conn.BeginTransaction()) { try { int noOfRecords = SQLHelper.ExecuteNonQuery(sqlTran, CommandType.StoredProcedure, SQLHelper.GetSQLStatement("Message", "SP_DELETE_STD_MESSAGE"), messageParamater); success = (noOfRecords > 0); AuditEntryInfo auditEntry = new AuditEntryInfo(Module.MessageManagement, messageId.ToString(), "Deleted message", userId, deletedBy); AuditTrail.WriteEntry(auditEntry, sqlTran); sqlTran.Commit(); } catch { sqlTran.Rollback(); throw; } } } return(success); }
public bool InsertCartItem(ShoppingCartItemInfo cartInfo, int ownerId) { bool success = false; SqlParameter[] messageParameters = GetCartItemParams(); messageParameters[0].Value = cartInfo.UserId; messageParameters[1].Value = cartInfo.ProductId; messageParameters[2].Value = cartInfo.Quantity; using (SqlConnection conn = new SqlConnection(SQLHelper.CONNECTION_STRING)) { conn.Open(); using (SqlTransaction sqlTran = conn.BeginTransaction()) { try { int noOfRecords = SQLHelper.ExecuteNonQuery(sqlTran, CommandType.StoredProcedure, SQLHelper.GetSQLStatement("ShoppingCart", "SP_INSERT_CARTITEM"), messageParameters); AuditEntryInfo auditEntry = new AuditEntryInfo(Module.ShoppingCart, cartInfo.ProductId, "Inserted cart item", cartInfo.UserId, ownerId); AuditTrail.WriteEntry(auditEntry, sqlTran); success = (noOfRecords > 0); sqlTran.Commit(); } catch { sqlTran.Rollback(); throw; } } } return(success); }
/// <summary> /// Updates the credit card details of the specified registration account. /// </summary> /// <param name="userId">Internal identifier of the user.</param> /// <param name="creditCard">Credit Card Information of the user.</param> public void UpdateCreditCard(int userId, CreditCardInfo creditCard) { using (SqlConnection connection = new SqlConnection(SQLHelper.CONNECTION_STRING)) { connection.Open(); using (SqlTransaction transaction = connection.BeginTransaction()) { try { UpdateCreditCard(userId, ref creditCard, transaction); AuditEntryInfo auditEntry = new AuditEntryInfo(Module.UpdateCreditCard, creditCard.Number, "Updated Credit Card", userId, userId); AuditTrail.WriteEntry(auditEntry, transaction); transaction.Commit(); } catch { transaction.Rollback(); throw; } } } }
public bool DeleteProduct(string productId, int userId) { bool success = false; SqlParameter[] sqlParam = new SqlParameter[] { new SqlParameter("@product_id", SqlDbType.NVarChar, 30) }; sqlParam[0].Value = productId; using (SqlConnection conn = new SqlConnection(SQLHelper.CONNECTION_STRING)) { conn.Open(); using (SqlTransaction sqlTran = conn.BeginTransaction()) { try { int noOfRecords = SQLHelper.ExecuteNonQuery(sqlTran, CommandType.StoredProcedure, SQLHelper.GetSQLStatement("Product", "SP_DELETE_PRODUCT"), sqlParam); success = (noOfRecords > 0); AuditEntryInfo auditEntry = new AuditEntryInfo(Module.ProductCatalog, productId, "Deleted product", userId, userId); AuditTrail.WriteEntry(auditEntry, sqlTran); sqlTran.Commit(); } catch { sqlTran.Rollback(); throw; } } } return(success); }
/// <summary> /// Deletes the specified design. /// </summary> /// <param name="designId">Internal identifier of the design to delete.</param> /// <param name="userId">Internal identifier of the user.</param> public void Delete(int designId, int userId) { // Get the design details. DesignInfo design = Get(designId); SqlParameter[] parameters = SQLHelper.GetCachedParameters("SP_DELETE_DESIGN"); if (parameters == null) { parameters = new SqlParameter[] { new SqlParameter("@design_id", SqlDbType.Int) }; SQLHelper.CacheParameters("SP_DELETE_DESIGN", parameters); } parameters[0].Value = designId; using (SqlConnection connection = new SqlConnection(SQLHelper.CONNECTION_STRING)) { connection.Open(); using (SqlTransaction transaction = connection.BeginTransaction()) { try { SQLHelper.ExecuteNonQuery(transaction, CommandType.StoredProcedure, SQLHelper.GetSQLStatement(MODULE_NAME, "SP_DELETE_DESIGN"), parameters); // Write entry into audit trail. string action = string.Empty; if (design.Status.LookupId == 23) { action = "Rejected design"; } else { action = "Deleted design"; } AuditEntryInfo auditEntry = new AuditEntryInfo( Module.DesignManagement, design.Category.Name, action, design.UserId, userId); AuditTrail.WriteEntry(auditEntry, transaction); transaction.Commit(); } catch { transaction.Rollback(); throw; } } } }
/// <summary> /// Inserts a registration account with user Work Space Area. /// </summary> /// <param name="registration">Registration Information of the user.</param> /// <param name="workSpacePath">String Path in which Workspase Directory</param> public int InsertWithWorkSpaceDirectory(RegistrationInfo registration, string workSpacePath) { int UserId = 0; SqlParameter[] registrationparameters = GetRegistrationParameters(); SqlParameter[] registrationAddressParameters; SetRegistrationParameters(registrationparameters, registration); using (SqlConnection connection = new SqlConnection(SQLHelper.CONNECTION_STRING)) { connection.Open(); using (SqlTransaction transaction = connection.BeginTransaction()) { try { SQLHelper.ExecuteNonQuery(transaction, CommandType.Text, SQLHelper.GetSQLStatement(MODULE_NAME, "SQL_INSERT_ACCOUNT"), registrationparameters); UserId = (int)registrationparameters[12].Value; registrationAddressParameters = GetRegistrationAddressParameters(); SetRegistrationAddressParameters(UserId, registrationAddressParameters, registration); SQLHelper.ExecuteNonQuery(transaction, CommandType.Text, SQLHelper.GetSQLStatement(MODULE_NAME, "SQL_INSERT_ACCOUNT_SHIPPINGADDRESS"), registrationAddressParameters); if (registration.CreditCard != null) { CreditCardInfo creditCard = registration.CreditCard; UpdateCreditCard(UserId, ref creditCard, transaction); } workSpacePath += UserId.ToString(); System.IO.Directory.CreateDirectory(workSpacePath); AuditEntryInfo auditEntry = new AuditEntryInfo(Module.Registration, registration.UserName, "User Registered", UserId, UserId); AuditTrail.WriteEntry(auditEntry, transaction); transaction.Commit(); } catch { transaction.Rollback(); throw; } } } return(UserId); }
public List <AccaInfo> UpdateEventInfo(List <AccaInfo> eventsInfo) { bool success = false; AuditEntryInfo auditEntry; using (SqlConnection conn = new SqlConnection(SQLHelper.CONNECTION_STRING)) { conn.Open(); using (SqlTransaction sqlTran = conn.BeginTransaction()) { try { List <AccaInfo> completedEvents = new List <AccaInfo>(); foreach (AccaInfo eventInfo in eventsInfo) { Order order = new Order(); if (eventInfo.EventStatus == ScheduleEventStatus.InProgress) { bool isEventPresent = false; foreach (AccaInfo completedEvent in completedEvents) { if (completedEvent.EventId == eventInfo.EventId) { eventInfo.AccaOrderInfo.OrderId = completedEvent.AccaOrderInfo.OrderId; isEventPresent = true; break; } } if (!isEventPresent) { eventInfo.AccaOrderInfo.OrderId = order.Insert(eventInfo.UserId, eventInfo.AccaOrderInfo, eventInfo.UserId); UpdateInventory(eventInfo.AccaDesignCategory.ToString(), eventInfo.ContactCount, eventInfo.UserId, sqlTran); auditEntry = new AuditEntryInfo(Module.AccaProcess, eventInfo.EventId.ToString(), "Updated Inventory", eventInfo.UserId, eventInfo.UserId); AuditTrail.WriteEntry(auditEntry, sqlTran); } completedEvents.Add(eventInfo); } UpdateEventInfoInDB(eventInfo, conn, sqlTran); auditEntry = new AuditEntryInfo(Module.AccaProcess, eventInfo.EventId.ToString(), "Updated event status", eventInfo.UserId, eventInfo.UserId); AuditTrail.WriteEntry(auditEntry, sqlTran); } sqlTran.Commit(); success = true; } catch { sqlTran.Rollback(); throw; } } } return(eventsInfo); }
public ShoppingCartInfo DeleteCartItem(int userId, string productId, IProduct product, int ownerId) { ShoppingCartInfo cartInfo = new ShoppingCartInfo(); List <ShoppingCartItemInfo> cartItems = new List <ShoppingCartItemInfo>(); ShoppingCartItemInfo cartItem; SqlParameter[] messageParamater = new SqlParameter[] { new SqlParameter("@product_id", SqlDbType.NVarChar, 30), new SqlParameter("@user_id", SqlDbType.Int) }; messageParamater[0].Value = productId; messageParamater[1].Value = userId; using (SqlConnection conn = new SqlConnection(SQLHelper.CONNECTION_STRING)) { conn.Open(); using (SqlTransaction sqlTran = conn.BeginTransaction()) { try { using (SqlDataReader reader = SQLHelper.ExecuteReader(SQLHelper.CONNECTION_STRING, CommandType.StoredProcedure, SQLHelper.GetSQLStatement("ShoppingCart", "SP_DELETE_CARTITEM"), messageParamater)) { AuditEntryInfo auditEntry = new AuditEntryInfo(Module.ShoppingCart, productId, "deleted shopping cart item", userId, ownerId); AuditTrail.WriteEntry(auditEntry, sqlTran); while (reader.Read()) { cartItem = new ShoppingCartItemInfo(); cartItem.ProductId = (string)reader["product_id"]; cartItem.Price = Math.Round((decimal)reader["price"], 2); cartItem.Quantity = (int)reader["quantity"]; cartItem.Description = product.GetProductDetails(cartItem.ProductId).BriefDescWithQuantity; cartItem.TotalPrice = cartItem.Quantity * cartItem.Price; cartItem.UserId = userId; cartItems.Add(cartItem); cartInfo.Tax = Math.Round((decimal)reader["Tax"], 2); } } sqlTran.Commit(); } catch { sqlTran.Rollback(); throw; } } } cartInfo.CartItems = cartItems; return(cartInfo); }
public bool InsertMessage(MessageInfo messageInfo, int userId) { bool success = false; SqlParameter[] messageParameters = GetStdMessageParams(); messageParameters[0].Value = messageInfo.MessageId; messageParameters[1].Value = (int)messageInfo.MessageType; messageParameters[2].Value = messageInfo.ShortDesc; messageParameters[3].Value = messageInfo.MessageText; messageParameters[4].Value = messageInfo.Status; messageParameters[5].Value = userId; messageParameters[6].Value = messageInfo.IsImage; messageParameters[8].Value = messageInfo.IsDefaultMessage; if (messageInfo.FileName != string.Empty) { messageParameters[7].Value = messageInfo.FileName; } using (SqlConnection conn = new SqlConnection(SQLHelper.CONNECTION_STRING)) { conn.Open(); using (SqlTransaction sqlTran = conn.BeginTransaction()) { try { int noOfRecords = SQLHelper.ExecuteNonQuery(sqlTran, CommandType.StoredProcedure, SQLHelper.GetSQLStatement("Message", "SP_INSERT_MESSAGE"), messageParameters); success = (noOfRecords > 0); AuditEntryInfo auditEntry = new AuditEntryInfo(Module.MessageManagement, messageInfo.ShortDesc, "Inserted message", userId, userId); AuditTrail.WriteEntry(auditEntry, sqlTran); sqlTran.Commit(); } catch { sqlTran.Rollback(); throw; } } } return(success); }
/// <summary> /// Updates security details of the registration account. /// </summary> /// <param name="registration">Registration Information of the user.</param> public void UpdateSecretDetails(RegistrationInfo registration) { SqlParameter[] parameters = SQLHelper.GetCachedParameters("SQL_UPDATE_SECURITYQUESTION"); if (parameters == null) { parameters = new SqlParameter[] { new SqlParameter("@passwordQuestion", SqlDbType.NVarChar, 255), new SqlParameter("@passwordAnswer", SqlDbType.NVarChar, 256), new SqlParameter("@UserId", SqlDbType.Int) }; } parameters[0].Value = registration.PasswordQuestion; parameters[1].Value = registration.PasswordAnswer; parameters[2].Value = registration.UserId; using (SqlConnection connection = new SqlConnection(SQLHelper.CONNECTION_STRING)) { connection.Open(); using (SqlTransaction transaction = connection.BeginTransaction()) { try { SQLHelper.ExecuteNonQuery(transaction, CommandType.Text, SQLHelper.GetSQLStatement(MODULE_NAME, "SQL_UPDATE_SECURITYQUESTION"), parameters); AuditEntryInfo auditEntry = new AuditEntryInfo(Module.ChangeSecretQuestion, registration.UserName, "Updated Security Details", registration.UserId, registration.UserId); AuditTrail.WriteEntry(auditEntry, transaction); transaction.Commit(); } catch { transaction.Rollback(); throw; } } } }
public bool UpdateCartItem(List <ShoppingCartItemInfo> cartItems, int ownerId) { bool success = false; SqlParameter[] messageParamater = new SqlParameter[] { new SqlParameter("@product_id", SqlDbType.NVarChar, 30), new SqlParameter("@user_id", SqlDbType.Int), new SqlParameter("@quantity", SqlDbType.Int) }; using (SqlConnection conn = new SqlConnection(SQLHelper.CONNECTION_STRING)) { conn.Open(); using (SqlTransaction sqlTran = conn.BeginTransaction()) { foreach (ShoppingCartItemInfo cartItem in cartItems) { try { messageParamater[0].Value = cartItem.ProductId; messageParamater[1].Value = cartItem.UserId; messageParamater[2].Value = cartItem.Quantity; int noOfRecords = SQLHelper.ExecuteNonQuery(sqlTran, CommandType.StoredProcedure, SQLHelper.GetSQLStatement("ShoppingCart", "SP_UPDATE_CARTITEM"), messageParamater); AuditEntryInfo auditEntry = new AuditEntryInfo(Module.ShoppingCart, cartItem.ProductId, "Inserted cart item", cartItem.UserId, ownerId); AuditTrail.WriteEntry(auditEntry, sqlTran); success = (noOfRecords > 0); } catch { sqlTran.Rollback(); throw; } } sqlTran.Commit(); } } return(success); }
/// <summary> /// Updates the status of the specified registration account. /// </summary> /// <param name="userId">Internal identifier of the user.</param> /// <param name="status">Status of the user.</param> public void UpdateStatus(int userId, RegistrationStatus status, int userLoginId) { string statusText = ""; using (SqlConnection connection = new SqlConnection(SQLHelper.CONNECTION_STRING)) { connection.Open(); using (SqlTransaction transaction = connection.BeginTransaction()) { try { UpdateStatus(userId, status, transaction); if (status == RegistrationStatus.Active) { statusText = "User Activated or Approved"; } else if (status == RegistrationStatus.Inactive) { statusText = "User Inactivated"; } AuditEntryInfo auditEntry = new AuditEntryInfo(Module.UserManagement, userId.ToString(), statusText, userId, userLoginId); AuditTrail.WriteEntry(auditEntry, transaction); transaction.Commit(); } catch { transaction.Rollback(); throw; } } } }
/// <summary> /// Inserts an order for the specified user. /// </summary> /// <param name="userId">Internal identifier of the user.</param> /// <param name="order">Order Information for the user.</param> public int Insert(int userId, OrderInfo order, int ownerId) { int orderId = 0; using (SqlConnection connection = new SqlConnection(SQLHelper.CONNECTION_STRING)) { connection.Open(); using (SqlTransaction transaction = connection.BeginTransaction()) { try { // Get the details of the credit card. Registration registration = new DAL.Registration(); // Insert Order Details. SqlParameter[] parameters = SQLHelper.GetCachedParameters("SQL_INSERT_ORDER"); if (parameters == null) { parameters = new SqlParameter[] { new SqlParameter("@OrderId", SqlDbType.Int), new SqlParameter("@OrderNumber", SqlDbType.Int), new SqlParameter("@OrderType", SqlDbType.Int), new SqlParameter("@OrderDate", SqlDbType.DateTime), new SqlParameter("@Amount", SqlDbType.Decimal), new SqlParameter("@TransactionCode", SqlDbType.Int), new SqlParameter("@TransactionMessage", SqlDbType.NVarChar, 255), new SqlParameter("@CreditCardTypeId", SqlDbType.Int), new SqlParameter("@CreditCardNo", SqlDbType.NVarChar, 20), new SqlParameter("@CVVNo", SqlDbType.NVarChar, 4), new SqlParameter("@HolderName", SqlDbType.NVarChar, 50), new SqlParameter("@ExpirationMonth", SqlDbType.Int), new SqlParameter("@ExpirationYear", SqlDbType.Int), new SqlParameter("@BillingAddress1", SqlDbType.NVarChar, 255), new SqlParameter("@BillingAddress2", SqlDbType.NVarChar, 255), new SqlParameter("@BillingCity", SqlDbType.NVarChar, 100), new SqlParameter("@BillingStateId", SqlDbType.Int), new SqlParameter("@BillingZip", SqlDbType.NVarChar, 15), new SqlParameter("@BillingCountryId", SqlDbType.Int), new SqlParameter("@UserId", SqlDbType.Int) }; SQLHelper.CacheParameters("SQL_INSERT_ORDER", parameters); } parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = order.Number; parameters[2].Value = order.Type; parameters[3].Value = order.Date; parameters[4].Value = order.Amount; parameters[5].Value = order.TransactionCode; parameters[6].Value = order.TransactionMessage; parameters[7].Value = order.CreditCard.Type.LookupId; parameters[8].Value = order.CreditCard.Number; parameters[9].Value = order.CreditCard.CvvNumber; parameters[10].Value = order.CreditCard.HolderName; parameters[11].Value = order.CreditCard.ExpirationMonth; parameters[12].Value = order.CreditCard.ExpirationYear; parameters[13].Value = order.CreditCard.Address.Address1; parameters[14].Value = order.CreditCard.Address.Address2; parameters[15].Value = order.CreditCard.Address.City; parameters[16].Value = order.CreditCard.Address.State.StateId; parameters[17].Value = order.CreditCard.Address.Zip; parameters[18].Value = order.CreditCard.Address.Country.CountryId; parameters[19].Value = userId; SQLHelper.ExecuteNonQuery(transaction, CommandType.Text, SQLHelper.GetSQLStatement(MODULE_NAME, "SQL_INSERT_ORDER"), parameters); orderId = (int)parameters[0].Value; AuditEntryInfo auditEntry = new AuditEntryInfo(Module.OrderManagement, orderId.ToString(), "Inserted order header", userId, ownerId); AuditTrail.WriteEntry(auditEntry, transaction); if (order.Items != null) { parameters = SQLHelper.GetCachedParameters("SQL_INSERT_ORDER_DETAIL"); if (parameters == null) { parameters = new SqlParameter[] { new SqlParameter("@OrderId", SqlDbType.Int), new SqlParameter("@line_number", SqlDbType.Int), new SqlParameter("@ItemId", SqlDbType.NVarChar, 30), new SqlParameter("@Quantity", SqlDbType.Int), new SqlParameter("@Rate", SqlDbType.Decimal) }; SQLHelper.CacheParameters("SQL_INSERT_ORDER_DETAIL", parameters); } int lineNumber = 1; foreach (OrderItemInfo orderItem in order.Items) { parameters[0].Value = orderId; parameters[1].Value = lineNumber; parameters[2].Value = orderItem.ItemId; parameters[3].Value = orderItem.Quantity; parameters[4].Value = orderItem.Rate; SQLHelper.ExecuteNonQuery(transaction, CommandType.Text, SQLHelper.GetSQLStatement(MODULE_NAME, "SQL_INSERT_ORDER_DETAIL"), parameters); auditEntry = new AuditEntryInfo(Module.OrderManagement, orderId.ToString(), "Inserted order detail", userId, ownerId); AuditTrail.WriteEntry(auditEntry, transaction); Product product = new Product(); if (order.Type == OrderType.ShoppingCart && order.TransactionStatus) { ProductInfo productInfo = product.GetProductDetails(orderItem.ItemId); foreach (ProductItemInfo productItemInfo in productInfo.ProductItems) { SqlParameter[] messageParameters = GetCartItemParams(); messageParameters[0].Value = userId; messageParameters[1].Value = productItemInfo.ProductTypeId; messageParameters[2].Value = orderItem.Quantity * productItemInfo.Quantity; SQLHelper.ExecuteNonQuery(transaction, CommandType.StoredProcedure, SQLHelper.GetSQLStatement(MODULE_NAME, "SP_INSERT_UPDATE_INVENTORY"), messageParameters); auditEntry = new AuditEntryInfo(Module.OrderManagement, productItemInfo.ProductTypeId.ToString(), "Updated inventory", userId, ownerId); AuditTrail.WriteEntry(auditEntry, transaction); } } } } // Update the user status if the type of payment is Membership Fees. if (order.Type == OrderType.MembershipFee) { //registration.UpdateStatus(userId, // RegistrationStatus.MembershipPaid, transaction); } if (order.Type == OrderType.ShoppingCart) { ShoppingCart cart = new ShoppingCart(); cart.DeleteCartItem(userId, string.Empty, new Product(), ownerId); } transaction.Commit(); } catch { transaction.Rollback(); throw; } } } return(orderId); }
/// <summary> /// Updates the design of the specified user. /// </summary> /// <param name="userId">Internal identifier of the user.</param> /// <param name="design">Design of the user.</param> public void Update(int userId, DesignInfo design) { SqlParameter[] parameters = SQLHelper.GetCachedParameters("SP_UPDATE_DESIGN"); if (parameters == null) { parameters = new SqlParameter[] { new SqlParameter("@design_id", SqlDbType.Int), new SqlParameter("@user_id", SqlDbType.Int), new SqlParameter("@category", SqlDbType.Int), new SqlParameter("@type", SqlDbType.Int), new SqlParameter("@length", SqlDbType.Decimal), new SqlParameter("@width", SqlDbType.Decimal), new SqlParameter("@gender", SqlDbType.NVarChar, 50), new SqlParameter("@on_design_name", SqlDbType.NVarChar, 50), new SqlParameter("@justification", SqlDbType.Int), new SqlParameter("@gutter", SqlDbType.NVarChar, 50), new SqlParameter("@msg_locn_x", SqlDbType.Decimal), new SqlParameter("@msg_locn_y", SqlDbType.Decimal), new SqlParameter("@msg_size_length", SqlDbType.Decimal), new SqlParameter("@msg_size_width", SqlDbType.Decimal), new SqlParameter("@low_res_file", SqlDbType.NVarChar, 255), new SqlParameter("@high_res_file", SqlDbType.NVarChar, 255), new SqlParameter("@extra_file", SqlDbType.NVarChar, 255), new SqlParameter("@status", SqlDbType.Int), new SqlParameter("@last_modify_by", SqlDbType.Int), new SqlParameter("@approve_by", SqlDbType.Int), new SqlParameter("@comments", SqlDbType.Text) }; SQLHelper.CacheParameters("SP_UPDATE_DESIGN", parameters); } parameters[0].Value = design.DesignId; parameters[1].Value = design.UserId; parameters[2].Value = design.Category.LookupId; parameters[3].Value = design.Type.LookupId; parameters[4].Value = design.Size.Width; parameters[5].Value = design.Size.Height; parameters[6].Value = design.Gender; parameters[7].Value = design.OnDesignName; parameters[8].Value = design.Justification; parameters[9].Value = design.Gutter; parameters[10].Value = design.MessageRectangle.X; parameters[11].Value = design.MessageRectangle.Y; parameters[12].Value = design.MessageRectangle.Width; parameters[13].Value = design.MessageRectangle.Height; parameters[14].Value = design.LowResolutionFile; parameters[15].Value = design.HighResolutionFile; parameters[16].Value = design.ExtraFile; parameters[17].Value = design.Status.LookupId; parameters[18].Value = design.LastModifyBy; parameters[19].Value = design.ApproveBy; parameters[20].Value = design.Comments; using (SqlConnection connection = new SqlConnection(SQLHelper.CONNECTION_STRING)) { connection.Open(); using (SqlTransaction transaction = connection.BeginTransaction()) { try { SQLHelper.ExecuteNonQuery(transaction, CommandType.StoredProcedure, SQLHelper.GetSQLStatement(MODULE_NAME, "SP_UPDATE_DESIGN"), parameters); // Write entry into audit trail. string action = string.Empty; if (design.DesignId == 0) { if (design.Status.LookupId == 23) { action = "Submitted design"; } else { action = "Added design"; } } else { if (design.Status.LookupId == 23) { if (design.UserId == design.LastModifyBy) { action = "Submitted design"; } else { action = "Modified design"; } } else if (design.Status.LookupId == 25) { action = "Archived design"; } else if (design.Status.LookupId == 26) { action = "Approved design"; } else { action = "Modified design"; } } AuditEntryInfo auditEntry = new AuditEntryInfo( Module.DesignManagement, design.Category.Name, action, design.UserId, design.LastModifyBy); AuditTrail.WriteEntry(auditEntry, transaction); transaction.Commit(); } catch { transaction.Rollback(); throw; } } } }
/// <summary> /// Updates a registration account. /// </summary> /// <param name="registration">Registration Information of the user.</param> public void Update(RegistrationInfo registration, int userLoginId) { SqlParameter[] parameters = SQLHelper.GetCachedParameters("SP_UPDATE_ACCOUNT"); if (parameters == null) { parameters = new SqlParameter[] { new SqlParameter("@UserId", SqlDbType.Int), new SqlParameter("@FirstName", SqlDbType.NVarChar, 50), new SqlParameter("@MiddleName", SqlDbType.NVarChar, 50), new SqlParameter("@LastName", SqlDbType.NVarChar, 50), new SqlParameter("@CompanyName", SqlDbType.NVarChar, 200), new SqlParameter("@Address1", SqlDbType.NVarChar, 255), new SqlParameter("@Address2", SqlDbType.NVarChar, 255), new SqlParameter("@City", SqlDbType.NVarChar, 100), new SqlParameter("@StateId", SqlDbType.Int), new SqlParameter("@Zip", SqlDbType.NVarChar, 15), new SqlParameter("@CountryId", SqlDbType.Int), new SqlParameter("@Phone", SqlDbType.NVarChar, 20), new SqlParameter("@Fax", SqlDbType.NVarChar, 20), new SqlParameter("@Mobile", SqlDbType.NVarChar, 20), new SqlParameter("@Email", SqlDbType.NVarChar, 256), new SqlParameter("@Role", SqlDbType.Int), new SqlParameter("@Status", SqlDbType.Int) }; } SQLHelper.CacheParameters("SP_UPDATE_ACCOUNT", parameters); parameters[0].Value = registration.UserId; parameters[1].Value = registration.FirstName; parameters[2].Value = registration.MiddleName; parameters[3].Value = registration.LastName; parameters[4].Value = registration.CompanyName; parameters[5].Value = registration.Address.Address1; parameters[6].Value = registration.Address.Address2; parameters[7].Value = registration.Address.City; parameters[8].Value = registration.Address.State.StateId; parameters[9].Value = registration.Address.Zip; parameters[10].Value = registration.Address.Country.CountryId; parameters[11].Value = registration.Address.Phone; parameters[12].Value = registration.Address.Fax; parameters[13].Value = registration.Address.Mobile; parameters[14].Value = registration.Email; parameters[15].Value = registration.Role; parameters[16].Value = registration.Status; using (SqlConnection connection = new SqlConnection(SQLHelper.CONNECTION_STRING)) { connection.Open(); using (SqlTransaction transaction = connection.BeginTransaction()) { try { SQLHelper.ExecuteNonQuery(transaction, CommandType.StoredProcedure, SQLHelper.GetSQLStatement(MODULE_NAME, "SP_UPDATE_ACCOUNT"), parameters); AuditEntryInfo auditEntry = new AuditEntryInfo(Module.UpdateProfile, registration.UserName, "Updated Profile", registration.UserId, userLoginId); AuditTrail.WriteEntry(auditEntry, transaction); transaction.Commit(); } catch (SqlException ex) { transaction.Rollback(); throw; } } } }
public bool UpdateProduct(ProductInfo productInfo) { bool success = false; SqlParameter[] messageParameters = GetProductHeaderParams(); messageParameters[0].Value = productInfo.ProductId; if (productInfo.BriefDesc != string.Empty) { messageParameters[1].Value = productInfo.BriefDesc; } messageParameters[2].Value = productInfo.ExtDesc; messageParameters[3].Value = (int)productInfo.ProductStatus; messageParameters[4].Value = productInfo.TotalPrice; messageParameters[5].Value = productInfo.OwnerId; using (SqlConnection conn = new SqlConnection(SQLHelper.CONNECTION_STRING)) { conn.Open(); using (SqlTransaction sqlTran = conn.BeginTransaction()) { bool isCustom = false; try { int noOfRecords = SQLHelper.ExecuteNonQuery(sqlTran, CommandType.StoredProcedure, SQLHelper.GetSQLStatement("Product", "SP_UPDATE_PRODUCTHEADER"), messageParameters); AuditEntryInfo auditEntry = new AuditEntryInfo(Module.ProductCatalog, productInfo.ProductId, "Updated product header", productInfo.OwnerId, productInfo.OwnerId); AuditTrail.WriteEntry(auditEntry, sqlTran); success = true; foreach (ProductItemInfo itemInfo in productInfo.ProductItems) { SqlParameter[] messageDetailsParameters = GetProductDetailsParams(); messageDetailsParameters[0].Value = productInfo.ProductId; messageDetailsParameters[1].Value = 0; messageDetailsParameters[2].Value = itemInfo.ProductTypeId; messageDetailsParameters[3].Value = itemInfo.Quantity; if (itemInfo.Size.Count > 0) { messageDetailsParameters[4].Value = itemInfo.Size[0]; } if (itemInfo.IsCustomSize || isCustom) { messageDetailsParameters[5].Value = itemInfo.AgentUserId; isCustom = true; } else { messageDetailsParameters[5].Value = DBNull.Value; } noOfRecords = SQLHelper.ExecuteNonQuery(sqlTran, CommandType.StoredProcedure, SQLHelper.GetSQLStatement("Product", "SP_UPDATE_PRODUCTDETAILS"), messageDetailsParameters); auditEntry = new AuditEntryInfo(Module.ProductCatalog, productInfo.ProductId + "-" + itemInfo.ProductTypeId, "Updated product details", productInfo.OwnerId, isCustom ? itemInfo.AgentUserId : productInfo.OwnerId); AuditTrail.WriteEntry(auditEntry, sqlTran); } sqlTran.Commit(); success = true; } catch { sqlTran.Rollback(); success = false; throw; } } } return(success); }