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