void Start() { AddToScore = 0; respawnSet = false; MaxUpgradeTimer = Random.Range(8.0f, 15.0f); MaxRespawnTimer = Random.Range(15f, 60.0f); Pool = GameObject.Find("GameUI").GetComponent <ProgressbarBehaviour>(); CitiesAlive = GameObject.Find("City Master").GetComponent <CityMaster>(); CityRenderer = GetComponentInChildren <SpriteRenderer>(); CityCollider = GetComponentInChildren <CircleCollider2D>(); CurrentLevel = 1; //staden börjar på lvl 1 UpgradeTimer = MaxUpgradeTimer; //sätter alla timers + health till sina max values CurrentHealth = MaxHealth; RespawnTimer = MaxRespawnTimer; Alive = transform.GetChild(0); //hämtar komponenterna från de två child objekten Dead = transform.GetChild(1); CityAnimator = GetComponentInChildren <Animator>(); Dead.gameObject.SetActive(false); //sätter den döda till false dmgDealer = GetComponent <DamageDealer>(); //hämtar komponenterna från damagedealer scriptet CityRenderer.sprite = DifferentCities[CurrentLevel - 1]; ChooseType(); //callar funktionen ChooseType citySoundPlayer.clip = citySoundClips[0]; citySoundPlayer.Play(); Instantiate(rippleEffect, transform); }
public DataBaseResultSet SaveCityMaster <T>(T objData) where T : class, IModel, new() { CityMaster obj = objData as CityMaster; string sQuery = "sprocCityMasterInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("CityCode", "CityCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.CityCode)); list.Add(SqlConnManager.GetConnParameters("ICode", "ICode", 13, GenericDataType.String, ParameterDirection.Input, obj.ICode)); list.Add(SqlConnManager.GetConnParameters("CityName", "CityName", 50, GenericDataType.String, ParameterDirection.Input, obj.CityName)); list.Add(SqlConnManager.GetConnParameters("InState", "InState", 3, GenericDataType.String, ParameterDirection.Input, obj.InState)); list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser)); list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime)); list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser)); list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime)); list.Add(SqlConnManager.GetConnParameters("LCode", "LCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.LCode)); list.Add(SqlConnManager.GetConnParameters("DLock", "DLock", 3, GenericDataType.String, ParameterDirection.Input, obj.DLock)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
protected void BtnUpdate_Click(object sender, EventArgs e) { int UpdateRow = 0; try { if (ViewState["EditID"] != null) { Entity_PR.CityId = Convert.ToInt32(ViewState["EditID"]); } Entity_PR.City = TxtDepartment.Text.Trim(); Entity_PR.LoginId = Convert.ToInt32(Session["UserId"]); Entity_PR.LoginDate = DateTime.Now; UpdateRow = Obj_PR.UpdateRecord(ref Entity_PR, out StrError); if (UpdateRow != 0) { obj_Comm.ShowPopUpMsg("Record Updated Successfully", this.Page); MakeEmptyForm(); Entity_PR = null; obj_Comm = null; } } catch (Exception ex) { throw new Exception(ex.Message); } }
protected void BtnSave_Click(object sender, EventArgs e) { int InsertRow = 0; try { DS = Obj_PR.ChkDuplicate(TxtDepartment.Text.Trim(), out StrError); if (DS.Tables[0].Rows.Count > 0) { obj_Comm.ShowPopUpMsg("City Already Exist..!", this.Page); TxtDepartment.Focus(); } else { Entity_PR.City = TxtDepartment.Text.Trim(); Entity_PR.LoginId = Convert.ToInt32(Session["UserId"]); Entity_PR.LoginDate = DateTime.Now; InsertRow = Obj_PR.InsertRecord(ref Entity_PR, out StrError); if (InsertRow != 0) { obj_Comm.ShowPopUpMsg("Record Saved Successfully", this.Page); MakeEmptyForm(); Entity_PR = null; obj_Comm = null; } } } catch (Exception ex) { throw new Exception(ex.Message); } }
public Int64 Update(CityMaster objcompany) { Int64 result = 0; try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "City_Update"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = ConnectionString; SqlParameter param = new SqlParameter(); param.ParameterName = "@id"; param.Value = objcompany.id; param.SqlDbType = SqlDbType.BigInt; param.Direction = ParameterDirection.InputOutput; cmd.Parameters.Add(param); cmd.Parameters.AddWithValue("@cityname", objcompany.cityname); ConnectionString.Open(); cmd.ExecuteNonQuery(); result = Convert.ToInt64(param.Value); } catch (Exception ex) { ErrHandler.writeError(ex.Message, ex.StackTrace); return(result); } finally { ConnectionString.Close(); } return(result); }
protected void BtnDelete_Click(object sender, EventArgs e) { try { int DeleteId = 0; if (ViewState["EditID"] != null) { DeleteId = Convert.ToInt32(ViewState["EditID"]); } if (DeleteId != 0) { Entity_PR.CityId = DeleteId; Entity_PR.LoginId = Convert.ToInt32(Session["UserID"]); Entity_PR.LoginDate = DateTime.Now; int iDelete = Obj_PR.DeleteRecord(ref Entity_PR, out StrError); if (iDelete != 0) { obj_Comm.ShowPopUpMsg("Record Deleted Successfully..!", this.Page); MakeEmptyForm(); } } Entity_PR = null; obj_Comm = null; } catch (Exception ex) { throw new Exception(ex.Message); } }
private void Save() { if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Add)) { return; } bool bActionCompleted = false; CityDTO oCityData = new CityDTO(); oCityData.CityCode = Convert.ToString(txtCityCode.Text); oCityData.CityName = Convert.ToString(txtCityName.Text); CityMaster oCityMaster = new CityMaster(); bActionCompleted = oCityMaster.Insert(oCityData); if (bActionCompleted == true) { base.DisplayAlert("The record has been inserted successfully"); txtCityName.Text = ""; txtCityCode.Text = ""; } else { lblStatus.Text = "Error Occured while insertion: Please refer to the error log."; } }
protected void dgCitys_SelectedIndexChanged(object sender, EventArgs e) { int iCityID = Convert.ToInt32(dgCitys.DataKeys[dgCitys.SelectedIndex].ToString()); hfId.Value = iCityID.ToString(); //SessionHandler"CityID"] = iCityID; CityMaster oCityMaster = new CityMaster(); CityDTO[] oCityData = oCityMaster.GetData(iCityID); if (oCityData.Length > 0) { txtCityCode.Text = oCityData[0].CityCode.ToString(); txtCityName.Text = oCityData[0].CityName.ToString(); } oCityMaster = null; oCityData = null; //btnAddNew.Enabled = false; //btnCancel.Enabled = true; btnCancel.Visible = true; btnDelete.Enabled = true; btnEdit.Text = "Update"; //btnSave.Enabled = false; lblStatus.Text = ""; }
public async Task AddCityMaster(CityMaster prodData) { var maxId = await WithConnection(async c => { return(await c.QueryAsync <int>("SELECT max(CityIndex) FROM CityMaster")); }); //Setting Primary Key if (maxId.SingleOrDefault() == 0) { prodData.CityIndex = 1; } else { prodData.CityIndex = maxId.SingleOrDefault() + 1; } //Filling Other Records like User Id, Creation & Update Date prodData.CreateUserIndex = 1; //Later Logged in User prodData.UpdateUserIndex = 1; //Later Logged in User prodData.CreateDateTime = DateTime.Now; prodData.UpdateDateTime = DateTime.Now; await WithConnection(async c => { return(await c.QueryAsync <int>(SQLConstants.InsertCityMaster, prodData)); }); }
public List <CityMaster> City_Update(CityMaster input) { List <CityMaster> listCity = new List <CityMaster>(); using (MySqlDataReader reader = ExecuteDataReader("City_InsertUpdateDelete", CreateParameter("CityId_", MySqlDbType.Int32, input.CityId), CreateParameter("DistrictId_", MySqlDbType.Int32, input.DistrictId), CreateParameter("CityName_", MySqlDbType.VarChar, input.CityName), CreateParameter("Type_", MySqlDbType.Int32, 2))) { while (reader.Read()) { CityMaster obj = new CityMaster(); obj.DistrictId = Convert.ToInt32(reader["DistrictId"]); obj.DistrictName = reader["DistrictName"].ToString(); //obj.StateName = reader["StateName"].ToString(); //obj.CountryName = reader["CountryName"].ToString(); obj.CityId = Convert.ToInt32(reader["CityId"]); obj.CityName = reader["CityName"].ToString(); obj.IsActive = Convert.ToBoolean(reader["IsActive"]); listCity.Add(obj); } } return(listCity); }
public bool Update([FromBody] CityMaster _oCityMaster) { try { int output; using (var context = new DB001Core()) { var input = context.CityMasters .Where(w => w.CityID == _oCityMaster.CityID) .FirstOrDefault(); input.CityName = _oCityMaster.CityName; output = context.SaveChanges(); } return(Convert.ToBoolean(output)); } catch (Exception ex) { throw; } finally { context = null; } }
public HttpResponseMessage UpdateCityName(string name, [FromBody] CityMaster cityMaster) { try { using (ApartmentsEntities entities = new ApartmentsEntities()) { var result = entities.CityMasters.FirstOrDefault(x => x.CityName == name); if (result != null) { result.CityName = cityMaster.CityName; result.CityState = cityMaster.CityState; result.CityId = cityMaster.CityId; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "Updated the city " + name + "to " + cityMaster.CityName)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "No city found with name : " + name)); } } }catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error Occured!")); } }
public ActionResult DeleteConfirmed(int id) { CityMaster cityMaster = db.CityMasters.Find(id); db.CityMasters.Remove(cityMaster); db.SaveChanges(); return(RedirectToAction("Index")); }
public void GetListCityMaster <T>(T objFilter, ref List <T> listData) where T : class, IModel, new() { string sQuery = "GetListCityMaster"; CityMaster objData = objFilter as CityMaster; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("CityCode", "CityCode", 8, GenericDataType.Long, ParameterDirection.Input, objData.CityCode)); SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillCityMasterDataFromReader, ref listData); }
public void SetRespawnTime() { if (Dead.gameObject.activeSelf == true && respawnSet == false) { RespawnTimer = CityMaster.getRespawnTime(); UpgradeTimer = CityMaster.getUpgradeTimer(); respawnSet = true; } }
public void BindCity(Int64 Id) { CityMaster objCityMaster = (new cls_CityMaster_b().SelectById(Id)); if (objCityMaster != null) { txtcityname.Text = objCityMaster.cityname; } }
public ActionResult DeleteConfirmed(int id) { CityMaster citymaster = db.CityMasters.Find(id); db.CityMasters.Remove(citymaster); db.SaveChanges(); TempData["SuccessMsg"] = "You have successfully Deleted City."; return(RedirectToAction("Index")); }
public async Task <ActionResult> DeleteConfirmed(int id) { CityMaster cityMaster = await db.CityMasters.FindAsync(id); db.CityMasters.Remove(cityMaster); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <IHttpActionResult> Create(CityMaster prodData) { if (prodData != null) { await CityMasterDA.AddCityMaster(prodData); return(Ok()); } return(BadRequest("Request cannot be NULL")); }
public ActionResult Edit(CityMaster citymaster) { if (ModelState.IsValid) { db.Entry(citymaster).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(citymaster)); }
public ActionResult Edit([Bind(Include = "Id,City,StateId,IsDeleted,CustomerId")] CityMaster cityMaster) { if (ModelState.IsValid) { db.Entry(cityMaster).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cityMaster)); }
// // GET: /CityMaster/Details/5 public ActionResult Details(int id = 0) { CityMaster citymaster = db.CityMasters.Find(id); if (citymaster == null) { return(HttpNotFound()); } return(View(citymaster)); }
private void FillCityMasterDataFromReader <T>(DbDataReader DbReader, ref List <T> listData) where T : class, IModel, new() { while (DbReader.Read()) { T obj = new T(); CityMaster objData = obj as CityMaster; obj.FillDataFromDB(DbReader); listData.Add(obj); } }
public ActionResult Edit([Bind(Include = "CityId,CityName,RefStateId")] CityMaster cityMaster) { if (ModelState.IsValid) { db.Entry(cityMaster).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.RefStateId = new SelectList(db.StateMasters, "StateId", "StateName", cityMaster.RefStateId); return(View(cityMaster)); }
public List <CityMaster> Get(QueryBO objQuery) { SqlDataReader reader = null; SqlConnection con = null; List <CityMaster> lstCity = null; SqlCommand objcmd = null; CityMaster objCity = null; try { lstCity = new List <CityMaster>(); using (con = DBconnection.ConnectToDB()) { objcmd = new SqlCommand(); objcmd.Connection = con; objcmd.CommandType = CommandType.StoredProcedure; objcmd.CommandText = "STP_SelectCityMaster"; objcmd.Parameters.Add(new SqlParameter("@PageNumber", objQuery.PageNumber)); objcmd.Parameters.Add(new SqlParameter("@PageSize", objQuery.PageSize)); objcmd.Parameters.Add(new SqlParameter("@Filter", objQuery.Filter)); objcmd.Parameters.Add(new SqlParameter("@Sort", objQuery.Sort)); objcmd.Parameters.Add(new SqlParameter("@TotalRecords", SqlDbType.Int)).Direction = ParameterDirection.Output; reader = objcmd.ExecuteReader(); if (reader != null && reader.HasRows) { while (reader.Read()) { objCity = new CityMaster(); objCity.CityID = Convert.ToInt64(reader["CityID"]); objCity.StateID = Convert.ToInt32(reader["StateID"]); objCity.CityName = Convert.ToString("" + reader["CityName"]); objCity.CountryID = Convert.ToInt32(reader["CountryID"]); objCity.Status = Convert.ToInt16("" + reader["Status"]); objCity.Remark = Convert.ToString("" + reader["Remark"]); objCity.strStatus = Convert.ToString("" + reader["strStatus"]); lstCity.Add(objCity); } } } objQuery.TotalRecords = Convert.ToInt32(objcmd.Parameters["@TotalRecords"].Value); } catch (Exception ex) { throw ex; } finally { reader.Dispose(); objcmd = null; con = null; } return(lstCity); }
public ActionResult Create(CityMaster citymaster) { if (ModelState.IsValid) { db.CityMasters.Add(citymaster); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(citymaster)); }
public async Task <ActionResult> Edit([Bind(Include = "ID,Name,StateID")] CityMaster cityMaster) { if (ModelState.IsValid) { db.Entry(cityMaster).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(cityMaster)); }
public ActionResult Create([Bind(Include = "Id,City,StateId,IsDeleted,CustomerId")] CityMaster cityMaster) { if (ModelState.IsValid) { db.CityMasters.Add(cityMaster); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cityMaster)); }
public static CityViewModel Detach(CityMaster cityMaster) { CityViewModel cityViewModel = new CityViewModel(); cityViewModel.CityId = cityMaster.CityId; cityViewModel.CityName = cityMaster.CityName; cityViewModel.CityShortName = cityMaster.CityShortName; cityViewModel.IsActive = cityMaster.IsActive; return(cityViewModel); }
public ActionResult Create([Bind(Include = "CityId,CityName,RefStateId")] CityMaster cityMaster) { if (ModelState.IsValid) { db.CityMasters.Add(cityMaster); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.RefStateId = new SelectList(db.StateMasters, "StateId", "StateName", cityMaster.RefStateId); return(View(cityMaster)); }