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