public static int VoyageLandingDateEntry(int vesselId, int voyageId, int Pod, DateTime?LandingDate, DateTime?OldLandingDate, int UserId) { string ProcName = "prcVoyageLandingDateEntry"; DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName); dquery.AddIntegerParam("@UserId", UserId); dquery.AddIntegerParam("@vesselId", vesselId); dquery.AddIntegerParam("@voyageId", voyageId); dquery.AddDateTimeParam("@LandingDate", LandingDate); dquery.AddDateTimeParam("@OldLandingDate", OldLandingDate); dquery.AddIntegerParam("@Pod", Pod); return(dquery.RunActionQuery()); }
public static DateTime TranshipmentStatus(int ExpBLId, ref bool VoyageStatus, ref int CountID) { DateTime Result; string TempString; bool ClsVoyage = false; int Count = 0; string ProcName = "[exp].[prcTranshipmentStatus]"; DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName); dquery.AddIntegerParam("@ExpBLId", ExpBLId); dquery.AddDateTimeParam("@RESULT", null, QueryParameterDirection.Output); dquery.AddBooleanParam("@closeVoyage", ClsVoyage, QueryParameterDirection.Output); dquery.AddIntegerParam("@CountID", Count, QueryParameterDirection.Output); dquery.RunActionQuery(); TempString = Convert.ToString(dquery.GetParaValue("@Result")); if (TempString == null || TempString == "") { Result = default(DateTime); } else { Result = Convert.ToDateTime(dquery.GetParaValue("@Result")); } //Result = Convert.ToDateTime(dquery.GetParaValue("@SailDate")); VoyageStatus = Convert.ToBoolean(dquery.GetParaValue("@CloseVoyage")); CountID = Convert.ToInt32(dquery.GetParaValue("@CountID")); return(Result); }
public int AddEditVoyage(int userID, bool isEdit, EMS.Entity.VoyageEntity voyage) { string ProcName = "prcAddEditVoyage"; DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName); dquery.AddIntegerParam("@userID", userID); dquery.AddBooleanParam("@isEdit", isEdit); dquery.AddIntegerParam("@pk_VoyageID", voyage.pk_VoyageID); dquery.AddIntegerParam("@fk_VesselID", voyage.fk_VesselID); dquery.AddIntegerParam("@fl_TerminalID", voyage.fl_TerminalID); dquery.AddVarcharParam("@VoyageNo", 10, voyage.VoyageNo); dquery.AddDecimalParam("@ImpXChangeRate", 6, 2, voyage.ImpXChangeRate); dquery.AddVarcharParam("@IGMNo", 10, voyage.IGMNo); //dquery.AddVarcharParam("@CallSign", 14, voyage.CallSign); dquery.AddDateTimeParam("@IGMDate", voyage.IGMDate); dquery.AddDateTimeParam("@LandingDate", voyage.LandingDate); dquery.AddDateTimeParam("@ETADate", voyage.ETADate); dquery.AddDateTimeParam("@AddLandingDate", voyage.AddLandingDate); dquery.AddDateTimeParam("@PCCDate", voyage.PCCDate); dquery.AddVarcharParam("@PCCNo", 14, voyage.PCCNo); dquery.AddVarcharParam("@VoyageType", 1, "I"); dquery.AddIntegerParam("@fk_LPortID", voyage.fk_LPortID); dquery.AddIntegerParam("@fk_LPortID1", voyage.fk_LPortID1); dquery.AddIntegerParam("@fk_LPortID2", voyage.fk_LPortID2); dquery.AddVarcharParam("@LGNo", 40, voyage.LGNo); dquery.AddVarcharParam("@AltLGNo", 40, voyage.AltLGNo); dquery.AddVarcharParam("@VesselType", 1, voyage.VesselType); dquery.AddVarcharParam("@MotherDaughterDtl", 500, voyage.MotherDaughterDtl); dquery.AddVarcharParam("@TotalLines", 5, voyage.TotalLines); dquery.AddVarcharParam("@CargoDesc", 50, voyage.CargoDesc); dquery.AddVarcharParam("@VIANo", 10, voyage.VIANo); dquery.AddVarcharParam("@VCN", 14, voyage.VCN); dquery.AddVarcharParam("@ETATime", 7, voyage.ETATime); dquery.AddIntegerParam("@LightHouseDue", voyage.LightHouseDue); dquery.AddBooleanParam("@SameButtonCargo", voyage.SameButtonCargo == "1" ? true : false); dquery.AddBooleanParam("@ShipStoreSubmitted", voyage.ShipStoreSubmitted == "1" ? true : false); dquery.AddBooleanParam("@CrewList", voyage.CrewList == "1" ? true : false); dquery.AddBooleanParam("@PassengerList", voyage.PassengerList == "1" ? true : false); dquery.AddBooleanParam("@CrewEffectList", voyage.CrewEffectList == "1" ? true : false); dquery.AddBooleanParam("@MaritimeList", voyage.MaritimeList == "1" ? true : false); dquery.AddIntegerParam("@LocId", voyage.locid); dquery.AddIntegerParam("@fk_pod", voyage.fk_Pod); return(dquery.RunActionQuery()); }
public DataSet GetSTax(int pk_StaxID, DateTime? StartDate) { string ProcName = "admin.prcGetSTax"; DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName); dquery.AddIntegerParam("@pk_StaxID", pk_StaxID); dquery.AddDateTimeParam("@StartDate", StartDate); return dquery.GetTables(); }
public DataSet GetSTaxDate(DateTime? Startdt) { string ProcName = "admin.prcGetSTaxDate"; DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName); dquery.AddDateTimeParam("@StartDate", Startdt); return dquery.GetTables(); }
public int AddEditSTax(int userID, int pk_StaxID, DateTime?StartDate, decimal TaxAddCess, decimal TaxCess, decimal TaxPer, bool TaxStatus, bool isEdit) { string ProcName = "admin.prcAddEditSTax"; DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName); dquery.AddIntegerParam("@userID", userID); dquery.AddIntegerParam("@pk_StaxID", pk_StaxID); dquery.AddDateTimeParam("@StartDate", StartDate); dquery.AddDecimalParam("@TaxAddCess", 6, 2, TaxAddCess); dquery.AddDecimalParam("@TaxCess", 6, 2, TaxCess); dquery.AddDecimalParam("@TaxPer", 6, 2, TaxPer); dquery.AddBooleanParam("@TaxStatus", TaxStatus); dquery.AddBooleanParam("@isEdit", isEdit); return(dquery.RunActionQuery()); }
public int InvoiceDateCheck(DateTime dt) { DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery("prcInvoiceDateCheck"); dquery.AddDateTimeParam("@StaxDate", dt); return(Convert.ToInt32(dquery.GetScalar())); }
public decimal GetExchnageRate(DateTime dt) { DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery("prcGetExchnageRate"); dquery.AddDateTimeParam("@Exdate", dt); return(Convert.ToDecimal(dquery.GetScalar())); }