private static void ModelTest()
{
ModelManager modelManager = new ModelManager(new EfModelDal());
//Console.WriteLine(modelManager.Get(5).ModelName);
modelManager.Add(new Model {
BrandId = 6, ModelName = "Panamera 4"
});
foreach (var model in modelManager.GetAll().Data)
{
Console.WriteLine(model.ModelName);
}
}
private static void ModelAdd(ModelManager modelManager)
{
Console.WriteLine("---------- Model Kayıt Ekleme Ekranı ----------");
Console.WriteLine("Marka Id: ");
int brandId = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Model Adı: ");
string modelName = Console.ReadLine();
Model addModel = new Model {
BrandId = brandId, ModelName = modelName
};
var result = modelManager.Add(addModel);
SuccessModel(modelManager, result);
}
public int AddToModel()
{
Console.ForegroundColor = ConsoleColor.Cyan;
Console.WriteLine(">>> Yukarıdaki Tabloları kullanarak YENİ ARAÇ EKLEME işlemini gerçekleştirebilirsiniz <<<");
Console.ResetColor();
Console.Write("Marka ID : ");
_brandId = Convert.ToInt32(Console.ReadLine());
Console.Write("Model Adı : ");
_modelName = Console.ReadLine();
Console.Write("Model Yılı : ");
_modelYear = Convert.ToInt32(Console.ReadLine());
Console.Write("Renk ID : ");
_colorId = Convert.ToInt32(Console.ReadLine());
Console.Write("Kasa Tip ID : ");
_bodyTypeId = short.Parse(Console.ReadLine());
Console.Write("Yakıt Tip ID : ");
_fuelTypeId = Convert.ToInt16(Console.ReadLine());
Console.Write("Vites Tip ID : ");
_gearTypeId = short.Parse(Console.ReadLine());
Model model = new Model
{
BrandId = _brandId,
ModelName = _modelName,
ModelYear = _modelYear,
ColorId = _colorId,
BodyTypeId = _bodyTypeId,
FuelTypeId = _fuelTypeId,
GearTypeId = _gearTypeId
};
modelManager.Add(model);
var result = modelManager.GetAll().Data.OrderByDescending(c => c.Id).FirstOrDefault();
return(result.Id);
}
private static void ModelTest()
{
ModelManager modelManager = new ModelManager(new EfModelDal());
modelManager.Add(new Model {
Id = 1, BrandId = 1, Name = "A6"
});
modelManager.Add(new Model {
Id = 2, BrandId = 2, Name = "A 200"
});
modelManager.Add(new Model {
Id = 3, BrandId = 5, Name = "Egea"
});
modelManager.Add(new Model {
Id = 4, BrandId = 5, Name = "Linea"
});
modelManager.Add(new Model {
Id = 5, BrandId = 7, Name = "Megane"
});
modelManager.Add(new Model {
Id = 6, BrandId = 7, Name = "Clio"
});
modelManager.Add(new Model {
Id = 7, BrandId = 2, Name = "A7"
});
modelManager.Add(new Model {
Id = 7, BrandId = 3, Name = "i10"
}); //BrandId=3 mevcut olmadığından hata mesajı verecektir
Console.WriteLine("\n--- Ekleme sonrası model listesi ---\n");
foreach (var model in modelManager.GetAll().Data)
{
Console.WriteLine("id: {0} Model: {1}", model.Id, model.Name);
}
var result = modelManager.GetById(2).Data;
result.Name = "A200";
modelManager.Update(result);
var result2 = modelManager.GetById(3).Data;
result2.BrandId = 1;
modelManager.Update(result2);
Console.WriteLine("\n--- Güncelleme sonrası model listesi ---\n");
foreach (var model in modelManager.GetAll().Data)
{
Console.WriteLine("id: {0} Model: {1}", model.Id, model.Name);
}
modelManager.Delete(modelManager.GetById(3).Data);
Console.WriteLine("\n--- Silme sonrası model listesi ---\n");
foreach (var model in modelManager.GetAll().Data)
{
Console.WriteLine("id: {0} Model: {1}", model.Id, model.Name);
}
Console.WriteLine("\n--- BrandId=7 olan model listesi ---\n");
foreach (var model in modelManager.GetModelsByBrandId(7).Data)
{
Console.WriteLine("id: {0} Model: {1}", model.Id, model.Name);
}
}
protected void Start()
{
ConsoleRedirector.Apply();
//var userObject = GameObject.Find("UserObject");
string databasePath = YemenCDB;
var databaseGameObject = Instantiate(DatabasePrefab);
Database = databaseGameObject.GetComponent <Database>();
Database.Path = databasePath;
modelManager = Database.ModelManager;
materialManager = Database.MaterialManager;
meshManager = Database.MeshManager;
var path = databasePath + "/GTModel/500_GTModelGeometry";
//var path = databasePath + "/Tiles";
var di = new DirectoryInfo(path);
WalkDirectoryTree(di, LoadFLT);
int count = gameObjects.Count;
if (count >= 1)
{
int width = (int)Mathf.Sqrt(count);
int length = count / width;
int remainder = count % width;
int separation = 100;
if (randomPlacement)
{
foreach (var gameObject in gameObjects)
{
gameObject.transform.position = new Vector3(Random.Range(-width * separation / 2, width * separation / 2),
Random.Range(-separation / 2f, separation / 2f),
Random.Range(-length * separation / 2, length * separation / 2));
}
}
else
{
for (int w = 0; w < width; ++w)
{
for (int h = 0; h < length; ++h)
{
gameObjects[w * length + h].transform.position = new Vector3(w * separation, 0f, h * separation);
}
}
for (int r = 0; r < remainder; ++r)
{
gameObjects[width * length + r].transform.position = new Vector3(width * separation, 0f, r * separation);
}
}
}
foreach (var gameObject in gameObjects)
{
modelManager.Add(gameObject.GetComponent <Model>());
}
//userObject.transform.position = new Vector3(-100f, 100f, -100f);
//userObject.transform.rotation = Quaternion.LookRotation(new Vector3(1f, -1f, 1f), Vector3.up);
}
static void InitializeDb()
{
CarManager carManager = new CarManager(new EfCarDal());
BrandManager brandManager = new BrandManager(new EfBrandDal());
ColorManager colorManager = new ColorManager(new EfColorDal());
ModelManager modelManager = new ModelManager(new EfModelDal());
UserManager userManager = new UserManager(new EfUserDal());
CustomerManager customerManager = new CustomerManager(new EfCustomerDal());
RentalManager rentalManager = new RentalManager(new EfRentalDal());
userManager.Add(new User {
FirstName = "İbrahim", LastName = "Dülger", Email = "*****@*****.**", Password = "******"
});
userManager.Add(new User {
FirstName = "Kerim", LastName = "Abdul Jabbar", Email = "*****@*****.**", Password = "******"
});
userManager.Add(new User {
FirstName = "Muhammed Ali", LastName = "Clay", Email = "*****@*****.**", Password = "******"
});
userManager.Add(new User {
FirstName = "Mahmut", LastName = "Öztürk", Email = "*****@*****.**", Password = "******"
});
userManager.Add(new User {
FirstName = "Ahmet", LastName = "Yılmaz", Email = "*****@*****.**", Password = "******"
});
userManager.Add(new User {
FirstName = "Burcu", LastName = "Kaya", Email = "*****@*****.**", Password = "******"
});
customerManager.Add(new Customer {
UserId = 1, CompanyName = "Dülger Holding"
});
customerManager.Add(new Customer {
UserId = 2, CompanyName = "Kerimsport"
});
customerManager.Add(new Customer {
UserId = 3, CompanyName = "Ali Boxing"
});
customerManager.Add(new Customer {
UserId = 4, CompanyName = "Öztürk Yapı"
});
customerManager.Add(new Customer {
UserId = 5, CompanyName = "Ahmet Holding"
});
customerManager.Add(new Customer {
UserId = 6, CompanyName = "Fly Labs"
});
rentalManager.Add(new Rental {
CarId = 1, CustomerId = 1, RentDate = new DateTime(2021, 02, 10), ReturnDate = new DateTime(2021, 02, 15)
});
rentalManager.Add(new Rental {
CarId = 2, CustomerId = 2, RentDate = new DateTime(2021, 02, 10), ReturnDate = new DateTime(2021, 02, 15)
});
rentalManager.Add(new Rental {
CarId = 3, CustomerId = 3, RentDate = new DateTime(2021, 02, 10), ReturnDate = new DateTime(2021, 02, 15)
});
rentalManager.Add(new Rental {
CarId = 4, CustomerId = 4, RentDate = new DateTime(2021, 02, 10), ReturnDate = new DateTime(2021, 02, 15)
});
brandManager.Add(new Brand {
BrandName = "Ford"
}); // 1
brandManager.Add(new Brand {
BrandName = "Fiat"
}); // 2
brandManager.Add(new Brand {
BrandName = "Mercedes"
}); // 3
modelManager.Add(new Model {
BrandId = 1, Name = "Focus"
});
modelManager.Add(new Model {
BrandId = 1, Name = "Fiesta"
});
modelManager.Add(new Model {
BrandId = 1, Name = "Mondeo"
});
modelManager.Add(new Model {
BrandId = 2, Name = "Egea"
});
modelManager.Add(new Model {
BrandId = 2, Name = "Linea"
});
modelManager.Add(new Model {
BrandId = 2, Name = "Fiorino"
});
modelManager.Add(new Model {
BrandId = 3, Name = "E250"
});
modelManager.Add(new Model {
BrandId = 3, Name = "A180"
});
modelManager.Add(new Model {
BrandId = 3, Name = "G500"
});
colorManager.Add(new Color {
ColorName = "Siyah"
}); // 1
colorManager.Add(new Color {
ColorName = "Beyaz"
}); // 2
colorManager.Add(new Color {
ColorName = "Kırmızı"
}); // 3
colorManager.Add(new Color {
ColorName = "Mavi"
}); // 4
carManager.Add(new Car {
BrandId = 1, ModelId = 1, ColorId = 1, DailyPrice = 100, Description = "Sedan", ModelYear = 2019
});
carManager.Add(new Car {
BrandId = 1, ModelId = 2, ColorId = 2, DailyPrice = 120, Description = "Hatcback", ModelYear = 2020
});
carManager.Add(new Car {
BrandId = 1, ModelId = 3, ColorId = 3, DailyPrice = 150, Description = "Sedan", ModelYear = 2020
});
carManager.Add(new Car {
BrandId = 2, ModelId = 4, ColorId = 2, DailyPrice = 120, Description = "Sedan", ModelYear = 2019
});
carManager.Add(new Car {
BrandId = 2, ModelId = 5, ColorId = 3, DailyPrice = 100, Description = "Sedan", ModelYear = 2019
});
carManager.Add(new Car {
BrandId = 2, ModelId = 6, ColorId = 1, DailyPrice = 80, Description = "Panelvan", ModelYear = 2019
});
carManager.Add(new Car {
BrandId = 3, ModelId = 7, ColorId = 4, DailyPrice = 300, Description = "Premium Sedan", ModelYear = 2020
});
carManager.Add(new Car {
BrandId = 3, ModelId = 8, ColorId = 2, DailyPrice = 200, Description = "Hatchback", ModelYear = 2020
});
carManager.Add(new Car {
BrandId = 3, ModelId = 9, ColorId = 1, DailyPrice = 500, Description = "Premium 4x4", ModelYear = 2020
});
}
public void Add(Model.Model obj)
{
ModelManager.Add(obj);
}
protected void EBtnSubmit_Click(object sender, EventArgs e)
{
string text = this.TxtModelName.Text;
int modelTemplateId = DataConverter.CLng(this.DropModelTemplate.SelectedValue);
ModelInfo modelInfo = new ModelInfo();
modelInfo.ModelName = this.TxtModelName.Text;
modelInfo.Description = this.TxtDescription.Text;
modelInfo.ItemName = this.TxtItemName.Text;
modelInfo.ItemUnit = this.TxtItemUnit.Text;
modelInfo.ItemIcon = this.TxtItemIcon.Text;
modelInfo.TableName = "PE_U_" + this.TxtTableName.Text;
modelInfo.IsEshop = false;
modelInfo.IsCountHits = DataConverter.CBoolean(this.RadioIsCountHits.SelectedValue);
modelInfo.Disabled = DataConverter.CBoolean(this.RadioDisabled.SelectedValue);
modelInfo.DefaultTemplateFile = this.FileCTemplate.Text;
modelInfo.PrintTemplate = this.TscPrintTemplate.Text;
modelInfo.SearchTemplate = this.TscSearchTemplate.Text;
modelInfo.AdvanceSearchFormTemplate = this.TscAdvanceSearchFormTemplate.Text;
modelInfo.AdvanceSearchTemplate = this.TscAdvanceSearchTemplate.Text;
modelInfo.CommentManageTemplate = this.TscCommentManageTemplate.Text;
modelInfo.AddInfoFilePath = this.TxtAddInfoFilePath.Text.Trim();
modelInfo.ManageInfoFilePath = this.TxtManageInfoFilePath.Text.Trim();
modelInfo.PreviewInfoFilePath = this.TxtPreviewInfoFilePath.Text.Trim();
modelInfo.BatchInfoFilePath = this.TxtBatchInfoFilePath.Text.Trim();
modelInfo.EnableCharge = DataConverter.CBoolean(this.RadioEnableCharge.SelectedValue);
modelInfo.EnableSignIn = DataConverter.CBoolean(this.RadioEnableSignin.SelectedValue);
modelInfo.EnbaleVote = DataConverter.CBoolean(this.RadVote.SelectedValue);
modelInfo.ChargeTips = this.TxtModelChargeTips.Text.Trim();
modelInfo.MaxPerUser = DataConverter.CLng(this.TxtMaxPerUser.Text);
if (this.ViewState["action"].ToString() == "Add")
{
if (ModelManager.ModelNameExists(modelInfo.ModelName))
{
AdminPage.WriteErrMsg("<li>数据库中已经存在此模型名称！</li>");
}
else if (ModelManager.TableNameExists(modelInfo.TableName))
{
AdminPage.WriteErrMsg("<li>数据库中已经存在要创建的表名请返回换一个表名！</li>");
}
else if (ModelManager.Add(modelInfo, modelTemplateId))
{
base.Response.Write("<script type='text/javascript'>parent.frames[\"left\"].location.reload();</script>");
AdminPage.WriteSuccessMsg("<li>添加内容模型成功，并将模型的默认字段初始化！</li>", "ModelManage.aspx");
}
else
{
AdminPage.WriteErrMsg("<li>添加内容模型操作失败！</li>");
}
}
else
{
bool flag;
modelInfo.ModelId = DataConverter.CLng(this.HdnModelId.Value);
modelInfo.TableName = this.HdnTableName.Value;
if (text == this.HdnModelName.Value)
{
flag = false;
}
else
{
flag = ModelManager.ModelNameExists(text);
}
if (!flag)
{
if (ModelManager.Update(modelInfo))
{
base.Response.Write("<script type='text/javascript'>parent.frames[\"left\"].location.reload();</script>");
AdminPage.WriteSuccessMsg("<li>修改内容模型成功！</li>", "ModelManage.aspx");
}
else
{
AdminPage.WriteErrMsg("<li>修改内容模型操作失败！</li>");
}
}
else
{
AdminPage.WriteErrMsg("<li>数据库中已经存在此内容模型名称！</li>");
}
}
}
