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));
}
