public ViewAnnounceA(FindTable find, string category, string subCategory)
{
Photos = new List <ViewPhoto>();
FindTable = find;
Category = category;
SubCategory = subCategory;
}
public async Task <IActionResult> CarEditAnnounce(int id, FindTable findTable)
{
var data = await _findData.GetCar(id, "", false);
if (id == 0 || data == null)
{
return(NotFound());
}
return(View(data));
}
private void TableCreate()
{
try
{
Object I;
SqlConnection cn = new SqlConnection(ConnectAll.ConnectMe());
SqlCommand cmd;
if (FindTable.ProgramTable("tbl_TargetDefine") == 1)
{
return;
}
else
{
string sqlCreate1 = "CREATE TABLE tbl_TargetDefine ( ID int IDENTITY(1,1) NOT NULL,";
sqlCreate1 += "Grouptype Nvarchar(50) Null, Code Nvarchar(50) Null, Description Nvarchar(2000) Null)ON [PRIMARY] ";
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
cmd = new SqlCommand(sqlCreate1, cn);
I = cmd.ExecuteScalar();
cmd.Dispose();
cn.Close();
}
if (FindTable.ProgramTable("tbl_TargetAssin") == 1)
{
return;
}
else
{
string sqlCreate2 = "CREATE TABLE tbl_TargetAssin ( ID int IDENTITY(1,1) NOT NULL,";
sqlCreate2 += "Grouptype Nvarchar(50) Null, Code Nvarchar(50) Null, Description Nvarchar(2000) Null,";
sqlCreate2 += "mYears nvarchar(20) Null, Months Nvarchar(20) Null, TargetValue Int)ON [PRIMARY] ";
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
cmd = new SqlCommand(sqlCreate2, cn);
I = cmd.ExecuteScalar();
cmd.Dispose();
cn.Close();
}
}catch (Exception ex)
{
webMessage.Show("Error Creating Report Table :" + ex.Message);
}
}
protected void drpLGA_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
drpFacname.Items.Clear();
drpFacname.Items.Add("");
var Dat = FindTable.GetFacilityName(drpStates.SelectedItem.Text.Trim(), drpLGA.SelectedItem.Text.Trim());
foreach (DataRow r in Dat.Rows)
{
drpFacname.Items.Add(r["facname"].ToString());
}
}
catch (Exception ex)
{
Response.Write("<script language=javascript>alert('" + ex.Message.ToString() + "' );</script>");
return;
}
}
// Returns whether continue to calculate.
private bool CheckWeight(TOParameters para)
{
var(a, _) = FindTable.Find(tables, aircrafts, regComboBox.Text);
var ac = a.Config;
if (para.WeightKg > ac.MaxTOWtKg || para.WeightKg < ac.OewKg)
{
var result = this.ShowDialog(
"Takeoff weight is not within valid range. Continue to calculate?",
MsgBoxIcon.Warning,
"",
DefaultButton.Button2,
"Yes", "No");
return(result == MsgBoxResult.Button1);
}
return(true);
}
private void RegistrationChanged(object sender, EventArgs e)
{
if (regComboBox.SelectedIndex < 0)
{
RefreshWtColor();
return;
}
// unsubsribe all event handlers
if (controller != null)
{
UnSubscribe(controller);
currentTable = null;
controller = null;
}
var(ac, perf) = FindTable.Find(tables, aircrafts, regComboBox.Text);
if (ac != null && perf != null)
{
// Set currentTable and controller.
currentTable = perf;
controller = GetController(new FormControllerData()
{
ConfigItem = ac.Config,
PerfTable = currentTable,
Elements = elements,
ParentControl = this
});
Subscribe(controller);
UpdateFormOptions();
RefreshWtColor();
}
}
public ViewAnnounce(FindTable findTable)
{
Photos = new List <ViewPhoto>();
this.FindTable = findTable;
}
protected void Button1_Click(object sender, EventArgs e)
{
DropTable();
CREATTable();
//==================================================
string mFile1 = drpProgramArea.SelectedItem.Text.Trim();
// Console.WriteLine("Hello \n");
string mFile = string.Empty;
string mTableName = string.Empty;
FindTable.GetThematic(mFile1, out mFile); //<====== return groupType
//===============================================================
//string SQLH = "SELECT * FROM tbl_defn WHERE grouptype = '" + mFile + "' ";
SqlConnection cn = new SqlConnection(ConnectAll.ConnectMe());
cn.Open();
//SqlCommand cmd = new SqlCommand(SQLH, cn);
//SqlDataReader r = cmd.ExecuteReader();
//while (r.Read())
//{
var Dat = new DataTable();
Dat = FindTable.SearchTableDefine(mFile);
foreach (DataRow r in Dat.Rows)
{
//insert via procedure
FindTable.InsertTempReport(r["grouptype"].ToString(), r["code"].ToString(), r["description"].ToString());
}
var Mnth1 = FindTable.GetMonths(drpMonths.SelectedItem.Text.Trim());
var Mnth2 = FindTable.GetMonths(drpMonths2.SelectedItem.Text.Trim());
//DataTable dt = GetDatafromDatabase(drpProgramArea.SelectedItem.Text.Trim(),); //===== returns a DataTable
DataTable dt = FindTable.GetDatafromDatabase(drpProgramArea.SelectedItem.Text.Trim(), drpStates.SelectedItem.Text.Trim(),
drpLGA.SelectedItem.Text.Trim(), drpFacname.SelectedItem.Text.Trim(),
drpYears.SelectedItem.Text.Trim(), drpYears2.SelectedItem.Text.Trim(),
Mnth1, Mnth2);
string SQLT = "SELECT * FROM tbl_TempReport";
string colname;
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlCommand cmdT = new SqlCommand(SQLT, cn);
SqlDataReader rt = cmdT.ExecuteReader();
while (rt.Read())
{
//==== For each row, print the values of each column.
int mValue = 0;
foreach (DataColumn column in dt.Columns)
{
foreach (DataRow row in dt.Rows)
{
colname = column.ColumnName.ToString();
string m_Code = rt["code"].ToString();
if (m_Code == colname)
{
// mValue = Convert.ToInt32((! string.IsNullOrEmpty(rt["ValueP"].ToString()) ? rt["ValueP"].ToString() :"0") );
if (!string.IsNullOrEmpty(row[column].ToString()))
{
//&& mValue > 0
if (m_Code == colname)
{
mValue += Convert.ToInt32(row[column].ToString());
}
else
{
mValue = Convert.ToInt32(row[column].ToString());
}
}
//============ insert into tbl_TempReport to match the appropriate column ====================
string SQLP = "UPDATE tbl_TempReport SET VALUEP = @VALUEP WHERE code = @code";
SqlCommand cmdp = new SqlCommand(SQLP, cn);
cmdp.Parameters.AddWithValue("@VALUEP", SqlDbType.Int).Value = mValue;
cmdp.Parameters.AddWithValue("@code", SqlDbType.NVarChar).Value = rt["code"].ToString();
cmdp.ExecuteNonQuery();
}
}
}
}
//==============================================================================================
//========== Display the Data to Excel ========================
//==============================================================================================
DisplayExcel(); //
}
//Upload
/// <summary>
///
/// </summary>
/// <param name="files"></param>
/// <param name="id">required</param>
/// <param name="addPath">example: lib/images/transport/car</param>
/// <param name="announceName"></param>
/// <returns></returns>
public void AddDataPhoto(List <string> files, int id, string addPath, FindTable announceName)
{
addPath = "upload";
foreach (var fileName in files)
{
switch (announceName.ToString().ToLower())
{
case "car":
_dbContext.CarPhotos.Add(new CarPhoto
{
Path = "/" + addPath + "/" + fileName,
CarId = id,
});
break;
case "bus":
BusPhoto busPhoto = new BusPhoto
{
Path = "/" + addPath + "/" + fileName,
BusId = id,
};
_dbContext.BusPhotos.Add(busPhoto);
break;
case "motocycle":
_dbContext.MotocyclePhotos.Add(new MotocyclePhoto
{
Path = "/" + addPath + "/" + fileName,
MotocycleId = id,
});
break;
case "accessory":
_dbContext.AccessoryPhotos.Add(new AccessoryPhoto
{
Path = "/" + addPath + "/" + fileName,
AccessoryId = id,
});
break;
case "apartment":
_dbContext.ApartmentPhotos.Add(new ApartmentPhoto
{
Path = "/" + addPath + "/" + fileName,
ApartmentId = id,
});
break;
case "house":
_dbContext.HousePhotos.Add(new HousePhoto
{
Path = "/" + addPath + "/" + fileName,
HouseId = id,
});
break;
case "office":
_dbContext.OfficePhotos.Add(new OfficePhoto
{
Path = "/" + addPath + "/" + fileName,
OfficeId = id,
});
break;
case "garage":
_dbContext.GaragePhotos.Add(new GaragePhoto
{
Path = "/" + addPath + "/" + fileName,
GarageId = id,
});
break;
case "land":
_dbContext.LandPhotos.Add(new LandPhoto
{
Path = "/" + addPath + "/" + fileName,
LandId = id,
});
break;
case "job":
_dbContext.JobPhotos.Add(new JobPhoto
{
Path = "/" + addPath + "/" + fileName,
JobId = id,
});
break;
case "business":
_dbContext.BusinessEPhotos.Add(new BusinessEPhoto
{
Path = "/" + addPath + "/" + fileName,
BusinessEquipmentId = id,
});
break;
case "food":
_dbContext.FoodPhotos.Add(new FoodPhoto
{
Path = "/" + addPath + "/" + fileName,
FoodId = id,
});
break;
default:
break;
}
}
}
public string GenerateAnnounceName(string announceName, FindTable findTable)
{
StringBuilder name = new StringBuilder();
switch (findTable)
{
case FindTable.Car:
if (announceName.Length >= 18)
{
for (int i = 0; i < announceName.Length; i++)
{
if (i <= 10)
{
name.Append(announceName[i]);
}
else if (i == 11)
{
name.Append(" ");
}
else if (i <= 14)
{
name.Append(".");
}
else if (i == 15)
{
name.Append(",");
}
}
name.Append(announceName.Substring(announceName.Length - 4, 4));
}
else
{
name.Append(announceName);
}
break;
case FindTable.Bus:
if (announceName.Length >= 18)
{
for (int i = 0; i < announceName.Length; i++)
{
if (i <= 16)
{
name.Append(announceName[i]);
}
else if (i <= 19)
{
name.Append(".");
}
}
}
else
{
name.Append(announceName);
}
break;
case FindTable.Accessory:
if (announceName.Length >= 18)
{
for (int i = 0; i < announceName.Length; i++)
{
if (i <= 16)
{
name.Append(announceName[i]);
}
else if (i <= 19)
{
name.Append(".");
}
}
}
else
{
name.Append(announceName);
}
break;
case FindTable.Motocycle:
if (announceName.Length >= 18)
{
for (int i = 0; i < announceName.Length; i++)
{
if (i <= 16)
{
name.Append(announceName[i]);
}
else if (i <= 19)
{
name.Append(".");
}
}
}
else
{
name.Append(announceName);
}
break;
case FindTable.Apartment:
if (announceName.Length >= 18)
{
var announceNames = announceName.Split('/');
name.Append(announceName[0] + "-otaqlı");
name.Append("," + announceName[1] + "m2");
}
else
{
name.Append(announceName);
}
break;
case FindTable.House:
if (announceName.Length >= 18)
{
for (int i = 0; i < announceName.Length; i++)
{
if (i <= 10)
{
name.Append(announceName[i]);
}
else if (i == 11)
{
name.Append(" ");
}
else if (i <= 14)
{
name.Append(".");
}
else if (i == 15)
{
name.Append(",");
}
}
name.Append(announceName.Substring(announceName.Length - 4, 4));
}
else
{
name.Append(announceName);
}
break;
case FindTable.Office:
if (announceName.Length >= 18)
{
for (int i = 0; i < announceName.Length; i++)
{
if (i <= 10)
{
name.Append(announceName[i]);
}
else if (i == 11)
{
name.Append(" ");
}
else if (i <= 14)
{
name.Append(".");
}
else if (i == 15)
{
name.Append(",");
}
}
name.Append(announceName.Substring(announceName.Length - 4, 4));
}
else
{
name.Append(announceName);
}
break;
case FindTable.Garage:
if (announceName.Length >= 18)
{
for (int i = 0; i < announceName.Length; i++)
{
if (i <= 16)
{
name.Append(announceName[i]);
}
else if (i <= 19)
{
name.Append(".");
}
}
}
else
{
name.Append(announceName);
}
break;
case FindTable.Land:
if (announceName.Length >= 18)
{
for (int i = 0; i < announceName.Length; i++)
{
if (i <= 16)
{
name.Append(announceName[i]);
}
else if (i <= 19)
{
name.Append(".");
}
}
}
else
{
name.Append(announceName);
}
break;
case FindTable.Job:
if (announceName.Length >= 18)
{
for (int i = 0; i < announceName.Length; i++)
{
if (i <= 16)
{
name.Append(announceName[i]);
}
else if (i <= 19)
{
name.Append(".");
}
}
}
else
{
name.Append(announceName);
}
break;
case FindTable.Business:
if (announceName.Length >= 18)
{
for (int i = 0; i < announceName.Length; i++)
{
if (i <= 16)
{
name.Append(announceName[i]);
}
else if (i <= 19)
{
name.Append(".");
}
}
}
else
{
name.Append(announceName);
}
break;
case FindTable.Food:
if (announceName.Length >= 18)
{
for (int i = 0; i < announceName.Length; i++)
{
if (i <= 16)
{
name.Append(announceName[i]);
}
else if (i <= 19)
{
name.Append(".");
}
}
}
else
{
name.Append(announceName);
}
break;
default:
name.Append(announceName);
break;
}
return(name.ToString());
}
