private void LoadData()
{
ImportHaulageEntity oImportHaulage = (ImportHaulageEntity)ImportHaulageBLL.GetImportHaulage(Convert.ToInt32(hdnHaulageChrgID.Value));
//ddlFromLocation.SelectedIndex = Convert.ToInt32(ddlFromLocation.Items.IndexOf(ddlFromLocation.Items.FindByValue(oImportHaulage.LocationFrom)));
hdnFromLocation.Value = oImportHaulage.LocationFrom.Substring(oImportHaulage.LocationFrom.IndexOf('|') + 1);
txtFromLocation.Text = oImportHaulage.LocationFrom.Substring(0, oImportHaulage.LocationFrom.IndexOf('|'));
//ddlToLocation.SelectedIndex = Convert.ToInt32(ddlToLocation.Items.IndexOf(ddlToLocation.Items.FindByValue(oImportHaulage.LocationTo)));
hdnToLocation.Value = oImportHaulage.LocationTo.Substring(oImportHaulage.LocationTo.IndexOf('|') + 1);
txtToLocation.Text = oImportHaulage.LocationTo.Substring(0, oImportHaulage.LocationTo.IndexOf('|'));
ddlLine.SelectedValue = oImportHaulage.LinerID.ToString();
ddlContainerSize.SelectedIndex = Convert.ToInt32(ddlContainerSize.Items.IndexOf(ddlContainerSize.Items.FindByText(oImportHaulage.ContainerSize)));
txtWFrom.Text = Convert.ToString(oImportHaulage.WeightFrom);
txtWTo.Text = Convert.ToString(oImportHaulage.WeightTo);
txtRate.Text = Convert.ToString(oImportHaulage.HaulageRate);
if (oImportHaulage.EffectDate >= Convert.ToDateTime("01/01/1950"))
{
txtEffectDate.Text = oImportHaulage.EffectDate.ToString("dd/MM/yyyy");
}
}
public static List <IImportHaulage> GetImportHaulage(SearchCriteria searchCriteria, int ID)
{
string strExecution = "[mst].[spGetImportHaulageCharge]";
List <IImportHaulage> lstImportHAulage = new List <IImportHaulage>();
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddIntegerParam("@HaulageChgID", ID);
oDq.AddVarcharParam("@SchLocFrom", 100, searchCriteria.LocationFrom);
oDq.AddVarcharParam("@SchLocTo", 100, searchCriteria.LocationTo);
oDq.AddVarcharParam("@SchLine", 100, searchCriteria.LineName);
oDq.AddVarcharParam("@SchContSize", 2, searchCriteria.ContainerSize);
oDq.AddVarcharParam("@SortExpression", 50, searchCriteria.SortExpression);
oDq.AddVarcharParam("@SortDirection", 4, searchCriteria.SortDirection);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
IImportHaulage oIH = new ImportHaulageEntity(reader);
lstImportHAulage.Add(oIH);
}
reader.Close();
}
return(lstImportHAulage);
}
public static IImportHaulage GetImportHaulage(int ID)
{
string strExecution = "[mst].[spGetImportHaulageCharge]";
IImportHaulage oIH = null;
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddIntegerParam("@HaulageChgID", ID);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
oIH = new ImportHaulageEntity(reader);
}
reader.Close();
}
return(oIH);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
if (Convert.ToDecimal(txtWFrom.Text) > Convert.ToDecimal(txtWTo.Text))
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "<script>javascript:void alert('" + ResourceManager.GetStringWithoutName("ERR00077") + "');</script>", false);
return;
}
oImportHaulageBll = new ImportHaulageBLL();
oImportHaulageEntity = new ImportHaulageEntity();
//oUserEntity = (UserEntity)Session[Constants.SESSION_USER_INFO]; // This section has been commented temporarily
oImportHaulageEntity.ContainerSize = ddlContainerSize.SelectedItem.Text;
oImportHaulageEntity.HaulageRate = Convert.ToDecimal(txtRate.Text);
oImportHaulageEntity.LocationFrom = hdnFromLocation.Value;
oImportHaulageEntity.LocationTo = hdnToLocation.Value;
oImportHaulageEntity.LinerID = ddlLine.SelectedValue.ToInt();
oImportHaulageEntity.WeightFrom = Convert.ToDecimal(txtWFrom.Text.Trim());
oImportHaulageEntity.WeightTo = Convert.ToDecimal(txtWTo.Text.Trim());
oImportHaulageEntity.HaulageStatus = true;
oImportHaulageEntity.EffectDate = Convert.ToDateTime(txtEffectDate.Text);
if (hdnHaulageChrgID.Value == "0") // Insert
{
oImportHaulageEntity.CreatedBy = _userId; // oUserEntity.Id;
oImportHaulageEntity.CreatedOn = DateTime.Today.Date;
oImportHaulageEntity.ModifiedBy = _userId; // oUserEntity.Id;
oImportHaulageEntity.ModifiedOn = DateTime.Today.Date;
switch (oImportHaulageBll.AddEditImportHAulageChrg(oImportHaulageEntity))
{
case -1: lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00076");
break;
case 0: lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00011");
ClearAll();
break;
case 1: lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00009");
ClearAll();
break;
}
}
else // Update
{
oImportHaulageEntity.HaulageChgID = Convert.ToInt32(hdnHaulageChrgID.Value);
oImportHaulageEntity.ModifiedBy = _userId;// oUserEntity.Id;
oImportHaulageEntity.ModifiedOn = DateTime.Today.Date;
//
switch (oImportHaulageBll.AddEditImportHAulageChrg(oImportHaulageEntity))
{
case -1: lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00076");
break;
case 0: lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00011");
break;
case 1: Response.Redirect("~/MasterModule/ImportHaulage-list.aspx");
break;
}
}
}
}
