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; } }