public LUCOut UldInfomationIN(string id)
{
try
{
LUCOut ob = new LUCOut();
SqlParameter[] Parameters =
{
new SqlParameter("@id", id),
};
var res = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.Text, "SELECT * from ViewLucGrid where UldNumber=@id", Parameters);
if (res != null && res.Tables[0].Rows.Count > 0)
{
ob = res.Tables[0].AsEnumerable().Select(e => new LUCOut
{
Text_LUCInNumber = e["ReceivedByCityCode"].ToString(),
Text_CityCode = e["ReceivedByCityCode"].ToString(),
Text_IssuedBy = e["ReceivedByCityCode"].ToString(),
Text_IssuedFrom = e["ReceivedByCityCode"].ToString(),
Text_Issuedate = e["ReceivedByCityCode"].ToString(),
Text_Receiveddate = e["ReceivedByCityCode"].ToString(),
Text_DemurrageCode = e["ReceivedByCityCode"].ToString(),
Text_ODLNCode = e["ReceivedByCityCode"].ToString(),
Text_Remarks = e["ReceivedByCityCode"].ToString(),
Text_ReceivedBy = e["ReceivedByCityCode"].ToString(),
}).FirstOrDefault();
}
return(ob);
}
catch (Exception ex)//
{
throw ex;
}
}
public LUCOut UldInfomationIN(string id)
{
try
{
LUCOut ob = new LUCOut();
SqlParameter[] Parameters =
{
new SqlParameter("@SNo", id),
new SqlParameter("@AirportCode", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).AirportCode.ToString()),
};
var res = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "spGetLucIn", Parameters);
if (res != null && res.Tables[0].Rows.Count > 0)
{
ob = res.Tables[0].AsEnumerable().Select(e => new LUCOut
{
SNo = e["SNo"].ToString(),
Text_ULD = e["ULDNumber"].ToString(),
Text_IssuedBy = e["IssuedBy"].ToString().ToUpper(),
Text_IssuedFrom = e["Issuedfrom"].ToString(),
Text_Issuedate = e["ULDDate"].ToString(),
Text_Issuetime = e["ULDTime"].ToString(),
Text_CityCode = e["ReceivedByCityCode"].ToString(),
//Text_DemurrageCode = e["ULDNumber"].ToString(),
ODLNCode = Convert.ToInt32(e["ODLNCodeSNo"]),
Text_ODLNCode = e["odlndesc"].ToString(),
// Text_ReceivedBy = e["UserName"].ToString(),
//Text_ReceivedBySNO = Convert.ToInt32(e["ReceivedUserSno"]),
Text_ReceivedBy = e["ReceivedUsername"].ToString(),
// Currentusersno = ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo,
currentuserName = ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserName.ToString().ToUpper(),
Text_ReceivedFrom = e["Receivedfrom"].ToString(),
Text_Remarks = e["ReturnRemarks"].ToString(),
LUCInNumber = e["LUCInNumber"].ToString(),
Text_Receiveddate = e["ReceivedDate"].ToString(),
Text_ReceivedTime = e["ReceivedTime"].ToString(),
UCRReceiptNo = e["UCRReceiptNo"].ToString(),
RentalDays = e["RentalDays"].ToString(),
UHFReceiptNo = e["UHFReceiptNo"].ToString(),
isrDamage = e["isrDamage"].ToString(),
isrdamageremarks = e["isrdamageremarks"].ToString(),
}).FirstOrDefault();
}
return(ob);
}
catch (Exception ex)//
{
throw ex;
}
}
//public string EditData(string id)
//{
// DataSet ds = new DataSet();
// LUC lu = new LUC();
// SqlParameter[] Parameters = { new SqlParameter("@SNo", id) };
// ds = SqlHelper.ExecuteDataset(ReadConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "Get_LUCRecord", Parameters);
// FlightOpenService fos = new FlightOpenService();
// return fos.DStoJSON(ds);
//}
public LUCOut EditData(string id)
{
try
{
LUCOut ob = new LUCOut();
SqlParameter[] Parameters =
{
new SqlParameter("@id", id),
};
var res = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.Text, "SELECT * from vwLUCEDIT where SNo=@id", Parameters);
if (res != null && res.Tables[0].Rows.Count > 0)
{
ob = res.Tables[0].AsEnumerable().Select(e => new LUCOut
{
Bucr = Convert.ToBoolean(e["IsUCR"]),
Buhf = Convert.ToBoolean(e["IsUHF"]),
hdnOriginator = e["Originator"].ToString(),
Text_Name = e["RepresentativeName"].ToString(),
Text_MobileNo = e["MobileNo"].ToString(),
Text_IDNumber = e["IDNumber"].ToString()
}).FirstOrDefault();
}
return(ob);
}
catch (Exception ex)//
{
throw ex;
}
}
public string SaveDetails(LUCOut obj)
{
try
{
DataSet ds = new DataSet();
var time = obj.Text_Receiveddate + " " + obj.Text_ReceivedTime;
DateTime startdate = DateTime.Parse(time, new CultureInfo("en-us"));
List <string> str = new List <string>();
SqlParameter[] Parameters = { new SqlParameter("@SNo", obj.ULD),
new SqlParameter("@ReturnDateTime", startdate),
new SqlParameter("@ReturnBy", 1),
new SqlParameter("@ReturnRemarks", obj.Text_Remarks),
new SqlParameter("@ReturnLocationCitySNo", obj.AirportSNo),
new SqlParameter("@LUCInNumber", obj.Text_LUCInNumber),
new SqlParameter("@UpdatedBy", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session ["UserDetail"])).UserSNo.ToString()),
new SqlParameter("@ODLNCodeSNo", obj.ODLNCode),
new SqlParameter("@ReceivedUserSno", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo),
new SqlParameter("@IssuedFrom", obj.IssuedFrom.Trim()),
new SqlParameter("@Process", obj.INPOUTProcessStatus.Trim()),
new SqlParameter("@CurrCity", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session ["UserDetail"])).CityCode.ToString()),
new SqlParameter("@AirrPort", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session ["UserDetail"])).AirportSNo.ToString()),
new SqlParameter("@ISDamge", obj.ISDamge == "true"?"1":"0"),
new SqlParameter("@DamagedRemarks", obj.DamagedRemarks), };
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "CreateLucIn", Parameters);
return(ds.Tables[0].Rows[0][0].ToString());
}
catch (Exception ex)//
{
throw ex;
}
}
