test.cs

gistfile1.txt

public string TourPackageEnquiry(string Occasion, string DepartingFrom, string TravellingTo, string DepartingDate, string ReturningDate, int NoofAdults, int NoofChild, int NoofInfants, int NoOfNights, string CustomerCommunicationMode, string Name, string HomeOfNo, string MobileNo, string Preferedcallbacktime, string Email, string AdditionalComments, int FromWebsite, int FromMarketingMedium, string Dealrefference, string Howdidknow, string DealUrl, double FromPrice)
        {

            //int EnquiryTypeId = 6;
            string GeneratingRefferenceNo = string.Empty;
            string RefferenceNoNew = string.Empty;
            string FinalRef = "";
            string recv_email = Email;
            string[] split_email = recv_email.Split('@');
            string email_domain_name = split_email[1].ToString();
            string[] split_domain = (email_domain_name.ToString()).Split('.');
            string isTcukDomain = split_domain[0].ToString();


            SqlConnection sqlConnection = new SqlConnection(ConnectionString);
            sqlConnection.Open();

            GeneratingRefferenceNo = erpUtl.RefGenerator();
            string queryforeference = "select reference_no from enquiry_master";


            SqlDataAdapter dataAdapter = new SqlDataAdapter(queryforeference, sqlConnection);
            DataTable datatable = new DataTable("temptable");
            dataAdapter.Fill(datatable);

            foreach (DataRow dr in datatable.Rows)
            {
                if (dr["reference_no"].ToString() == GeneratingRefferenceNo)
                {
                    RefferenceNoNew = erpUtl.RefGenerator();
                    break;
                }
                else
                {
                    RefferenceNoNew = GeneratingRefferenceNo;
                }
                RefferenceNo = RefferenceNoNew;
            }

            string Auth = ServiceAuthHeaderValidation.Validate(Credentials);
            if (Auth == "Pass")
            {
                SqlCommand command = new SqlCommand("dbo.TourPackageEnquiry", sqlConnection);
                command.CommandType = CommandType.StoredProcedure;
                command.Parameters.Add("@ID", SqlDbType.Int).Direction = ParameterDirection.Output;
                command.Parameters.Add("@EnquirySourceId", SqlDbType.Int).Value = EnquirySourceId;
                command.Parameters.Add("@AssignedStaffNo", SqlDbType.VarChar).Value = AssignedStaffNo;
                command.Parameters.Add("@ReferenceNo", SqlDbType.VarChar).Value = RefferenceNo;
                command.Parameters.Add("@EmpId", SqlDbType.Int).Value = EmployeeId;
                command.Parameters.Add("@StatusId", SqlDbType.Int).Value = StatusId;
                command.Parameters.Add("@Remarks", SqlDbType.VarChar).Value = Occasion; ///
                command.Parameters.Add("@DepartingFrom", SqlDbType.VarChar).Value = DepartingFrom;
                command.Parameters.Add("@TravellingTo", SqlDbType.VarChar).Value = TravellingTo;
                command.Parameters.Add("@DepartingDate", SqlDbType.DateTime).Value = Convert.ToDateTime(DateTime.ParseExact(DepartingDate, "dd-MM-yyyy", CultureInfo.InvariantCulture));
                command.Parameters.Add("@ReturningDate", SqlDbType.DateTime).Value = Convert.ToDateTime(DateTime.ParseExact(ReturningDate, "dd-MM-yyyy", CultureInfo.InvariantCulture));
                command.Parameters.Add("@NoOfAdults", SqlDbType.Int).Value = NoofAdults;
                command.Parameters.Add("@NoOfChild", SqlDbType.Int).Value = NoofChild;
                command.Parameters.Add("@NoOfInfant", SqlDbType.Int).Value = NoofInfants;
                command.Parameters.Add("@AdditionalComments", SqlDbType.VarChar).Value = AdditionalComments;
                command.Parameters.Add("@Name", SqlDbType.VarChar).Value = Name;
                command.Parameters.Add("@HomeofficeNo", SqlDbType.VarChar).Value = HomeOfNo;
                command.Parameters.Add("@MobileNo", SqlDbType.VarChar).Value = MobileNo;
                command.Parameters.Add("@PreferedCallbackTime", SqlDbType.VarChar).Value = Preferedcallbacktime;
                command.Parameters.Add("@Email", SqlDbType.VarChar).Value = Email;
                command.Parameters.Add("@HowDidknow", SqlDbType.VarChar).Value = Howdidknow;
                command.Parameters.Add("@FromWebsite", SqlDbType.Int).Value = FromWebsite;
                command.Parameters.Add("@FromCompaign", SqlDbType.Int).Value = FromMarketingMedium;
                command.Parameters.Add("@DealRefferenceNo", SqlDbType.VarChar).Value = Dealrefference;
                command.Parameters.Add("@DealUrl", SqlDbType.VarChar).Value = DealUrl;
                command.Parameters.Add("@NoOfNights", SqlDbType.Int).Value = NoOfNights; ///
                command.Parameters.Add("@CustomerCommunicationMode", SqlDbType.VarChar).Value = CustomerCommunicationMode; ///
                command.Parameters.Add("@FromPrice", SqlDbType.Money).Value = FromPrice;

                command.Parameters.Add("@EnquiryTypeId", SqlDbType.Int).Value = 6;
                command.Parameters.Add("@Taxes", SqlDbType.Int).Value = 0.00;
                command.Parameters.Add("@TotalPrice", SqlDbType.Money).Value = 0.00;
                command.Parameters.Add("@NoOfCountries", SqlDbType.Int).Value = 0;
                command.Parameters.Add("@StarRating", SqlDbType.Int).Value = 0;
                command.Parameters.Add("@NoOfRooms", SqlDbType.VarChar).Value = 0;
                command.Parameters.Add("@FlightClass", SqlDbType.Int).Value = 0;
                command.Parameters.Add("@Bedding", SqlDbType.Int).Value = 0;
                command.Parameters.Add("@RoomViews", SqlDbType.Int).Value = 0;
                command.Parameters.Add("@BoardBasis", SqlDbType.Int).Value = 0;

                var results = Array.FindAll(stringArray, s => s.Equals(isTcukDomain));
                if (results.Count() > 0)
                {
                    FinalRef = "TEST-XXXXXX";
                }
                else
                {
                    try
                    {
                        int UpdatedOrNot = command.ExecuteNonQuery();
                        int LastInsertid = Convert.ToInt32(command.Parameters["@ID"].Value);
                        string query = "select enquiry_id,reference_no,from_website from enquiry_master where enquiry_id=" + LastInsertid;
                        SqlDataAdapter data = new SqlDataAdapter(query, sqlConnection);
                        DataTable RefferenceDetailTable = new DataTable("tempRefferencetable");
                        data.Fill(RefferenceDetailTable);
                        string UpdatedRefNo = RefferenceDetailTable.Rows[0]["reference_no"].ToString();

                        string SiteID = RefferenceDetailTable.Rows[0]["from_website"].ToString();

                        string query_website = "select website_url,website_code from websites_master where website_id=" + SiteID;
                        SqlDataAdapter data_webmaster = new SqlDataAdapter(query_website, sqlConnection);
                        DataTable WebmasterDetailTable = new DataTable("temp2");
                        data_webmaster.Fill(WebmasterDetailTable);
                        string SiteCode = WebmasterDetailTable.Rows[0]["website_code"].ToString();
                        FinalRef = SiteCode + "-" + UpdatedRefNo;
                    }
                    catch (Exception ex)
                    {

                        throw ex.InnerException;
                    }


                }
                sqlConnection.Close();
                return FinalRef;
            }
            else
            {
                return Auth;
            }
        }