public int editOrder()
{
string external = GlobFuncs.convertExtensionToString(this.extetions);
editExtOrder ext = new editExtOrder(this.externalOrderId, this.person.IdNumber, this.person.FullName, this.person.PhoneNumber, this.person.PhoneNumber, this.person.LiccensNumber, this.PickupBranch, this.ReturnBranch, this.PickupDate, this.ReturnDate, this.CarId, 18, external, this.CreditCard.number, this.CreditCard.month, this.CreditCard.year, this.CreditCard.digitNo, this.CreditCard.ownerId, this.notes);
string ApiAddress = GlobFuncs.GetApiAddress(this.Company, "editOrderBll");
string Json = JsonConvert.SerializeObject(ext);
string returnFlag = GetApi.PostApi(Json, ApiAddress);
if (returnFlag != 0.ToString())
{
string b = GlobFuncs.GetDetails(this.Company, this.CarId);
CarDetails carDetails = new CarDetails();
string[] arr = b.Split('#');
string str = arr[0].Substring(2, arr[0].Length - 3).Replace("\\", "");
carDetails = JsonConvert.DeserializeObject <CarDetails>(str);
string pickBr = GlobFuncs.GetBranchName(this.PickupBranch, this.Company);
string RetBr = GlobFuncs.GetBranchName(this.ReturnBranch, this.Company);
DataBase db = new DataBase();
string sql = "update OrderTable set creditCardId = '" + this.CreditCard.id + "' where RentId = " + this.orderId + ";delete from ExtensInOrder where OrderId = " + this.orderId;
db.ExecuteNonQuery(sql);
if (this.extetions.Count > 0)
{
sql = "insert into ExtensInOrder (OrderId,ExtentionId,description,price) values";
foreach (Extention extention in this.extetions)
{
sql += "(" + int.Parse(db.GetMaxId("OrderTable", "RentId").ToString()) + "," + extention.id + ",'" + extention.description + "'," + extention.Price + "),";
}
sql = sql.Substring(0, sql.Length - 1);
db.ExecuteNonQuery(sql);
}
return(1);
}
return(0);
}
public string GetDetails()
{
string ObjId = JsonConvert.SerializeObject(this.id);
string Address = GlobFuncs.GetApiAddress(int.Parse(this.Company), "CarDetail");
string ret = GetApi.PostApi(ObjId, Address);
return(ret);
}
public static string GetDetails(int company, int CarId)
{
string Address = "";
if (company == 1)
{
Address = "https://localhost:44361/api/CarDetail";
}
else
{
Address = GetApiAddress(company, "CarDetail");
}
string ret = GetApi.PostApi(CarId.ToString(), Address);
return(ret);
}
public List <string> CreateExtOrder()
{
string external = GlobFuncs.convertExtensionToString(this.extetions);
ExtOrder ext = new ExtOrder(this.person.IdNumber, this.person.FullName, this.person.PhoneNumber, this.person.PhoneNumber, this.person.LiccensNumber, this.PickupBranch, this.ReturnBranch, this.PickupDate, this.ReturnDate, this.CarId, 18, external, this.CreditCard.number, this.CreditCard.month, this.CreditCard.year, this.CreditCard.digitNo, this.CreditCard.ownerId, this.notes);
string ApiAddress = GlobFuncs.GetApiAddress(this.Company, "OrderBll");
string Json = JsonConvert.SerializeObject(ext);
string a = GetApi.PostApi(Json, ApiAddress);
List <string> ordNo = new List <string>();
if (a != null)
{
a = a.Substring(1, a.Length - 2);
ordNo.Add(a);
string b = GlobFuncs.GetDetails(this.Company, this.CarId);
CarDetails carDetails = new CarDetails();
string[] arr = b.Split('#');
string str = arr[0].Substring(2, arr[0].Length - 3).Replace("\\", "");
carDetails = JsonConvert.DeserializeObject <CarDetails>(str);
string pickBr = GlobFuncs.GetBranchName(this.PickupBranch, this.Company);
string RetBr = GlobFuncs.GetBranchName(this.ReturnBranch, this.Company);
DataBase db = new DataBase();
string sql = "insert into OrderTable (CustomId,ExternalRentId,totalPrice,CarName,CarId,CarLevel,CompanyId,Seats,GearBox,EngineCapacity,Doors,Beags,PickupBranch,PickupBranchText,PickupDate,ReturnBranch,ReturnBranchText,ReturnDate,creditCardId,Status,notes)values" +
" ('" + this.person.CustomId + "','" + a + "'," + this.totalPrice + ",'" + carDetails.CarName + "'," + this.CarId + ",'" + carDetails.CarLevel + "','" + this.Company + "','" + carDetails.Seats + "','" + carDetails.GearBox + "','" + carDetails.EngineCapacity + "','" + carDetails.Doors + "','" + carDetails.Baegs + "','" + this.PickupBranch + "','" + pickBr + "','" + this.PickupDate + "','" + this.ReturnBranch + "','" + RetBr + "','" + this.ReturnDate + "','" + this.CreditCard.id + "','2','" + this.notes + "')";
int SuccessFlag = db.ExecuteNonQuery(sql);
if (SuccessFlag > 0)
{
ordNo.Add(db.GetMaxId("OrderTable", "RentId").ToString());
if (this.extetions.Count > 0)
{
sql = "insert into ExtensInOrder (OrderId,ExtentionId,description,price) values";
foreach (Extention extention in this.extetions)
{
sql += "(" + int.Parse(db.GetMaxId("OrderTable", "RentId").ToString()) + "," + extention.id + ",'" + extention.description + "'," + extention.Price + "),";
}
sql = sql.Substring(0, sql.Length - 1);
db.ExecuteNonQuery(sql);
}
return(ordNo);
}
ordNo.Add("Error");
}
else
{
ordNo.Add("Error");
}
return(ordNo);
}
public static string GetBranchs()
{
string Companys = GetCompanyList();
DataTable dt = new DataTable();
dt = JsonConvert.DeserializeObject <DataTable>(Companys);
string Branchs = "[";
for (var i = 0; i < dt.Rows.Count; i++)
{
string Url = GetApiAddress(int.Parse(dt.Rows[i][0].ToString()), "Branch");
Url = "https://localhost:44361/api/Branch";
string result = GetApi.PostApi("", Url);
result = result.Replace("[", "");
result = result.Substring(1, result.Length - 3) + ",";
Branchs = Branchs + result;
}
Branchs = Branchs.Substring(0, Branchs.LastIndexOf(",")) + "]";
//Branchs.Replace("\\","");
return(Branchs);
}
public string GetCars()
{
string result = "\"[";
string json = JsonConvert.SerializeObject(this);
DataTable dt = new DataTable();
dt = GlobFuncs.getCarsApis();
foreach (DataRow row in dt.Rows)
{
string res = GetApi.PostApi(json, row["ApiAddress"].ToString() + "CarsBLL");
if (res.Length > 0)
{
res = res.Replace("}", ",\\\"Company\\\":" + row["CompanyId"] + "\\r\\n }");
res = res.Substring(2, res.Length - 4) + ",";
result = result + res;
}
}
result = result.Substring(0, result.Length - 1);
result = result + "]\"";
return(result);
}
