private string BL_Update_Booking_Conatiner_Status_Client(EL_CMS.EL_Schedule ES) { string rtnmsg = ""; SqlCommand cmd = new SqlCommand(); cmd.Connection = gc.cn; if (cmd.Connection.State == ConnectionState.Closed) { cmd.Connection.Open(); } cmd.CommandText = "Update_Booking_Conatiner_Status_Client_SP"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@containername", ES.CountainerID); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { rtnmsg = dr["rtnMsg"].ToString(); } dr.Close(); cmd.Connection.Close(); return(rtnmsg); }
private string BL_Add_Available_BookingContainer(EL_CMS.EL_Schedule ES) { string rtnmsg = ""; SqlCommand cmd = new SqlCommand(); cmd.Connection = gc.cn; if (cmd.Connection.State == ConnectionState.Closed) { cmd.Connection.Open(); } cmd.CommandText = "Add_Container_SP"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@uid", ES.UID); cmd.Parameters.AddWithValue("@username", ES.Username); cmd.Parameters.AddWithValue("@countryname", ES.Countryname); cmd.Parameters.AddWithValue("@countryzone", ES.CountryZone); cmd.Parameters.AddWithValue("@containerID", ES.CountainerID); cmd.Parameters.AddWithValue("@requestDate", ES.ArrivalDate); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { rtnmsg = dr["rtnMsg"].ToString(); } dr.Close(); cmd.Connection.Close(); return(rtnmsg); }
private DataTable BL_View_AviableContainer(EL_CMS.EL_Schedule ES) { SqlCommand cmd = new SqlCommand(); cmd.Connection = gc.cn; if (cmd.Connection.State == ConnectionState.Closed) { cmd.Connection.Open(); } cmd.CommandText = "View_Container_Information_SP"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@containerId", ES.CID); SqlDataReader dr = cmd.ExecuteReader(); DataTable dt = new DataTable(); if (dr.HasRows) { dt.Load(dr); } dr.Close(); cmd.Connection.Close(); return(dt); }
public string View_BookingContainer_By_UID() { string G_xml = getRequestStreamData(); JavaScriptSerializer js = new JavaScriptSerializer(); var obj = js.Deserialize <Dictionary <string, string> >(G_xml); EL_CMS.EL_Schedule ES = new EL_CMS.EL_Schedule(); ES.UID = obj["uid"]; return(bl.BL_JSON_View_BookingContainer_By_UID(ES)); }
public string Update_Booking_Conatiner_Status_Client() { string G_xml = getRequestStreamData(); JavaScriptSerializer js = new JavaScriptSerializer(); var obj = js.Deserialize <Dictionary <string, string> >(G_xml); EL_CMS.EL_Schedule ES = new EL_CMS.EL_Schedule(); ES.CountainerID = obj["containerName"]; return(bl.BL_JSON_Update_Booking_Conatiner_Status_Client(ES)); }
public string Cancel_Available_BookingContainer() { string G_xml = getRequestStreamData(); JavaScriptSerializer js = new JavaScriptSerializer(); var obj = js.Deserialize <Dictionary <string, string> >(G_xml); EL_CMS.EL_Schedule ES = new EL_CMS.EL_Schedule(); ES.CountainerID = obj["containerName"]; return(bl.BL_JSON_Cancel_Available_BookingContainer(ES)); }
public string View_AviableContainer_CounZone() { string G_xml = getRequestStreamData(); JavaScriptSerializer js = new JavaScriptSerializer(); var obj = js.Deserialize <Dictionary <string, string> >(G_xml); EL_CMS.EL_Schedule ES = new EL_CMS.EL_Schedule(); ES.CID = obj["s_CUID"]; return(bl.BL_JSON_View_AviableContainer(ES)); }
public string Add_Available_BookingContainer() { string G_xml = getRequestStreamData(); JavaScriptSerializer js = new JavaScriptSerializer(); var obj = js.Deserialize <Dictionary <string, string> >(G_xml); EL_CMS.EL_Schedule ES = new EL_CMS.EL_Schedule(); ES.UID = obj["uid"]; ES.Username = obj["username"]; ES.Countryname = obj["countryname"]; ES.CountryZone = obj["countryzone"]; ES.CountainerID = obj["containerID"]; ES.ArrivalDate = obj["requestDate"]; return(bl.BL_JSON_Add_Available_BookingContainer(ES)); }
public string BL_JSON_View_AviableContainer(EL_CMS.EL_Schedule ES) { DataTable PNCL_Dt = this.BL_View_AviableContainer(ES); return(ConvertDataTabletoString(PNCL_Dt)); }
public string BL_JSON_Update_Booking_Conatiner_Status_Client(EL_CMS.EL_Schedule ES) { string PNCL_Dt = this.BL_Update_Booking_Conatiner_Status_Client(ES); return(PNCL_Dt); }
public string BL_JSON_Cancel_Available_BookingContainer(EL_CMS.EL_Schedule ES) { string PNCL_Dt = this.Cancel_Available_BookingContainer(ES); return(PNCL_Dt); }