private void ExportToExcell()
{
ArrivalModel ar = new ArrivalModel();
_dt = ar.SearchDailyArrivalList(txtDateFrom.Text, txtTo.Text);
_newtbl = new DataTable();
_newtbl.Columns.Add(new DataColumn("Warehouse", typeof(string)));
_newtbl.Columns.Add(new DataColumn("ReceivedDate", typeof(string)));
_newtbl.Columns.Add(new DataColumn("VoucherNumber", typeof(string)));
_newtbl.Columns.Add(new DataColumn("DepositorName", typeof(string)));
_newtbl.Columns.Add(new DataColumn("Woreda", typeof(string)));
_newtbl.Columns.Add(new DataColumn("Zone", typeof(string)));
_newtbl.Columns.Add(new DataColumn("TruckPlateNumber", typeof(string)));
_newtbl.Columns.Add(new DataColumn("TrailerPlateNumber", typeof(string)));
_newtbl.Columns.Add(new DataColumn("Commodity", typeof(string)));
_newtbl.Columns.Add(new DataColumn("CommodityType", typeof(string)));
_newtbl.Columns.Add(new DataColumn("Region", typeof(string)));
_newtbl.Columns.Add(new DataColumn("WashingStation", typeof(string)));
_newtbl.Columns.Add(new DataColumn("ArrivalNoOfBags", typeof(string)));
_newtbl.Columns.Add(new DataColumn("GradeCertificate", typeof(string)));
_newtbl.Columns.Add(new DataColumn("EstimateWeight", typeof(string)));
_newtbl.Columns.Add(new DataColumn("DriverName", typeof(string)));
_newtbl.Columns.Add(new DataColumn("ProductionYear", typeof(string)));
_newtbl.Columns.Add(new DataColumn("Labcode", typeof(string)));
_newtbl.Columns.Add(new DataColumn("Symbol", typeof(string)));
_newtbl.Columns.Add(new DataColumn("AcceptanceDate", typeof(string)));
_newtbl.Columns.Add(new DataColumn("SpecificArea", typeof(string)));
if (_dt.Rows.Count > 0)
{
for (int i = 0; i < _dt.Rows.Count; i++)
{
DataRow row = _newtbl.NewRow();
row["Warehouse"] = _dt.Rows[i]["warehouse"];
row["ReceivedDate"] = _dt.Rows[i]["DateTimeReceived"];
row["VoucherNumber"] = _dt.Rows[i]["VoucherNumber"];
row["DepositorName"] = _dt.Rows[i]["ClientName"];
row["Commodity"] = _dt.Rows[i]["Commodity"];
row["CommodityType"] = _dt.Rows[i]["CommodityType"];
row["Woreda"] = _dt.Rows[i]["Woreda"];
row["Zone"] = _dt.Rows[i]["Zone"];
row["TruckPlateNumber"] = _dt.Rows[i]["TruckPlateNumber"];
row["TrailerPlateNumber"] = _dt.Rows[i]["TrailerPlateNumber"];
row["Region"] = _dt.Rows[i]["Region"];
row["WashingStation"] = _dt.Rows[i]["WashingStation"];
row["ArrivalNoOfBags"] = _dt.Rows[i]["NumberofBags"];
row["GradeCertificate"] = _dt.Rows[i]["GradeCertificate"];
row["EstimateWeight"] = _dt.Rows[i]["EstimateWeight"];
row["DriverName"] = _dt.Rows[i]["DriverName"];
row["ProductionYear"] = _dt.Rows[i]["ProductionYear"];
row["Labcode"] = _dt.Rows[i]["Labcode"];
row["Symbol"] = _dt.Rows[i]["Symbol"];
row["AcceptanceDate"] = _dt.Rows[i]["AcceptanceDate"];
row["SpecificArea"] = _dt.Rows[i]["SpecificArea"];
_newtbl.Rows.Add(row);
}
PrepareExcel(_newtbl);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
Messages.ClearMessage();
Page.DataBind();
btnNext.Enabled = false;
btnNext.BackColor = System.Drawing.Color.LightGray;
chkIsSourceDetermined.Checked = true;
if (SessionKeyExists(SessionKey.Arrival))
{
//Response.Redirect("ErrorPage.aspx");
//return;
}
this.btnSave.UseSubmitBehavior = false;
btnSave.OnClientClick = "javascript:";
if (btnSave.CausesValidation)
{
btnSave.OnClientClick += " if ( Page_ClientValidate('" + btnSave.ValidationGroup + "') ){ ";
btnSave.OnClientClick += "this.disabled=true; this.value='Please Wait...'; }";
}
if (theArrival == null)
{
theArrival = new ArrivalModel();
Response.Redirect("ErrorPage.aspx");
return;
}
theArrival.RefreshAll();
FillControls();
//populateWashingStation();
populateclientcert();
PopulateExistingData();
populateVehicleSize();
GetCommodityTypes();
if (cboCommodity.SelectedIndex == 0)
{
cboCommodityType.Enabled = false;
RFVCoffeeType.Enabled = false;
DDLwashingstation.Enabled = false;
DDlvehiclesize.Enabled = false;
}
else
{
if (cboCommodityType.Items.Count == 1)
{
cboCommodityType.Enabled = false;
RFVCoffeeType.Enabled = false;
}
else
{
cboCommodityType.Enabled = true;
RFVCoffeeType.Enabled = true;
}
}
}
private DataTable getwashingstation(string ZID)
{
DDLwashingstation.Items.Clear();
DataTable dt = new DataTable();
ArrivalModel am = new ArrivalModel();
dt = am.getwashstation(ZID);
return(dt);
}
protected void populateVehicleSize()
{
DataTable dt = new DataTable();
ArrivalModel arr = new ArrivalModel();
dt = arr.getallvehiclesize();
DDlvehiclesize.DataSource = dt;
DDlvehiclesize.DataTextField = "description";
DDlvehiclesize.DataValueField = "Vehiclesize";
DDlvehiclesize.DataBind();
}
public ArrivalModel MapToArrivalModel()
{
var result = new ArrivalModel
{
Id = this.Id,
CourseId = this.CourseId,
BusStopOnRouteId = this.BusStopOnRouteId,
Time = this.Time
};
return(result);
}
public void populateclientcert()
{
DataTable dt = new DataTable();
ArrivalModel am = new ArrivalModel();
dt = am.getClientCertificates();
LstBxCert.DataSource = dt;
LstBxCert.DataTextField = "Name";
LstBxCert.DataValueField = "ID";
LstBxCert.Items.Add(new ListItem("Please Select Certificate", ""));
LstBxCert.DataBind();
}
public BaseContractResponse UpdateArrival(ArrivalModel arrivalModel)
{
return(ExecuteAction <BaseContractResponse>(r =>
{
var arrival = _dbContext.Arrivals.FirstOrDefault(u => u.Id == arrivalModel.Id);
arrival.Id = arrivalModel.Id;
arrival.CourseId = arrivalModel.CourseId;
arrival.BusStopOnRouteId = arrivalModel.BusStopOnRouteId;
arrival.Time = arrivalModel.Time;
_dbContext.Arrivals.Update(arrival);
_dbContext.SaveChanges();
}));
}
public CreateArrivalResponse CreateArrival(ArrivalModel arrivalModel)
{
return(ExecuteAction <CreateArrivalResponse>(r =>
{
var arrival = new Arrival()
{
Id = arrivalModel.Id,
CourseId = arrivalModel.CourseId,
BusStopOnRouteId = arrivalModel.BusStopOnRouteId,
Time = arrivalModel.Time
};
_dbContext.Arrivals.Add(arrival);
_dbContext.SaveChanges();
r.Id = arrival.Id;
}));
}
protected void lnkPrintArrival_Click(object sender, EventArgs e)
{
if (Session["TrackingNumber_Search"] == null)
{
lblSearchResultStatus.Text = "Unable to get tracking number! ";
return;
}
string TrackingNo = Session["TrackingNumber_Search"].ToString();
//Response.Redirect("AddArrival.aspx?TrackingNo=" + TrackingNo);
ArrivalModel theArrivalModel = new ArrivalModel();
theArrivalModel.TrackingNumber = TrackingNo;
//theArrivalModel = theArrivalModel.GetByTrackingNo();
//theArrivalModel.IsNew = false;
Session["Arrival"] = theArrivalModel;
Response.Redirect("AddArrival.aspx?TrackingNo=" + TrackingNo + " &CommandType=Update");
}
protected void Page_Load(object sender, EventArgs e)
{
string transactionNo = Request.QueryString["TranNo"];
string taskName = Request.QueryString["Task"];
if (!(string.IsNullOrEmpty(transactionNo) && string.IsNullOrEmpty(taskName)))
{
if ("Full Arrival" == taskName)
{
ArrivalModel theArrivalModel = new ArrivalModel();
theArrivalModel.TrackingNumber = transactionNo;
//theArrivalModel = theArrivalModel.GetByTrackingNo();
//theArrivalModel.IsNew = false;
Session["Arrival"] = theArrivalModel;
Response.Redirect("AddArrival.aspx?TrackingNo=" + transactionNo + " &CommandType=Insert");
}
else if ("Sampling Code" == taskName)
{
Response.Redirect("GetSampleTicketNew.aspx");
}
else if ("Sampling Result".ToUpper().Trim() == taskName.ToUpper().Trim())
{
Response.Redirect("AddSamplingResultNew.aspx?sampleCode=" + transactionNo);
}
else if ("Grading Code".ToUpper().Trim() == taskName.ToUpper().Trim())
{
Response.Redirect("GenerateGrading.aspx?CurrentWarehouse="
+ UserBLL.GetCurrentWarehouse() + "&sampleCode=" + transactionNo);
}
else if ("Code Received at Lab".ToUpper().Trim() == taskName.ToUpper().Trim())
{
Response.Redirect("SampleCodeReceive.aspx?CurrentWarehouse="
+ UserBLL.GetCurrentWarehouse() + "&GradingCode=" + transactionNo);
}
else if ("Grading Result".ToUpper().Trim() == taskName.ToUpper().Trim())
{
Response.Redirect("GradingResult.aspx?CurrentWarehouse="
+ UserBLL.GetCurrentWarehouse() + "&GradingCode=" + transactionNo
+ "&EditMode=false"
);
}
//else if ("Grading Result Client Acceptance".ToUpper().Trim() == taskName.ToUpper().Trim())
//{
// Response.Redirect("GradingResultClientAcceptanceNew.aspx?CurrentWarehouse="
// + UserBLL.GetCurrentWarehouse() + "&GradingCode=" + transactionNo);
//}
else if ("Client Response".ToUpper().Trim() == taskName.ToUpper().Trim())
{
Response.Redirect("GradingResultClientAcceptanceNew.aspx?CurrentWarehouse="
+ UserBLL.GetCurrentWarehouse() + "&GradingCode=" + transactionNo);
}
else if ("Unloading Scaling and GRN".ToUpper().Trim() == taskName.ToUpper().Trim())
{
Response.Redirect("AddUnloadingNew.aspx?CurrentWarehouse="
+ UserBLL.GetCurrentWarehouse() + "&GradingCode=" + transactionNo
+ "&CommandName=Insert"
);
}
//else if ("Data assistant GRN Approval".ToUpper().Trim() == taskName.ToUpper().Trim())
//{
// Response.Redirect("GRNClientSign.aspx?CurrentWarehouse="
// + UserBLL.GetCurrentWarehouse());
//}
else if ("Supervisor GRN Approval".ToUpper().Trim() == taskName.ToUpper().Trim())
{
}
else if ("GradingReSampling".ToUpper().Trim() == taskName.ToUpper().Trim())
{
}
else
{
return;
}
}
}
