//--------------------------------------------------------------------------
public int Insert()
{
try
{
SqlCommand cmd = new SqlCommand("TourDetailPriceInsert");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Tour_ID", this.Tour_ID));
cmd.Parameters.Add(new SqlParameter("@TourDetailPrice_ArrivalDate", this.TourDetailPrice_ArrivalDate));
cmd.Parameters.Add(new SqlParameter("@TourDetailPrice_DepartureDate", this.TourDetailPrice_DepartureDate));
cmd.Parameters.Add(new SqlParameter("@TourDetailPrice_NumberPrice1", this.TourDetailPrice_NumberPrice1));
cmd.Parameters.Add(new SqlParameter("@TourDetailPrice_Price1", this.TourDetailPrice_Price1));
cmd.Parameters.Add(new SqlParameter("@TourDetailPrice_NumberPrice2", this.TourDetailPrice_NumberPrice2));
cmd.Parameters.Add(new SqlParameter("@TourDetailPrice_Price2", this.TourDetailPrice_Price2));
cmd.Parameters.Add(new SqlParameter("@TourDetailPrice_NumberPrice3", this.TourDetailPrice_NumberPrice3));
cmd.Parameters.Add(new SqlParameter("@TourDetailPrice_Price3", this.TourDetailPrice_Price3));
cmd.Parameters.Add("@TourDetailPrice_ID", SqlDbType.Int).Direction = ParameterDirection.Output;
db.ExecuteSQL(cmd);
this.TourDetailPrice_ID = (cmd.Parameters["@TourDetailPrice_ID"].Value == null) ? 0 : Convert.ToInt32(cmd.Parameters["@TourDetailPrice_ID"].Value);
return(this.TourDetailPrice_ID);
}
catch (Exception ex)
{
throw ex;
}
}
//--------------------------------------------------------------------------
public int Insert()
{
try
{
SqlCommand cmd = new SqlCommand("RoomHotelInsert");
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add(new SqlParameter("@RoomHotel_Title", this.RoomHotel_Title));
cmd.Parameters.Add(new SqlParameter("@Hotel_ID", this.Hotel_ID));
cmd.Parameters.Add(new SqlParameter("@RoomHotel_Type", this.RoomHotel_Type));
cmd.Parameters.Add(new SqlParameter("@RoomHotel_Image", this.RoomHotel_Image));
cmd.Parameters.Add(new SqlParameter("@RoomHotel_Extensions", this.RoomHotel_Extensions));
cmd.Parameters.Add(new SqlParameter("@RoomHotel_View", this.RoomHotel_View));
cmd.Parameters.Add(new SqlParameter("@RoomHotel_Bed", this.RoomHotel_Bed));
cmd.Parameters.Add(new SqlParameter("@RoomHotel_Acreage", this.RoomHotel_Acreage));
cmd.Parameters.Add(new SqlParameter("@RoomHotel_Adutls", this.RoomHotel_Adutls));
cmd.Parameters.Add(new SqlParameter("@RoomHotel_Infants", this.RoomHotel_Infants));
cmd.Parameters.Add(new SqlParameter("@Hotel_TimeZone", this.Hotel_TimeZone));
cmd.Parameters.Add(new SqlParameter("@Hotel_Price", this.Hotel_Price));
cmd.Parameters.Add(new SqlParameter("@Hotel_PriceSale", this.Hotel_PriceSale));
cmd.Parameters.Add(new SqlParameter("@Hotel_Qty", this.Hotel_Qty));
cmd.Parameters.Add("@RoomHotel_ID", SqlDbType.Int).Direction = ParameterDirection.Output;
db.ExecuteSQL(cmd);
this.RoomHotel_ID = (cmd.Parameters["@RoomHotel_ID"].Value == null) ? 0 : Convert.ToInt32(cmd.Parameters["@RoomHotel_ID"].Value);
return(this.Hotel_ID);
}
catch (Exception ex)
{
throw ex;
}
}
//--------------------------------------------------------------------------
public int Insert()
{
try
{
SqlCommand cmd = new SqlCommand("UserInsert");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Location_Name", this.User_Name));
cmd.Parameters.Add(new SqlParameter("@User_transactionName", this.User_transactionName));
cmd.Parameters.Add(new SqlParameter("@Birthday", this.Birthday));
cmd.Parameters.Add(new SqlParameter("@User_Image", this.User_Image));
cmd.Parameters.Add(new SqlParameter("@User_Address", this.User_Address));
cmd.Parameters.Add(new SqlParameter("@User_Email", this.User_Email));
cmd.Parameters.Add(new SqlParameter("@User_Phone", this.User_Phone));
cmd.Parameters.Add(new SqlParameter("@User_Pass", this.User_Pass));
cmd.Parameters.Add(new SqlParameter("@User_Active", this.User_Active));
cmd.Parameters.Add(new SqlParameter("@User_Role", this.User_Role));
cmd.Parameters.Add(new SqlParameter("@User_InternalStaff", this.User_InternalStaff));
cmd.Parameters.Add(new SqlParameter("@Agents_ID", this.Agents_ID));
cmd.Parameters.Add("@User_ID", SqlDbType.Int).Direction = ParameterDirection.Output;
db.ExecuteSQL(cmd);
this.User_ID = (cmd.Parameters["@User_ID"].Value == null) ? 0 : Convert.ToInt32(cmd.Parameters["@User_ID"].Value);
return(this.User_ID);
}
catch (Exception ex)
{
throw ex;
}
}
//--------------------------------------------------------------------------
public int Insert()
{
try
{
SqlCommand cmd = new SqlCommand("HotelInsert");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Hotel_Name", this.Hotel_Name));
cmd.Parameters.Add(new SqlParameter("@Hotel_Location", this.Hotel_Location));
cmd.Parameters.Add(new SqlParameter("@Hotel_Address", this.Hotel_Address));
cmd.Parameters.Add(new SqlParameter("@Hotel_Content", this.Hotel_Content));
cmd.Parameters.Add(new SqlParameter("@HotelImage", this.HotelImage));
cmd.Parameters.Add(new SqlParameter("@Hotel_StarRate", this.Hotel_StarRate));
cmd.Parameters.Add(new SqlParameter("@Hotel_ListImage", this.Hotel_ListImage));
cmd.Parameters.Add(new SqlParameter("@Product_ID", this.Product_ID));
cmd.Parameters.Add(new SqlParameter("@UserCreate", this.UserCreate));
cmd.Parameters.Add(new SqlParameter("@Hotel_CreateDate", this.Hotel_CreateDate));
cmd.Parameters.Add(new SqlParameter("@Hotel_RulesRefund", this.Hotel_RulesRefund));
cmd.Parameters.Add("@Hotel_ID", SqlDbType.Int).Direction = ParameterDirection.Output;
db.ExecuteSQL(cmd);
this.Hotel_ID = (cmd.Parameters["@Hotel_ID"].Value == null) ? 0 : Convert.ToInt32(cmd.Parameters["@Hotel_ID"].Value);
return(this.Hotel_ID);
}
catch (Exception ex)
{
throw ex;
}
}
//--------------------------------------------------------------------------
public int Insert()
{
try
{
SqlCommand cmd = new SqlCommand("PostInsert");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Post_Tile", this.Post_Title));
cmd.Parameters.Add(new SqlParameter("@Post_Type", this.Post_Type));
cmd.Parameters.Add(new SqlParameter("@Post_Description", this.Post_Description));
cmd.Parameters.Add(new SqlParameter("@Post_Content", this.Post_Content));
cmd.Parameters.Add(new SqlParameter("@Post_CreateDate", this.Post_CreateDate));
cmd.Parameters.Add(new SqlParameter("@Post_UpdateDate", this.Post_UpdateDate));
cmd.Parameters.Add(new SqlParameter("@Post_Images", this.Post_Images));
cmd.Parameters.Add(new SqlParameter("@Post_CategoryID", this.Post_CategoryID));
cmd.Parameters.Add(new SqlParameter("@Post_Slug", this.Post_Slug));
cmd.Parameters.Add(new SqlParameter("@Post_tag", this.Post_tag));
cmd.Parameters.Add(new SqlParameter("@Post_UserID", this.Post_UserID));
cmd.Parameters.Add(new SqlParameter("@Post_Location", this.Post_Location));
cmd.Parameters.Add("@Post_id", SqlDbType.Int).Direction = ParameterDirection.Output;
db.ExecuteSQL(cmd);
this.Post_id = (cmd.Parameters["@Post_id"].Value == null) ? 0 : Convert.ToInt32(cmd.Parameters["@Post_id"].Value);
return(this.Post_id);
}
catch (Exception ex)
{
throw ex;
}
}
//--------------------------------------------------------------------------
public int Insert()
{
try
{
SqlCommand cmd = new SqlCommand("PostCategoryInsert");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@PostCategory_Title", this.PostCategory_Title));
cmd.Parameters.Add("@PostCategory_ID", SqlDbType.Int).Direction = ParameterDirection.Output;
db.ExecuteSQL(cmd);
this.PostCategory_ID = (cmd.Parameters["@PostCategory_ID"].Value == null) ? 0 : Convert.ToInt32(cmd.Parameters["@PostCategory_ID"].Value);
return(this.PostCategory_ID);
}
catch (Exception ex)
{
throw ex;
}
}
//--------------------------------------------------------------------------
public int Insert()
{
try
{
SqlCommand cmd = new SqlCommand("UserRolesInsert");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@UserRoleName", this.UserRoleName));
cmd.Parameters.Add(new SqlParameter("@UserRoleDescription", this.UserRoleDescription));
cmd.Parameters.Add("@UserRoleID", SqlDbType.Int).Direction = ParameterDirection.Output;
db.ExecuteSQL(cmd);
this.UserRoleID = (cmd.Parameters["@UserRoleID"].Value == null) ? 0 : Convert.ToInt32(cmd.Parameters["@UserRoleID"].Value);
return(this.UserRoleID);
}
catch (Exception ex)
{
throw ex;
}
}
public int Insert()
{
try
{
SqlCommand cmd = new SqlCommand("ConfigInfomationInsert");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Config_Field", this.Config_Field));
cmd.Parameters.Add(new SqlParameter("@Config_Title", this.Config_Title));
cmd.Parameters.Add(new SqlParameter("@Config_Value", this.Config_Value));
cmd.Parameters.Add("@Config_id", SqlDbType.Int).Direction = ParameterDirection.Output;
db.ExecuteSQL(cmd);
this.Config_id = (cmd.Parameters["@Config_id"].Value == null) ? 0 : Convert.ToInt32(cmd.Parameters["@Config_id"].Value);
return(this.Config_id);
}
catch (Exception ex)
{
throw ex;
}
}
//--------------------------------------------------------------------------
public int Insert()
{
try
{
SqlCommand cmd = new SqlCommand("ContactInfoInsert");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ContactInfo_Name", this.ContactInfo_Name));
cmd.Parameters.Add(new SqlParameter("@ContactInfo_Address", this.ContactInfo_Address));
cmd.Parameters.Add(new SqlParameter("@ContactInfo_Email", this.ContactInfo_Email));
cmd.Parameters.Add(new SqlParameter("@ContactInfo_Phone", this.ContactInfo_Phone));
cmd.Parameters.Add("@ContactInfo_ID", SqlDbType.Int).Direction = ParameterDirection.Output;
db.ExecuteSQL(cmd);
this.ContactInfo_ID = (cmd.Parameters["@ContactInfo_ID"].Value == null) ? 0 : Convert.ToInt32(cmd.Parameters["@ContactInfo_ID"].Value);
return(this.ContactInfo_ID);
}
catch (Exception ex)
{
throw ex;
}
}
//--------------------------------------------------------------------------
public int Insert()
{
try
{
SqlCommand cmd = new SqlCommand("Hotel_EvaluateInsert");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Hotel_ID", this.Hotel_ID));
cmd.Parameters.Add(new SqlParameter("@CreateBy", this.CreateBy));
cmd.Parameters.Add(new SqlParameter("@Created", this.Created));
cmd.Parameters.Add(new SqlParameter("@Score", this.Score));
cmd.Parameters.Add(new SqlParameter("@Content", this.Content));
cmd.Parameters.Add("@Hotel_Evaluate_ID", SqlDbType.Int).Direction = ParameterDirection.Output;
db.ExecuteSQL(cmd);
this.Hotel_Evaluate_ID = (cmd.Parameters["@Hotel_Evaluate_ID"].Value == null) ? 0 : Convert.ToInt32(cmd.Parameters["@Hotel_Evaluate_ID"].Value);
return(this.Hotel_Evaluate_ID);
}
catch (Exception ex)
{
throw ex;
}
}
//--------------------------------------------------------------------------
public int Insert()
{
try
{
SqlCommand cmd = new SqlCommand("TourInsert");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Hotel_ID", this.Hotel_ID));
cmd.Parameters.Add(new SqlParameter("@Tour_Name", this.Tour_Name));
cmd.Parameters.Add(new SqlParameter("@Tour_Location", this.Tour_Location));
cmd.Parameters.Add(new SqlParameter("@Tour_OrganizationalUnit", this.Tour_OrganizationalUnit));
cmd.Parameters.Add(new SqlParameter("@Tour_DepartureDate", this.Tour_DepartureDate));
cmd.Parameters.Add(new SqlParameter("@Tour_TimeZone", this.Tour_TimeZone));
cmd.Parameters.Add(new SqlParameter("@Tour_Price", this.Tour_Price));
cmd.Parameters.Add(new SqlParameter("@Tour_Description", this.Tour_Description));
cmd.Parameters.Add(new SqlParameter("@Tour_Content", this.Tour_Content));
cmd.Parameters.Add(new SqlParameter("@Tour_Itinerary", this.Tour_Itinerary));
cmd.Parameters.Add(new SqlParameter("@Tour_Schedule", this.Tour_Schedule));
cmd.Parameters.Add(new SqlParameter("@Tour_Rules", this.Tour_Rules));
cmd.Parameters.Add(new SqlParameter("@Tour_ListImage", this.Tour_ListImage));
cmd.Parameters.Add(new SqlParameter("@Tour_Image", this.Tour_Image));
cmd.Parameters.Add(new SqlParameter("@Product_ID", this.Product_ID));
cmd.Parameters.Add(new SqlParameter("@Tour_Fixed", this.Tour_Fixed));
cmd.Parameters.Add(new SqlParameter("@UserCreate", this.UserCreate));
cmd.Parameters.Add(new SqlParameter("@CreateDate", this.CreateDate));
cmd.Parameters.Add(new SqlParameter("@Tour_Active", this.Tour_Active));
cmd.Parameters.Add(new SqlParameter("@Tour_Topic", this.Tour_Topic));
cmd.Parameters.Add(new SqlParameter("@Tour_StarRate", this.Tour_StarRate));
cmd.Parameters.Add(new SqlParameter("@Tour_Qty", this.Tour_Qty));
cmd.Parameters.Add(new SqlParameter("@Tour_Score", this.Tour_Score));
cmd.Parameters.Add(new SqlParameter("@Tour_PriceSale", this.Tour_PriceSale));
cmd.Parameters.Add("@Tour_ID", SqlDbType.Int).Direction = ParameterDirection.Output;
db.ExecuteSQL(cmd);
this.Tour_ID = (cmd.Parameters["@Tour_ID"].Value == null) ? 0 : Convert.ToInt32(cmd.Parameters["@Tour_ID"].Value);
return(this.Tour_ID);
}
catch (Exception ex)
{
throw ex;
}
}
//--------------------------------------------------------------------------
public int Insert()
{
try
{
SqlCommand cmd = new SqlCommand("SetupMailSMTPInsert");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@SetupMailSMTP_Email", this.SetupMailSMTP_Email));
cmd.Parameters.Add(new SqlParameter("@SetupMailSMTP_Password", this.SetupMailSMTP_Password));
cmd.Parameters.Add(new SqlParameter("@SetupMailSMTP_Host", this.SetupMailSMTP_Host));
cmd.Parameters.Add(new SqlParameter("@SetupMailSMTP_Port", this.SetupMailSMTP_Port));
cmd.Parameters.Add(new SqlParameter("@SetupMailSMTP_SSL", this.SetupMailSMTP_SSL));
cmd.Parameters.Add(new SqlParameter("@SetupMailSMTP_Header", this.SetupMailSMTP_Header));
cmd.Parameters.Add(new SqlParameter("@SetupMailSMTP_Footer", this.SetupMailSMTP_Footer));
cmd.Parameters.Add(new SqlParameter("@Agents_ID", this.Agents_ID));
cmd.Parameters.Add("@SetupMailSMTP_ID", SqlDbType.Int).Direction = ParameterDirection.Output;
db.ExecuteSQL(cmd);
this.SetupMailSMTP_ID = (cmd.Parameters["@SetupMailSMTP_ID"].Value == null) ? 0 : Convert.ToInt32(cmd.Parameters["@SetupMailSMTP_ID"].Value);
return(this.SetupMailSMTP_ID);
}
catch (Exception ex)
{
throw ex;
}
}