public static List <IShipSoft> GetShipSoftData(int custId, int locId, bool isTagged, int month, int year, SearchCriteria searchCriteria)
{
string strExecution = "[common].[uspGetShipSoft]";
List <IShipSoft> lstShipSoft = new List <IShipSoft>();
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddIntegerParam("@CustId", custId);
oDq.AddIntegerParam("@LocId", locId);
oDq.AddBooleanParam("@IsTagged", isTagged);
oDq.AddIntegerParam("@Month", month);
oDq.AddIntegerParam("@Year", year);
oDq.AddVarcharParam("@SortExpression", 50, searchCriteria.SortExpression);
oDq.AddVarcharParam("@SortDirection", 4, searchCriteria.SortDirection);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
IShipSoft shipSoft = new ShipSoftEntity(reader);
lstShipSoft.Add(shipSoft);
}
reader.Close();
}
return(lstShipSoft);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (ValidateSave())
{
List <ShipSoftEntity> lstShipSoft = new List <ShipSoftEntity>();
int tranId = 0;
bool isTagged = (rblTag.SelectedValue == "1") ? true : false;
for (int index = 0; index < gvwData.Rows.Count; index++)
{
CheckBox chkSel = (CheckBox)gvwData.Rows[index].FindControl("chkSel");
HiddenField hdnId = (HiddenField)gvwData.Rows[index].FindControl("hdnId");
if (!ReferenceEquals(chkSel, null) && !ReferenceEquals(hdnId, null))
{
if (isTagged) //For tagged data, populate deselected data
{
if (!chkSel.Checked)
{
tranId = 0;
int.TryParse(hdnId.Value, out tranId);
if (tranId > 0)
{
ShipSoftEntity shipSoft = new ShipSoftEntity();
shipSoft.TranId = tranId;
lstShipSoft.Add(shipSoft);
}
}
}
else //For untagged data, populate only selected data
{
if (chkSel.Checked)
{
tranId = 0;
int.TryParse(hdnId.Value, out tranId);
if (tranId > 0)
{
ShipSoftEntity shipSoft = new ShipSoftEntity();
shipSoft.TranId = tranId;
lstShipSoft.Add(shipSoft);
}
}
}
}
}
if (lstShipSoft.Count > 0)
{
new CommonBLL().TagCustomer(lstShipSoft, Convert.ToInt32(ddlCust.SelectedValue), Convert.ToInt32(ddlSales.SelectedValue), isTagged, _userId);
LoadShipSoftData();
GeneralFunctions.RegisterAlertScript(this, ResourceManager.GetStringWithoutName("ERR00005"));
//ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "<script>javascript:void alert('" + ResourceManager.GetStringWithoutName("ERR00005") + "');</script>", false);
}
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int tranId = 0;
List <ShipSoftEntity> lstShipSoft = new List <ShipSoftEntity>();
for (int index = 0; index < gvwData.Rows.Count; index++)
{
CheckBox chkSel = (CheckBox)gvwData.Rows[index].FindControl("chkSel");
HiddenField hdnId = (HiddenField)gvwData.Rows[index].FindControl("hdnId");
if (!ReferenceEquals(chkSel, null) && !ReferenceEquals(hdnId, null))
{
if (chkSel.Checked)
{
tranId = 0;
int.TryParse(hdnId.Value, out tranId);
if (tranId > 0)
{
ShipSoftEntity shipSoft = new ShipSoftEntity();
shipSoft.TranId = tranId;
lstShipSoft.Add(shipSoft);
}
}
}
}
if (lstShipSoft.Count > 0)
{
new CommonBLL().DeleteShipSoftData(lstShipSoft, _userId);
LoadShipSoftData();
GeneralFunctions.RegisterAlertScript(this, ResourceManager.GetStringWithoutName("ERR00006"));
}
else
{
GeneralFunctions.RegisterAlertScript(this, ResourceManager.GetStringWithoutName("ERR00075"));
}
}
protected void btnImport_Click(object sender, EventArgs e)
{
//LoadShipSoftData();
//upArea.Update();
if (fuShipSoft.HasFile)
{
string fileExt = System.IO.Path.GetExtension(fuShipSoft.FileName);
List <ShipSoftEntity> lstShipSoft = new List <ShipSoftEntity>();
if (fileExt.ToUpper() == ".BLA")
{
using (StreamReader reader = new StreamReader(fuShipSoft.FileContent, Encoding.Default))
{
while (!reader.EndOfStream)
{
string str = reader.ReadLine().Replace((char)29, '|');
string[] abc = str.Split('|');
if (abc.Length > 8)
{
try
{
ShipSoftEntity shipSoft = new ShipSoftEntity();
shipSoft.LocationName = Convert.ToString(abc[0]);
shipSoft.ProspectName = Convert.ToString(abc[1]);
shipSoft.BookingNo = Descramble(Convert.ToString(abc[2]));
shipSoft.BLANumber = Descramble(Convert.ToString(abc[3]));
shipSoft.VesselVoyage = Descramble(Convert.ToString(abc[4]));
shipSoft.ShipperName = Descramble(Convert.ToString(abc[5]));
shipSoft.PortName = Descramble(Convert.ToString(abc[6]));
shipSoft.TEU = Convert.ToInt32(Descramble(Convert.ToString(abc[7])));
shipSoft.FEU = Convert.ToInt32(Descramble(Convert.ToString(abc[8])));
shipSoft.SOBDate = Convert.ToDateTime(Descramble(Convert.ToString(abc[9], _culture)));
lstShipSoft.Add(shipSoft);
}
catch (Exception ex)
{
}
}
}
}
if (lstShipSoft.Count > 0)
{
int dupCount = 0;
int rowsAffected = 0;
new CommonBLL().SaveShipSoft(lstShipSoft, _userId, out rowsAffected, out dupCount);
string message = "Total Number of Records Processed: " + Convert.ToString(lstShipSoft.Count) + "\\r\\n";
message += "Total Number of Records Up-loaded: " + rowsAffected.ToString() + "\\r\\n";
message += "Total Number of Records Rejected: " + dupCount.ToString();
GeneralFunctions.RegisterAlertScript(this, message);
}
}
}
else
{
GeneralFunctions.RegisterAlertScript(this, ResourceManager.GetStringWithoutName("ERR00052"));
}
}
