public virtual void Shoot(float delta) { if (timeBetweenShots <= 0) { if (enemyBulletScene != null) { var bulletRoot = enemyBulletScene.Instance(); var bullet = bulletRoot.GetNode <BulletComponent>("BulletComponent"); float rotationDegrees = Utlities.LookAtSomething(player.Position, GlobalPosition); Utlities.SetNode2DParams(ref bullet, GlobalPosition, rotationDegrees); GetTree().CurrentScene.AddChild(bulletRoot); timeBetweenShots = startTimeBetweenShots; } else { return; } } else { timeBetweenShots -= delta; } }
public override void Shoot(float delta) { List <Node> bullets = new List <Node>(); if (timeBetweenShots <= 0) { for (int i = 0; i < maxBullets; i++) { var bulletRoot = enemyBulletScene.Instance(); bullets.Add(bulletRoot); float rotationDegrees = Utlities.LookAtSomething(player.Position, GlobalPosition) + (45 * i); var bullet = bullets[i].GetNode <Node2D>("BulletComponent"); Utlities.SetNode2DParams(ref bullet, GlobalPosition, rotationDegrees); GetTree().CurrentScene.AddChild(bullets[i]); } timeBetweenShots = startTimeBetweenShots; bullets.Clear(); } else { timeBetweenShots -= delta; } }
public override void Shoot(Vector2 lookDir, float delta) { List <ShotgunShell> bullets = new List <ShotgunShell>(); if (timeBetweenShots <= 0) { if (Input.IsActionPressed("Shoot")) { for (int i = 0; i < maxBullets; i++) { var bulletRoot = bulletScene.Instance() as ShotgunShell; bullets.Add(bulletRoot); } for (int i = 0; i < bullets.Count; i++) { float rotationDegrees = Utlities.LookAtSomething(GetGlobalMousePosition(), GlobalPosition) + (20 * i); var bullet = bullets[i].GetNode <BulletComponent>("BulletComponent"); Utlities.SetNode2DParams(ref bullet, firepoint.GlobalPosition, rotationDegrees); GetTree().CurrentScene.AddChild(bullets[i]); } timeBetweenShots = startTimeBetweenShots; bullets.Clear(); } } else { timeBetweenShots -= delta; } }
public async Task <IActionResult> Create(int RoomID, DateTime CheckInDate, DateTime CheckOutDate, Guest guest, Payment payment, int Amount) { int guestid = GuestDAO.InsertGuest(guest); int paymentid = PaymentDAO.InsertPayment(payment); int bookingid = BookingDAO.InsertBooking(new Booking() { RoomID = RoomID, CheckInDate = CheckInDate.AddHours(14), CheckOutDate = CheckOutDate.AddHours(12).AddMinutes(5), GuestID = guestid, Amount = (int)(CheckOutDate - CheckInDate).TotalDays * RoomsDAO.GetRoomModel(RoomID).RoomType.Price, PaymentID = paymentid, }); var model = BookingDAO.GetBookingModel(bookingid); string body = await Utlities.RenderViewToStringAsync <BookingModel>(this, "~/Areas/Guests/Views/Partial/_ConfirmEmail.cshtml", model); MailMessage mail = new MailMessage(); mail.From = new MailAddress("*****@*****.**"); mail.To.Add(guest.Email); mail.Subject = "Congratulations on your successful booking"; mail.Body = body; mail.IsBodyHtml = true; Utlities.SendEmail(mail); return(View()); }
public string AttackRequst(FormCollection collection) { string id = Request.Form["PlayerId"]; PlayerForDataBase thisPlayerData = dataBase.PlayerinDataBase.Find(id); thisPlayerData.UpdatePropertyByTime(); if(0 < thisPlayerData.remaningTimeToNextAttack) { return false.ToString(); } string enemyId = new PlayerListManager().NextIdForAtack(id); if (enemyId != null) { //Theif2dDataDBContext dataBase = new Theif2dDataDBContext(); PlayerForDataBase PlayerData = dataBase.PlayerinDataBase.Find(enemyId); if(PlayerData != null) { PlayerForSerialize playerDataForSerialize = new Utlities().ConvertBuildingDataBaseToSerialize(PlayerData); LogSystem.AddPlayerLog(id, "player" + id.ToString() + " attacked " + PlayerData.ID + " ID"); string uu = new JavaScriptSerializer().Serialize(playerDataForSerialize); return uu; } return false.ToString(); } else { return false.ToString(); } }
public string LoadPlayerData2(FormCollection collection) { string id = Request.Form["PlayerId"]; string Shipname = Request.Form["Shipname"]; string Password = Request.Form["Password"]; string PasswordForCreation = "11111"; string PasswordForEdit = "11111"; new Theif2dDataDBContext().LoadForFisttimeIfNessecary(); if (Shipname == "PlayerShip") { ShipForDataBase findedShip = dataBase.AllShips.Find(id); if (findedShip == null) { AddNew.WaitOne(); findedShip = new Utlities().returnDefultShip(); //AllShips.buildingCode = dataBase.ShipBaseDataBase.Find(1).BaseString; string ss = new Random().NextDouble().ToString(); int index = dataBase.PlayerinDataBase.Count <PlayerForDataBase>() + 1; findedShip.OwnerID = index.ToString() + ss; dataBase.AllShips.Add(findedShip); dataBase.SaveChanges(); AddNew.ReleaseMutex(); // new PlayerListManager().AddPlayerInfo(PlayerData); } else { findedShip.UpdatePropertyByTime(); dataBase.Entry(findedShip).State = EntityState.Modified; dataBase.SaveChanges(); // new PlayerListManager().UpdatePlayerInfo(PlayerData); } LogSystem.AddPlayerLog(findedShip.OwnerID, "Ship" + findedShip.OwnerID.ToString() + " added "); ShipForSerialize fors = new ShipForSerialize(); fors.SetAccordingTodataBAse(findedShip); string uu = new JavaScriptSerializer().Serialize(fors); return(uu); } else { string code = Shipname + Password; ShipForDataBase findedShip = dataBase.AllShips.Find(code); if (findedShip == null) { if (Password == PasswordForCreation) { return("UnderConstuction"); } else { return("shipNotFinded & CreationPaswordIsWrong"); } } else { return("UnderConstuction"); } } }
public override void UnEquip() { inventory.RemoveItemFromInventory(this); var shotgun = weaponScene.Instance() as Shotgun; shotgun.Position = GetTree().CurrentScene.GetNode <Player>("Player").Position; shotgun.RotationDegrees = Utlities.LookAtMouse(GetGlobalMousePosition(), shotgun.Position); GetTree().CurrentScene.AddChild(shotgun); }
public override void UnEquip() { inventory.RemoveItemFromInventory(this); var rocketLauncher = weaponScene.Instance() as RocketLauncher; rocketLauncher.Position = GetTree().CurrentScene.GetNode <Player>("Player").Position; rocketLauncher.RotationDegrees = Utlities.LookAtMouse(GetGlobalMousePosition(), rocketLauncher.Position); GetTree().CurrentScene.AddChild(rocketLauncher); }
public override void _Ready() { player = GetTree().CurrentScene.GetNode <Player>("Player"); sprite = GetNode <Sprite>("EnemySprite"); GlobalPosition = Utlities.RandPosition(new Vector2(320f, 180f), GetTree()); timeBetweenShots = startTimeBetweenShots; Connect("SEnemyDied", GetTree().CurrentScene, "OnEnemyDied"); Connect("SSpawnPoints", GetTree().CurrentScene, "SpawnPoints"); }
public static string AddSubscribersToTracking(int cid, string userID) { subIDs = M_Campaigns.GetSubscribersForCampaign(cid); string id = Guid.NewGuid().ToString(); if (subIDs.Count != 0) { using (dbcontext = new ApplicationDbContext()) { try { foreach (var item in subIDs) { track = new M_Tracking(); track.CampId = cid; track.SubsciberId = item; track.IsOpened = false; track.IdentifierSubscriber = Guid.NewGuid().ToString(); track.IdentifierCampaign = id; track.MailStatus = false; track.UserID = userID; dbcontext.M_Trackings.Add(track); dbcontext.SaveChanges(); } } catch (SqlException ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.InnerException.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL(), ex.LineNumber); obj.LogException(); throw obj; } catch (InvalidOperationException ex) { obj = new M_CustomException((int)ErorrTypes.InvalidOperation, ex.InnerException.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } catch (ArgumentNullException ex) { obj = new M_CustomException((int)ErorrTypes.ArgumentNullExceptions, ex.InnerException.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } catch (Exception ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.InnerException.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } } } return(track.IdentifierCampaign); }
/// <summary> /// Update list to database /// </summary> /// <returns>true or false</returns> public bool UpdateList() { this.LastUpdated = DateTime.Now; using (dbcontext = new ApplicationDbContext()) { try { dbcontext.Entry(this).State = System.Data.Entity.EntityState.Modified; dbcontext.SaveChanges(); } catch (SqlException ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL(), ex.LineNumber); obj.LogException(); throw obj; } catch (Exception ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } } return(true); }
/// <summary> /// Gets list information to be edited /// </summary> /// <param name="listID"></param> /// <returns>List obejct</returns> public M_List EditList(int?listID) { newList = new M_List(); using (dbcontext = new ApplicationDbContext()) { try { newList = dbcontext.M_Lists.Find(listID); } catch (SqlException ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL(), ex.LineNumber); obj.LogException(); throw obj; } catch (Exception ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } } return(newList); }
/// <summary> /// Get lists to display for user /// </summary> /// <param name="userID"></param> /// <returns>return list view model which contains list information and count of its subcribers and unsubscribers</returns> public ListViewModel ViewList(string userID) { // NewList lst = null; //listIds = new List<int?>(); // listIds = GetListIds(userID); using (dbcontext = new ApplicationDbContext()) { try { LVmodel.lists = (from list in dbcontext.M_Lists join users in dbcontext.UsersList on list.ListID equals users.ListID where users.UsersID == userID select list).ToList(); foreach (var i in LVmodel.lists) { //int cnt = (from list in LVmodel.lists // join sub in dbcontext.Subscribers // on list.ListID equals sub.ListID // where sub.ListID == i.ListID // select sub).Count(); int cnt = (from list in LVmodel.lists join sub in dbcontext.ListSusbscribers on list.ListID equals sub.ListID where sub.ListID == i.ListID select list).Count(); LVmodel.NoOfSubscribers.Add(cnt); } //foreach (var item in listIds) //{ // lst = new NewList(); // lst = dbcontext.NewLists.Where(u => u.ListID == item).FirstOrDefault(); // LVmodel.lists.Add(lst); // var cnt = dbcontext.Subscribers.Where(l => l.ListID == item && l.Unsubscribe == false).Count(); // LVmodel.NoOfSubscribers.Add(cnt); //} } catch (SqlException ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL(), ex.LineNumber); obj.LogException(); throw obj; } catch (Exception ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } } return(LVmodel); }
/// <summary> /// Get subscriber to be edited /// </summary> /// <param name="sid"></param> /// <returns></returns> public M_Subscriber Edit(int?sid) { if (sid != null) { using (dbcontext = new ApplicationDbContext()) { try { subscriber = dbcontext.M_Subscribers.Find(sid); } catch (SqlException ex) { obj = new M_CustomException((int)ErorrTypes.SqlExceptions, "Problem in saving data", ex.StackTrace, ErorrTypes.SqlExceptions.ToString(), Utlities.GetURL(), ex.LineNumber); obj.LogException(); throw obj; } catch (Exception ex) { obj = new M_CustomException((int)ErorrTypes.others, "Some problem occured while processing request", ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } } } return(subscriber); }
/// <summary> /// collection of emailaddress for peticular list /// </summary> /// <param name="userID">collection of list ids for perticular user</param> /// <returns></returns> public List <string> getSubscribers(string userID) { subscriberEmail = new List <string>(); listIds = new List <int?>(); listIds = M_List.GetListIds(userID); using (dbcontext = new ApplicationDbContext()) { foreach (var item in listIds) { try { subscriberEmail.Add(dbcontext.M_Subscribers.Where(l => l.ListID == item).Select(s => s.EmailAddress).FirstOrDefault()); } catch (SqlException ex) { obj = new M_CustomException((int)ErorrTypes.SqlExceptions, ex.Message, ex.StackTrace, ErorrTypes.SqlExceptions.ToString(), Utlities.GetURL(), ex.LineNumber); obj.LogException(); throw obj; } catch (Exception ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } } } return(subscriberEmail); }
/// <summary> /// Save the subscriber with thier status , so that the Windows service can send mail to user /// </summary> /// <param name="usrId"></param> /// <param name="campId"></param> /// <param name="listId"></param> /// <param name="subId"></param> public void settingMail(string usrId, int campId, int listId, int subId) { dbContext = new ApplicationDbContext(); this.UserId = usrId; this.CampId = campId; this.ListId = listId; this.StatusId = 4; this.SubscriberId = subId; try { dbContext.M_MailStatus.Add(this); dbContext.SaveChanges(); } catch (SqlException ex) { obj = new M_CustomException((int)ErorrTypes.SqlExceptions, "Problem in saving data", ex.StackTrace, ErorrTypes.SqlExceptions.ToString(), UserId, Utlities.GetURL(), ex.LineNumber); obj.LogException(); throw obj; } }
/// <summary> /// Save subscriber to database /// </summary> /// <param name="listID">list from which subscriber belogs</param> /// <param name="userID"></param> public void saveSubscriber(string userID) { ListSusbscriber lSub = new ListSusbscriber(); if (isSubscriberExist(this.EmailAddress, this.ListID, userID) == false) { lSub.ListID = this.ListID; // this.StatusID = 3; this.AddedDate = DateTime.Now; using (dbcontext = new ApplicationDbContext()) { using (var trans = dbcontext.Database.BeginTransaction()) { //Subscriber not present in list try { dbcontext.M_Subscribers.Add(this); dbcontext.SaveChanges(); lSub.SubscribersID = this.SubscriberID; dbcontext.ListSusbscribers.Add(lSub); dbcontext.SaveChanges(); trans.Commit(); } catch (SqlException ex) { //failed to save in subscriber or listsubscriber,clear model ans add model error trans.Rollback(); obj = new M_CustomException((int)ErorrTypes.SqlExceptions, "Problem in saving data", ex.StackTrace, ErorrTypes.SqlExceptions.ToString(), Utlities.GetURL(), ex.LineNumber); obj.LogException(); throw obj; } catch (Exception ex) { trans.Rollback(); obj = new M_CustomException((int)ErorrTypes.others, "Some problem occured while processing request", ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } } } } else { //Subscriber already present in list,clear model ans add model error } }
public static bool Unsub(string subid) { using (dbcontext = new ApplicationDbContext()) { subscriber = new M_Subscriber(); int?id; if (subid != null) { try { id = dbcontext.M_Trackings.Where(t => t.IdentifierSubscriber == subid).Select(t => t.SubsciberId).FirstOrDefault(); subscriber = dbcontext.M_Subscribers.Find(id); subscriber.Unsubscribe = true; dbcontext.M_Subscribers.Attach(subscriber); dbcontext.Entry(subscriber).Property(p => p.Unsubscribe).IsModified = true; dbcontext.SaveChanges(); return(true); } catch (SqlException ex) { obj = new M_CustomException((int)ErorrTypes.SqlExceptions, ex.Message, ex.StackTrace, ErorrTypes.SqlExceptions.ToString(), Utlities.GetURL(), ex.LineNumber); obj.LogException(); throw obj; } catch (Exception ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } } else { return(false); } } }
public List <M_Subscriber> Unsubscriber(int?lid) { // listIds = list.GetListIds(userID); if (lid != null) { using (dbcontext = new ApplicationDbContext()) { try { subscribersList = new List <M_Subscriber>(); subscribersList = dbcontext.M_Subscribers.Where(l => l.ListID == lid && l.Unsubscribe == true).ToList(); } catch (SqlException ex) { obj = new M_CustomException((int)ErorrTypes.SqlExceptions, ex.Message, ex.StackTrace, ErorrTypes.SqlExceptions.ToString(), Utlities.GetURL(), ex.LineNumber); obj.LogException(); throw obj; } catch (Exception ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } } } return(subscribersList); }
/// <summary> /// Delete perticular subscriber from database /// </summary> /// <param name="sid"></param> public void Delete(int?sid) { if (sid != null) { using (dbcontext = new ApplicationDbContext()) { var ls = dbcontext.ListSusbscribers.SingleOrDefault(l => l.SubscribersID == sid); subscriber = dbcontext.M_Subscribers.Find(sid); int?lid = subscriber.ListID; if (ls != null) { try { dbcontext.ListSusbscribers.Remove(ls); } catch (SqlException ex) { obj = new M_CustomException((int)ErorrTypes.SqlExceptions, "Problem in saving data", ex.StackTrace, ErorrTypes.SqlExceptions.ToString(), Utlities.GetURL(), ex.LineNumber); obj.LogException(); throw obj; } catch (Exception ex) { obj = new M_CustomException((int)ErorrTypes.others, "Some problem occured while processing request", ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } } try { dbcontext.M_Subscribers.Remove(subscriber); dbcontext.SaveChanges(); } catch (SqlException ex) { obj = new M_CustomException((int)ErorrTypes.SqlExceptions, "Problem in saving data", ex.StackTrace, ErorrTypes.SqlExceptions.ToString(), Utlities.GetURL(), ex.LineNumber); obj.LogException(); throw obj; } catch (Exception ex) { obj = new M_CustomException((int)ErorrTypes.others, "Some problem occured while processing request", ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } } } }
/// <summary> /// update subscribers information to database /// </summary> public void Update() { using (dbcontext = new ApplicationDbContext()) { try { dbcontext.Entry(this).State = System.Data.Entity.EntityState.Modified; dbcontext.SaveChanges(); } catch (SqlException ex) { obj = new M_CustomException((int)ErorrTypes.SqlExceptions, "Problem in saving data", ex.StackTrace, ErorrTypes.SqlExceptions.ToString(), Utlities.GetURL(), ex.LineNumber); obj.LogException(); throw obj; } catch (Exception ex) { obj = new M_CustomException((int)ErorrTypes.others, "Some problem occured while processing request", ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } } }
/// <summary> /// get collection of subscribers for perticular list /// </summary> /// <param name="listId">if listid is null display all subscribers for user and if listid is not null display subscriber /// for perticular list</param> /// <param name="userID"></param> /// <returns></returns> public List <M_Subscriber> GetsubscribersToList(int?listId, string userID) { if (listId != null) { using (dbcontext = new ApplicationDbContext()) { try { subscribersList = dbcontext.M_Lists.Find(listId).Subscribers.Where(s => s.Unsubscribe == false).ToList(); } catch (SqlException ex) { obj = new M_CustomException((int)ErorrTypes.SqlExceptions, ex.InnerException.Message, ex.StackTrace, ErorrTypes.SqlExceptions.ToString(), Utlities.GetURL(), ex.LineNumber); obj.LogException(); throw obj; } catch (Exception ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.InnerException.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } } return(subscribersList); } return(subscribersList); //else { // subscribersList = GetAllSubscribers(userID); // return subscribersList; //} }
public ActionResult editCampaign(int?id) { userID = GetUser(); UpdateCampModel campaign = new UpdateCampModel(); try { // campaign.Campaigns = dbContext.M_Campaigns.Find(id); campaign.Campaigns = M_Campaigns.FindCampaign(id); //campaign.Subscribers = dbContext.NewLists.Find(campaign.Campaigns.ListId).Subscribers.ToList(); campaign.Subscribers = M_Campaigns.subscribersToCampaign(campaign.Campaigns.ListId); //WebUtility.HtmlDecode(campaign.Campaigns.EmailContent); ViewBag.campTypes = new SelectList(S_CampaignTypes.GetCampTypes(), "CTId", "Name"); ViewBag.List = new SelectList(M_List.GetLists(userID), "ListID", "ListName"); TempData["emailContent"] = campaign.Campaigns.EmailContent; return(View("UpdateCamp", campaign)); } catch (M_CustomException ex) { if (ex.ErrorCode == 100) { ModelState.AddModelError("error", ex.message); return(RedirectToAction("Campaign")); } else if (ex.ErrorCode == 101) { ModelState.AddModelError("Error", "logical exception"); return(RedirectToAction("Campaign")); } } catch (InvalidOperationException ex) { M_CustomException obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); ModelState.AddModelError("Error", "Invalid operation"); return(RedirectToAction("Campaign")); } return(RedirectToAction("Campaign")); }
/// <summary> /// if listid is not null get subscribers by listid /// </summary> /// <param name="listID">is not null</param> /// <returns></returns> public List <M_Subscriber> GetSubscribersbyListID(int?listID) { using (dbcontext = new ApplicationDbContext()) { try { subscribersList = dbcontext.M_Lists.Find(listID).Subscribers.Where(s => s.Unsubscribe == false).ToList(); } catch (SqlException ex) { obj = new M_CustomException((int)ErorrTypes.SqlExceptions, ex.Message, ex.StackTrace, ErorrTypes.SqlExceptions.ToString(), Utlities.GetURL(), ex.LineNumber); obj.LogException(); throw obj; } catch (Exception ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } } return(subscribersList); }
/// <summary> /// Function to save New List object,and add list id into userslist table /// </summary> /// <param name="obj">New List type object</param> /// <param name="userID">User for which list is created</param> /// <returns></returns> public string SaveList(string userID) { if (CheckListExist(this.ListName, userID) == false) { user.UsersID = userID; try { using (dbcontext = new ApplicationDbContext()) { //begin transaction using (var trans = dbcontext.Database.BeginTransaction()) { try { this.CreatedDate = DateTime.Now; dbcontext.M_Lists.Add(this); dbcontext.SaveChanges(); user.ListID = this.ListID; dbcontext.UsersList.Add(user); dbcontext.SaveChanges(); trans.Commit(); } catch (SqlException ex) { trans.Rollback(); obj = new M_CustomException((int)ErorrTypes.SqlExceptions, ex.Message, ex.StackTrace, ErorrTypes.SqlExceptions.ToString(), userID, Utlities.GetURL(), ex.LineNumber); obj.LogException(); throw obj; } catch (Exception ex) { trans.Rollback(); obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), userID, Utlities.GetURL()); obj.LogException(); throw obj; } } } return("Saved"); } catch (Exception ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), userID, Utlities.GetURL()); obj.LogException(); throw obj; } } //if listname already exist else { return("List name already exist"); } }
/// <summary> /// Function to check if list name is already exist /// </summary> /// <param name="listName">user want to create list by this name</param> /// <param name="UserID">User for which list is created</param> /// <returns>true if listname is already exist and false if listname does not exist</returns> public bool CheckListExist(string listName, string userID) { listIds = new List <int?>(); // listIds = GetListIds(userID); bool res = false; using (dbcontext = new ApplicationDbContext()) { try { var listdata = from list in dbcontext.M_Lists join users in dbcontext.UsersList on list.ListID equals users.ListID where users.UsersID == userID select new { list.ListName }; //foreach (var item in listIds) //{ // ListNames.Add(dbcontext.NewLists.Where(l => l.ListID == item).Select(l => l.ListName).FirstOrDefault()); //} if (listdata != null) { res = listdata.Any(l => l.ListName == listName); } } catch (SqlException ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL(), ex.LineNumber); obj.LogException(); throw obj; } catch (Exception ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } } // return ListNames.Any(l => l == listName); return(res); }
/// <summary> /// Get list ids collection for perticular user /// </summary> /// <param name="userID"></param> /// <returns>listids collection</returns> public static List <int?> GetListIds(string userID) { using (dbcontext = new ApplicationDbContext()) { try { listIds = new List <int?>(); listIds = dbcontext.UsersList.Where(u => u.UsersID == userID).Select(l => l.ListID).ToList(); return(listIds); } catch (SqlException ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL(), ex.LineNumber); obj.LogException(); throw obj; } catch (Exception ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } } }
/// <summary> /// Imports CSV data and saves to database /// </summary> /// <param name="UploadFile"></param> /// <param name="model"></param> public void ImportCSV(HttpPostedFileBase UploadFile, SubscribersViewModel model) { subscriber = new M_Subscriber(); string filename = System.IO.Path.GetFileNameWithoutExtension(UploadFile.FileName); if (UploadFile.FileName.EndsWith(".csv")) { using (dbcontext = new ApplicationDbContext()) { Stream stream = UploadFile.InputStream; string thisFile = filename + "_" + model.ListID + ".csv"; // var path = System.IO.Path.Combine(Server.MapPath("~/CSVFiles"), thisFile); DataTable csvTable = new DataTable(); using (CsvReader csvReader = new CsvReader(new StreamReader(stream), true)) { csvTable.Load(csvReader); } model.dataTable = csvTable; //read column headers var columnHeaders = (from DataColumn dc in model.dataTable.Columns select dc.ColumnName).ToArray(); //save list to database if (model.dataTable.Rows.Count > 0) { //UploadFile.SaveAs(path); for (int i = 0; i < model.dataTable.Rows.Count; i++) { try { List <string> sub = new List <string>(); sub = dbcontext.M_Subscribers.Where(l => l.ListID == model.ListID).Select(m => m.EmailAddress).ToList(); bool ispresent = false; try { ispresent = sub.Any(s => s == model.dataTable.Rows[i]["EmailAddress"].ToString()); } catch (ArgumentException ex) { //ModelState.AddModelError("Fileerr", "Please see sample file format"); //return View(); } if (ispresent == false) { ListSusbscriber lSub = new ListSusbscriber(); lSub.ListID = model.ListID; using (var trans = dbcontext.Database.BeginTransaction()) { // ObjectParameter objParam = new ObjectParameter("ID", typeof(int)); try { subscriber.ListID = Convert.ToInt32(model.ListID); subscriber.FirstName = model.dataTable.Rows[i]["FirstName"].ToString(); subscriber.LastName = model.dataTable.Rows[i]["LastName"].ToString(); subscriber.EmailAddress = model.dataTable.Rows[i]["EmailAddress"].ToString(); subscriber.AlternateEmailAddress = model.dataTable.Rows[i]["AlternateEmailAddress"].ToString(); subscriber.Address = model.dataTable.Rows[i]["Address"].ToString(); subscriber.Country = model.dataTable.Rows[i]["Country"].ToString(); subscriber.City = model.dataTable.Rows[i]["City"].ToString(); subscriber.AddedDate = DateTime.Now; // subscriber.StatusID = 3; dbcontext.M_Subscribers.Add(subscriber); dbcontext.SaveChanges(); //dbcontext.ImportSubscribers(Convert.ToInt32(model.ListID), model.dataTable.Rows[i]["FirstName"].ToString(), // model.dataTable.Rows[i]["LastName"].ToString(), model.dataTable.Rows[i]["EmailAddress"].ToString(), model.dataTable.Rows[i]["AlternateEmailAddress"].ToString(), // model.dataTable.Rows[i]["Address"].ToString(), model.dataTable.Rows[i]["Country"].ToString(), model.dataTable.Rows[i]["City"].ToString(), // DateTime.Now.ToString(), objParam); //lSub.SubscribersID = Convert.ToInt32(objParam.Value); // lSub.SubscribersID = (int?)((SqlParameter)param[9]).Value; lSub.SubscribersID = subscriber.SubscriberID; dbcontext.ListSusbscribers.Add(lSub); dbcontext.SaveChanges(); trans.Commit(); } catch (SqlException) { trans.Rollback(); } catch (Exception ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } } } else { // ModelState.AddModelError("present", "Some subscribers already present"); } } catch (ArgumentException ex) { //ModelState.AddModelError("Fileerr", "Please see sample file format"); //return View(); } catch (Exception ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } } } } } }
public override void _Process(float delta) { lookDir = GetGlobalMousePosition() - GlobalPosition; RotationDegrees = Utlities.LookAtMouse(GetGlobalMousePosition(), GlobalPosition); Shoot(lookDir, delta); }
/// <summary> /// gets all lists /// </summary> /// <returns></returns> public static List <M_List> GetLists() { List <M_List> lists1 = new List <M_List>(); using (dbcontext = new ApplicationDbContext()) { try { lists1 = dbcontext.M_Lists.ToList(); } catch (SqlException ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL(), ex.LineNumber); obj.LogException(); throw obj; } catch (Exception ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } } return(lists1); }