protected void uiGridViewShipping_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "DeleteShipping")
{
ShippingLines objData = new ShippingLines();
objData.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString()));
objData.MarkAsDeleted();
objData.Save();
BindData();
}
}
protected void uiLinkButtonAdd_Click(object sender, EventArgs e)
{
ShippingLines objData = new ShippingLines();
objData.AddNew();
objData.CompanyID = Convert.ToInt32(uiDropDownListCompanies.SelectedValue);
objData.FromSeaPortID = Convert.ToInt32(uiDropDownListFromCity.SelectedValue);
objData.ToSeaPortID = Convert.ToInt32(uiDropDownListToCity.SelectedValue);
objData.Save();
BindData();
}
protected void uiLinkButtonUpload_Click(object sender, EventArgs e)
{
if (uiFileUploadshippingLines.HasFile)
{
ArrayList nonUploaded = new ArrayList();
uiFileUploadshippingLines.SaveAs(Server.MapPath("~/FileUploads/" + uiFileUploadshippingLines.FileName));
string connectionString = string.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0;HDR=NO;""", Server.MapPath("~/FileUploads/" + uiFileUploadshippingLines.FileName));
string strSQL = "SELECT * FROM [sheet1$]";
OleDbConnection excelConnection = new OleDbConnection(connectionString);
excelConnection.Open();
OleDbCommand dbCommand = new OleDbCommand(strSQL, excelConnection);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(dbCommand);
DataTable dTable = new DataTable();
dataAdapter.Fill(dTable);
ShippingLines objData = new ShippingLines();
if (uiDropDownListUploadType.SelectedValue == "1")
{
foreach (DataRow item in dTable.Rows)
{
SeaPorts Fcity = new SeaPorts();
Fcity.GetSeaPortByCode(item[0].ToString());
SeaPorts Tcity = new SeaPorts();
Tcity.GetSeaPortByCode(item[1].ToString());
if (Fcity.RowCount == 0 || Tcity.RowCount == 0)
{
nonUploaded.Add("From : " + item[0].ToString() + " - To : " + item[1].ToString());
continue;
}
else
{
objData.AddNew();
objData.CompanyID = Convert.ToInt32(uiDropDownListUploadCompany.SelectedValue);
objData.FromSeaPortID = Fcity.SeaPortID;
objData.ToSeaPortID = Tcity.SeaPortID;
}
}
}
else if (uiDropDownListUploadType.SelectedValue == "2")
{
foreach (DataRow item in dTable.Rows)
{
SeaPorts Fcity = new SeaPorts();
Fcity.GetSeaPortByName(item[0].ToString());
SeaPorts Tcity = new SeaPorts();
Tcity.GetSeaPortByName(item[1].ToString());
if (Fcity.RowCount == 0 || Tcity.RowCount == 0)
{
nonUploaded.Add("From : " + item[0].ToString() + " - To : " + item[1].ToString());
continue;
}
else
{
objData.AddNew();
objData.CompanyID = Convert.ToInt32(uiDropDownListUploadCompany.SelectedValue);
objData.FromSeaPortID = Fcity.SeaPortID;
objData.ToSeaPortID = Tcity.SeaPortID;
}
}
}
objData.Save();
BindData();
uiGridViewLog.DataSource = nonUploaded;
//uiGridViewLog.Columns[0].HeaderText = "These items faild to insert";
uiGridViewLog.DataBind();
}
}
private void BindData()
{
ShippingLines objData = new ShippingLines();
objData.LoadAll();
uiGridViewShipping.DataSource = objData.DefaultView;
uiGridViewShipping.DataBind();
}