public static void UpdateStewardshipInfo(OrganizationInfo objOrg, ContactInfo objPrimaryContact, Phones objPrimaryContactBusinessPhone, Phones objPrimaryContactCellPhone, ContactInfo objBillingContact, Phones objBillingContactBusinessPhone, Phones objBillingContactCellPhone, Organization_Address objBusinessOrganization_Address, Organization_Address objMailingOrganization_Address)
        {
            try
            {
                using (DbManager DB = DbManager.GetDbManager())
                {
                    List<SqlParameter> prm = new List<SqlParameter>();

                    #region Organization Info

                    if (objOrg.OrganizationId > 0)
                        prm.Add(DB.MakeInParam("@OrganizationId", SqlDbType.Int, 4, objOrg.OrganizationId));
                    else
                        prm.Add(DB.MakeInParam("@OrganizationId", SqlDbType.Int, 4, DBNull.Value));
                    prm.Add(DB.MakeInParam("@LegalName", SqlDbType.NVarChar, 255, objOrg.LegalName));
                    prm.Add(DB.MakeInParam("@DBAName", SqlDbType.NVarChar, 255, objOrg.DBAName));
                  //  prm.Add(DB.MakeInParam("@OrganizationTypeId", SqlDbType.Int, 4, objOrg.OrganizationTypeId));
                    prm.Add(DB.MakeInParam("@Website", SqlDbType.NVarChar, 255, objOrg.Website));
                  
                   
                    prm.Add(DB.MakeInParam("@OrgIsActive", SqlDbType.Bit, 1, objOrg.IsActive));
                    //prm.Add(DB.MakeInParam("@AcceptTextMessage", SqlDbType.Bit, 1, objOrg.AcceptTextMessages));
                    //prm.Add(DB.MakeInParam("@CellAcceptTextMessages", SqlDbType.Bit, 1, objOrg.CellAcceptTextMessages));
                    prm.Add(DB.MakeInParam("@OrgLanguageId", SqlDbType.Int, 4, objOrg.LanguageId));
                   // prm.Add(DB.MakeInParam("@RoleId", SqlDbType.Int, 4, objOrg.RoleId));

                    #endregion

                    #region Primary Contact Info

                   // prm.Add(DB.MakeInParam("@PrimaryContactTypeId", SqlDbType.Int, 4, objPrimaryContact.ContactTypeId));
                    prm.Add(DB.MakeInParam("@PrimaryContactFirstName", SqlDbType.NVarChar, 255, objPrimaryContact.FirstName));
                    prm.Add(DB.MakeInParam("@PrimaryContactLastName", SqlDbType.NVarChar, 255, objPrimaryContact.LastName));
                  //  prm.Add(DB.MakeInParam("@PrimaryContactTitleId", SqlDbType.Int, 4, objPrimaryContact.ContactTitleId));
                    prm.Add(DB.MakeInParam("@PrimaryContactEmail", SqlDbType.NVarChar, 200, objPrimaryContact.Email));
                    prm.Add(DB.MakeInParam("@PrimaryContactIsActive", SqlDbType.Bit, 1, objPrimaryContact.IsActive));
                    prm.Add(DB.MakeInParam("@PrimaryContactIsPrimary", SqlDbType.Bit, 1, objPrimaryContact.IsPrimary));
                   // prm.Add(DB.MakeInParam("@PrimaryContactLanguageId", SqlDbType.Int, 4, objPrimaryContact.LanguageId));

                    #endregion

                    #region Primary Contact Business Phone Info

                    prm.Add(DB.MakeInParam("@PrimaryContactBusinessPhoneNumber", SqlDbType.NVarChar, 15, objPrimaryContactBusinessPhone.Number));
                    prm.Add(DB.MakeInParam("@PrimaryContactBusinessPhoneExtension", SqlDbType.NVarChar, 7, objPrimaryContactBusinessPhone.Extension));
                  //  prm.Add(DB.MakeInParam("@PrimaryContactBusinessPhoneTypeId", SqlDbType.Int, 4, objPrimaryContactBusinessPhone.PhoneTypeId));
                    prm.Add(DB.MakeInParam("@PrimaryContactBusinessPhoneIsActive", SqlDbType.Bit, 1, objPrimaryContactBusinessPhone.IsActive));

                    #endregion

                    //#region Primary Contact Cell Phone Info

                    //prm.Add(DB.MakeInParam("@PrimaryContactCellPhoneNumber", SqlDbType.NVarChar, 15, objPrimaryContactCellPhone.Number));
                    //prm.Add(DB.MakeInParam("@PrimaryContactCellPhoneIsAcceptTextMessages", SqlDbType.Bit, 1, objPrimaryContactCellPhone.IsAcceptTextMessages));
                    //prm.Add(DB.MakeInParam("@PrimaryContactCellPhoneTypeId", SqlDbType.Int, 4, objPrimaryContactCellPhone.PhoneTypeId));
                    //prm.Add(DB.MakeInParam("@PrimaryContactCellPhoneIsActive", SqlDbType.Bit, 1, objPrimaryContactCellPhone.IsActive));

                    //#endregion

                    //#region Billing Contact Info

                    //prm.Add(DB.MakeInParam("@BillingContactTypeId", SqlDbType.Int, 4, objBillingContact.ContactTypeId));
                    //prm.Add(DB.MakeInParam("@BillingContactFirstName", SqlDbType.NVarChar, 255, objBillingContact.FirstName));
                    //prm.Add(DB.MakeInParam("@BillingContactLastName", SqlDbType.NVarChar, 255, objBillingContact.LastName));
                    //prm.Add(DB.MakeInParam("@BillingContactTitleId", SqlDbType.Int, 4, objBillingContact.ContactTitleId));
                    //prm.Add(DB.MakeInParam("@BillingContactEmail", SqlDbType.NVarChar, 200, objBillingContact.Email));
                    //prm.Add(DB.MakeInParam("@BillingContactIsActive", SqlDbType.Bit, 1, objBillingContact.IsActive));
                    //prm.Add(DB.MakeInParam("@BillingContactIsPrimary", SqlDbType.Bit, 1, objBillingContact.IsPrimary));
                    //prm.Add(DB.MakeInParam("@BillingContactLanguageId", SqlDbType.Int, 4, objBillingContact.LanguageId));

                    //#endregion

                    //#region Billing Contact Business Phone Info

                    //prm.Add(DB.MakeInParam("@BillingContactBusinessPhoneNumber", SqlDbType.NVarChar, 15, objBillingContactBusinessPhone.Number));
                    //prm.Add(DB.MakeInParam("@BillingContactBusinessPhoneExtension", SqlDbType.NVarChar, 7, objBillingContactBusinessPhone.Extension));
                    //prm.Add(DB.MakeInParam("@BillingContactBusinessPhoneTypeId", SqlDbType.Int, 4, objBillingContactBusinessPhone.PhoneTypeId));
                    //prm.Add(DB.MakeInParam("@BillingContactBusinessPhoneIsActive", SqlDbType.Bit, 1, objBillingContactBusinessPhone.IsActive));

                    //#endregion

                    //#region Billing Contact Cell Phone Info

                    //prm.Add(DB.MakeInParam("@BillingContactCellPhoneNumber", SqlDbType.NVarChar, 15, objBillingContactCellPhone.Number));
                    //prm.Add(DB.MakeInParam("@BillingContactCellPhoneIsAcceptTextMessages", SqlDbType.Bit, 1, objBillingContactCellPhone.IsAcceptTextMessages));
                    //prm.Add(DB.MakeInParam("@BillingContactCellPhoneTypeId", SqlDbType.Int, 4, objBillingContactCellPhone.PhoneTypeId));
                    //prm.Add(DB.MakeInParam("@BillingContactCellPhoneIsActive", SqlDbType.Bit, 1, objBillingContactCellPhone.IsActive));

                    //#endregion

                    #region Business Organization Address Info

                    prm.Add(DB.MakeInParam("@BusinessOrganization_AddressZipCodeId", SqlDbType.Int, 4, objBusinessOrganization_Address.ZipCodeID));
                    prm.Add(DB.MakeInParam("@BusinessOrganization_AddressZipCode", SqlDbType.NVarChar, 100, objBusinessOrganization_Address.ZipPostalCode));
                    prm.Add(DB.MakeInParam("@BusinessOrganizationAddress1", SqlDbType.NVarChar, 250, objBusinessOrganization_Address.Address1));
                    prm.Add(DB.MakeInParam("@BusinessOrganizationAddress2", SqlDbType.NVarChar, 250, objBusinessOrganization_Address.Address2));
                    prm.Add(DB.MakeInParam("@BusinessOrganization_AddressCity", SqlDbType.NVarChar, 100, objBusinessOrganization_Address.City));
                    prm.Add(DB.MakeInParam("@BusinessOrganization_AddressStateId", SqlDbType.Int, 4, objBusinessOrganization_Address.StateID));
                    prm.Add(DB.MakeInParam("@BusinessOrganization_AddressCountryID", SqlDbType.Int, 4, objBusinessOrganization_Address.CountryID));
                    prm.Add(DB.MakeInParam("@BusinessOrganization_AddressIsActive", SqlDbType.Bit, 1, objBusinessOrganization_Address.IsActive));
                    prm.Add(DB.MakeInParam("@BusinessOrganization_AddressDateCreated", SqlDbType.DateTime, 8, objBusinessOrganization_Address.DateCreated));
                    prm.Add(DB.MakeInParam("@BusinessOrganization_AddressTypeId", SqlDbType.Int, 4, objBusinessOrganization_Address.Organization_AddressTypeId));

                    #endregion

                    //#region Mailing Organization Address Info

                    //prm.Add(DB.MakeInParam("@MailingOrganization_AddressZipCodeId", SqlDbType.Int, 4, objMailingOrganization_Address.ZipCodeID));
                    //prm.Add(DB.MakeInParam("@MailingOrganization_AddressZipCode", SqlDbType.NVarChar, 100, objMailingOrganization_Address.ZipPostalCode));
                    //prm.Add(DB.MakeInParam("@MailingOrganizationAddress1", SqlDbType.NVarChar, 250, objMailingOrganization_Address.Address1));
                    //prm.Add(DB.MakeInParam("@MailingOrganizationAddress2", SqlDbType.NVarChar, 250, objMailingOrganization_Address.Address2));
                    //prm.Add(DB.MakeInParam("@MailingOrganization_AddressCity", SqlDbType.NVarChar, 100, objMailingOrganization_Address.City));
                    //prm.Add(DB.MakeInParam("@MailingOrganization_AddressStateId", SqlDbType.Int, 4, objMailingOrganization_Address.StateID));
                    //prm.Add(DB.MakeInParam("@MailingOrganization_AddressCountryID", SqlDbType.Int, 4, objMailingOrganization_Address.CountryID));
                    //prm.Add(DB.MakeInParam("@MailingOrganization_AddressIsActive", SqlDbType.Bit, 1, objMailingOrganization_Address.IsActive));
                    //prm.Add(DB.MakeInParam("@MailingOrganization_AddressDateCreated", SqlDbType.DateTime, 8, objMailingOrganization_Address.DateCreated));
                    //prm.Add(DB.MakeInParam("@MailingOrganization_AddressTypeId", SqlDbType.Int, 4, objMailingOrganization_Address.Organization_AddressTypeId));

                    //#endregion

                    objOrg.OrganizationId = DB.RunProc("up_updateStewardshipByOrgId", prm.ToArray());
                }
            }
            catch (Exception ex)
            {
                new SqlLog().InsertSqlLog(0, "OrganizationInfo.UpdateStewardshipInfo", ex);
            }
        }
		public static void SavePrimaryInfo(OrganizationInfo objOrg, ContactInfo objPrimaryContact, Phones objPrimaryContactBusinessPhone, 
            Phones objPrimaryContactCellPhone, ContactInfo objBillingContact, Phones objBillingContactBusinessPhone, Phones objBillingContactCellPhone, 
            Organization_Address objBusinessOrganization_Address, Organization_Address objMailingOrganization_Address, string catIds)
		{
			try
			{
				using (DbManager DB = DbManager.GetDbManager())
				{
					List<SqlParameter> prm = new List<SqlParameter>();

					#region Organization Info

					if (objOrg.OrganizationId > 0)
						prm.Add(DB.MakeInParam("@OrganizationId", SqlDbType.Int, 4, objOrg.OrganizationId));
					else
						prm.Add(DB.MakeInParam("@OrganizationId", SqlDbType.Int, 4, DBNull.Value));
					prm.Add(DB.MakeInParam("@LegalName", SqlDbType.NVarChar, 255, objOrg.LegalName));
					prm.Add(DB.MakeInParam("@DBAName", SqlDbType.NVarChar, 255, objOrg.DBAName));
					prm.Add(DB.MakeInParam("@OrganizationTypeId", SqlDbType.Int, 4, objOrg.OrganizationTypeId));
                    prm.Add(DB.MakeInParam("@OrganizationSubTypeId", SqlDbType.Int, 0, objOrg.OrganizationSubTypeID));
					prm.Add(DB.MakeInParam("@Website", SqlDbType.NVarChar, 255, objOrg.Website));
					prm.Add(DB.MakeInParam("@AccountingInterfaceId", SqlDbType.Int, 4, objOrg.AccountingInterfaceId));
					prm.Add(DB.MakeInParam("@InventoryInterfaceId", SqlDbType.Int, 4, objOrg.InventoryInterfaceId));
					prm.Add(DB.MakeInParam("@IsAutoFundTransfer", SqlDbType.Bit, 1, objOrg.IsAutoFundTransfer));
					prm.Add(DB.MakeInParam("@OrgIsActive", SqlDbType.Bit, 1, objOrg.IsActive));
					prm.Add(DB.MakeInParam("@OrgLanguageId", SqlDbType.Int, 4, objOrg.LanguageId));
					prm.Add(DB.MakeInParam("@RoleId", SqlDbType.Int, 4, objOrg.RoleId));

					#endregion

					#region Primary Contact Info

					prm.Add(DB.MakeInParam("@PrimaryContactTypeId", SqlDbType.Int, 4, objPrimaryContact.ContactTypeId));
					prm.Add(DB.MakeInParam("@PrimaryContactFirstName", SqlDbType.NVarChar, 255, objPrimaryContact.FirstName));
					prm.Add(DB.MakeInParam("@PrimaryContactLastName", SqlDbType.NVarChar, 255, objPrimaryContact.LastName));
					prm.Add(DB.MakeInParam("@PrimaryContactTitleId", SqlDbType.Int, 4, objPrimaryContact.ContactTitleId));
					prm.Add(DB.MakeInParam("@PrimaryContactEmail", SqlDbType.NVarChar, 200, objPrimaryContact.Email));
					prm.Add(DB.MakeInParam("@PrimaryContactIsActive", SqlDbType.Bit, 1, objPrimaryContact.IsActive));
					prm.Add(DB.MakeInParam("@PrimaryContactIsPrimary", SqlDbType.Bit, 1, objPrimaryContact.IsPrimary));
					prm.Add(DB.MakeInParam("@PrimaryContactLanguageId", SqlDbType.Int, 4, objPrimaryContact.LanguageId));

					#endregion

					#region Primary Contact Business Phone Info

					prm.Add(DB.MakeInParam("@PrimaryContactBusinessPhoneNumber", SqlDbType.NVarChar, 15, objPrimaryContactBusinessPhone.Number));
					prm.Add(DB.MakeInParam("@PrimaryContactBusinessPhoneExtension", SqlDbType.NVarChar, 7, objPrimaryContactBusinessPhone.Extension));
					prm.Add(DB.MakeInParam("@PrimaryContactBusinessPhoneTypeId", SqlDbType.Int, 4, objPrimaryContactBusinessPhone.PhoneTypeId));
					prm.Add(DB.MakeInParam("@PrimaryContactBusinessPhoneIsActive", SqlDbType.Bit, 1, objPrimaryContactBusinessPhone.IsActive));

					#endregion

					#region Primary Contact Cell Phone Info

					prm.Add(DB.MakeInParam("@PrimaryContactCellPhoneNumber", SqlDbType.NVarChar, 15, objPrimaryContactCellPhone.Number));
					prm.Add(DB.MakeInParam("@PrimaryContactCellPhoneIsAcceptTextMessages", SqlDbType.Bit, 1, objPrimaryContactCellPhone.IsAcceptTextMessages));
					prm.Add(DB.MakeInParam("@PrimaryContactCellPhoneTypeId", SqlDbType.Int, 4, objPrimaryContactCellPhone.PhoneTypeId));
					prm.Add(DB.MakeInParam("@PrimaryContactCellPhoneIsActive", SqlDbType.Bit, 1, objPrimaryContactCellPhone.IsActive));

					#endregion

					#region Billing Contact Info

					prm.Add(DB.MakeInParam("@BillingContactTypeId", SqlDbType.Int, 4, objBillingContact.ContactTypeId));
					prm.Add(DB.MakeInParam("@BillingContactFirstName", SqlDbType.NVarChar, 255, objBillingContact.FirstName));
					prm.Add(DB.MakeInParam("@BillingContactLastName", SqlDbType.NVarChar, 255, objBillingContact.LastName));
					prm.Add(DB.MakeInParam("@BillingContactTitleId", SqlDbType.Int, 4, objBillingContact.ContactTitleId));
					prm.Add(DB.MakeInParam("@BillingContactEmail", SqlDbType.NVarChar, 200, objBillingContact.Email));
					prm.Add(DB.MakeInParam("@BillingContactIsActive", SqlDbType.Bit, 1, objBillingContact.IsActive));
					prm.Add(DB.MakeInParam("@BillingContactIsPrimary", SqlDbType.Bit, 1, objBillingContact.IsPrimary));
					prm.Add(DB.MakeInParam("@BillingContactLanguageId", SqlDbType.Int, 4, objBillingContact.LanguageId));

					#endregion

					#region Billing Contact Business Phone Info

					prm.Add(DB.MakeInParam("@BillingContactBusinessPhoneNumber", SqlDbType.NVarChar, 15, objBillingContactBusinessPhone.Number));
					prm.Add(DB.MakeInParam("@BillingContactBusinessPhoneExtension", SqlDbType.NVarChar, 7, objBillingContactBusinessPhone.Extension));
					prm.Add(DB.MakeInParam("@BillingContactBusinessPhoneTypeId", SqlDbType.Int, 4, objBillingContactBusinessPhone.PhoneTypeId));
					prm.Add(DB.MakeInParam("@BillingContactBusinessPhoneIsActive", SqlDbType.Bit, 1, objBillingContactBusinessPhone.IsActive));

					#endregion

					#region Billing Contact Cell Phone Info

					prm.Add(DB.MakeInParam("@BillingContactCellPhoneNumber", SqlDbType.NVarChar, 15, objBillingContactCellPhone.Number));
					prm.Add(DB.MakeInParam("@BillingContactCellPhoneIsAcceptTextMessages", SqlDbType.Bit, 1, objBillingContactCellPhone.IsAcceptTextMessages));
					prm.Add(DB.MakeInParam("@BillingContactCellPhoneTypeId", SqlDbType.Int, 4, objBillingContactCellPhone.PhoneTypeId));
					prm.Add(DB.MakeInParam("@BillingContactCellPhoneIsActive", SqlDbType.Bit, 1, objBillingContactCellPhone.IsActive));

					#endregion

					#region Business Organization Address Info

					prm.Add(DB.MakeInParam("@BusinessOrganization_AddressZipCodeId", SqlDbType.Int, 4, objBusinessOrganization_Address.ZipCodeID));
					prm.Add(DB.MakeInParam("@BusinessOrganization_AddressZipCode", SqlDbType.NVarChar, 100, objBusinessOrganization_Address.ZipPostalCode));
					prm.Add(DB.MakeInParam("@BusinessOrganizationAddress1", SqlDbType.NVarChar, 250, objBusinessOrganization_Address.Address1));
					prm.Add(DB.MakeInParam("@BusinessOrganizationAddress2", SqlDbType.NVarChar, 250, objBusinessOrganization_Address.Address2));
					prm.Add(DB.MakeInParam("@BusinessOrganization_AddressCity", SqlDbType.NVarChar, 100, objBusinessOrganization_Address.City));
					prm.Add(DB.MakeInParam("@BusinessOrganization_AddressStateId", SqlDbType.Int, 4, objBusinessOrganization_Address.StateID));
					prm.Add(DB.MakeInParam("@BusinessOrganization_AddressCountryID", SqlDbType.Int, 4, objBusinessOrganization_Address.CountryID));
                    prm.Add(DB.MakeInParam("@BusinessOrganization_CityId", SqlDbType.BigInt, 10, objBusinessOrganization_Address.CityId));
					prm.Add(DB.MakeInParam("@BusinessOrganization_AddressIsActive", SqlDbType.Bit, 1, objBusinessOrganization_Address.IsActive));
					prm.Add(DB.MakeInParam("@BusinessOrganization_AddressDateCreated", SqlDbType.DateTime, 8, objBusinessOrganization_Address.DateCreated));
					prm.Add(DB.MakeInParam("@BusinessOrganization_AddressTypeId", SqlDbType.Int, 4, objBusinessOrganization_Address.Organization_AddressTypeId));

					#endregion

					#region Mailing Organization Address Info

					prm.Add(DB.MakeInParam("@MailingOrganization_AddressZipCodeId", SqlDbType.Int, 4, objMailingOrganization_Address.ZipCodeID));
					prm.Add(DB.MakeInParam("@MailingOrganization_AddressZipCode", SqlDbType.NVarChar, 100, objMailingOrganization_Address.ZipPostalCode));
					prm.Add(DB.MakeInParam("@MailingOrganizationAddress1", SqlDbType.NVarChar, 250, objMailingOrganization_Address.Address1));
					prm.Add(DB.MakeInParam("@MailingOrganizationAddress2", SqlDbType.NVarChar, 250, objMailingOrganization_Address.Address2));
					prm.Add(DB.MakeInParam("@MailingOrganization_AddressCity", SqlDbType.NVarChar, 100, objMailingOrganization_Address.City));
                    prm.Add(DB.MakeInParam("@MailingOrganization_CityId", SqlDbType.BigInt, 10, objMailingOrganization_Address.CityId));
					prm.Add(DB.MakeInParam("@MailingOrganization_AddressStateId", SqlDbType.Int, 4, objMailingOrganization_Address.StateID));
					prm.Add(DB.MakeInParam("@MailingOrganization_AddressCountryID", SqlDbType.Int, 4, objMailingOrganization_Address.CountryID));
					prm.Add(DB.MakeInParam("@MailingOrganization_AddressIsActive", SqlDbType.Bit, 1, objMailingOrganization_Address.IsActive));
					prm.Add(DB.MakeInParam("@MailingOrganization_AddressDateCreated", SqlDbType.DateTime, 8, objMailingOrganization_Address.DateCreated));
					prm.Add(DB.MakeInParam("@MailingOrganization_AddressTypeId", SqlDbType.Int, 4, objMailingOrganization_Address.Organization_AddressTypeId));

					#endregion

                    //For making application generalized
                    prm.Add(DB.MakeInParam("@CategoryIds", SqlDbType.VarChar, 50, catIds));

					objOrg.OrganizationId = DB.RunProc("up_OrganizationInsertUpdatePrimaryInfo", prm.ToArray());
				}
			}
			catch (Exception ex)
			{
				new SqlLog().InsertSqlLog(0, "OrganizationInfo.SaveBasicInfo", ex);
			}
		}
		public static void SaveAdditionalLocationInfo(OrganizationInfo objOrg, ContactInfo objPrimaryContact, Phones objPrimaryContactBusinessPhone, Phones objPrimaryContactCellPhone, OrganizationInfo.Organization_Address objBusinessOrganization_Address)
		{
			try
			{
				using (DbManager DB = DbManager.GetDbManager())
				{
					List<SqlParameter> prm = new List<SqlParameter>();

					#region Organization Info

					prm.Add(DB.MakeInParam("@LegalName", SqlDbType.NVarChar, 255, objOrg.LegalName));
					prm.Add(DB.MakeInParam("@DBAName", SqlDbType.NVarChar, 255, objOrg.DBAName));
					prm.Add(DB.MakeInParam("@IsLocationEventPermanent", SqlDbType.Bit, 1, objOrg.IsLocationEventPermanent));

					if (objOrg.IsLocationEventPermanent == false)
					{
						prm.Add(DB.MakeInParam("@LocationEventStartDate", SqlDbType.DateTime, 8, objOrg.LocationEventStartDate));
						prm.Add(DB.MakeInParam("@LocationEventEndDate", SqlDbType.DateTime, 8, objOrg.LocationEventEndDate));
						prm.Add(DB.MakeInParam("@LocationEventTypeId", SqlDbType.Int, 4, objOrg.LocationEventTypeId));
					}
					else
					{
						prm.Add(DB.MakeInParam("@LocationEventStartDate", SqlDbType.DateTime, 8, DBNull.Value));
						prm.Add(DB.MakeInParam("@LocationEventEndDate", SqlDbType.DateTime, 8, DBNull.Value));
						prm.Add(DB.MakeInParam("@LocationEventTypeId", SqlDbType.Int, 4, DBNull.Value));
					}

					prm.Add(DB.MakeInParam("@LocationPermitNumber", SqlDbType.NVarChar, 255, objOrg.LocationPermitNumber));
					prm.Add(DB.MakeInParam("@OrgIsActive", SqlDbType.Bit, 1, objOrg.IsActive));
					prm.Add(DB.MakeInParam("@OrgLanguageId", SqlDbType.Int, 4, objOrg.LanguageId));
					prm.Add(DB.MakeInParam("@ParentId", SqlDbType.Int, 4, objOrg.ParentId));

					#endregion

					#region Primary Contact Info

					prm.Add(DB.MakeInParam("@PrimaryContactTypeId", SqlDbType.Int, 4, objPrimaryContact.ContactTypeId));
					prm.Add(DB.MakeInParam("@PrimaryContactFirstName", SqlDbType.NVarChar, 255, objPrimaryContact.FirstName));
					prm.Add(DB.MakeInParam("@PrimaryContactLastName", SqlDbType.NVarChar, 255, objPrimaryContact.LastName));
					prm.Add(DB.MakeInParam("@PrimaryContactTitleId", SqlDbType.Int, 4, objPrimaryContact.ContactTitleId));
					prm.Add(DB.MakeInParam("@PrimaryContactEmail", SqlDbType.NVarChar, 200, objPrimaryContact.Email));
					prm.Add(DB.MakeInParam("@PrimaryContactIsActive", SqlDbType.Bit, 1, objPrimaryContact.IsActive));
					prm.Add(DB.MakeInParam("@PrimaryContactIsPrimary", SqlDbType.Bit, 1, objPrimaryContact.IsPrimary));
					prm.Add(DB.MakeInParam("@PrimaryContactLanguageId", SqlDbType.Int, 4, objPrimaryContact.LanguageId));

					#endregion

					#region Primary Contact Business Phone Info

					prm.Add(DB.MakeInParam("@PrimaryContactBusinessPhoneNumber", SqlDbType.NVarChar, 15, objPrimaryContactBusinessPhone.Number));
					prm.Add(DB.MakeInParam("@PrimaryContactBusinessPhoneExtension", SqlDbType.NVarChar, 7, objPrimaryContactBusinessPhone.Extension));
					prm.Add(DB.MakeInParam("@PrimaryContactBusinessPhoneTypeId", SqlDbType.Int, 4, objPrimaryContactBusinessPhone.PhoneTypeId));
					prm.Add(DB.MakeInParam("@PrimaryContactBusinessPhoneIsActive", SqlDbType.Bit, 1, objPrimaryContactBusinessPhone.IsActive));

					#endregion

					#region Primary Contact Cell Phone Info

					prm.Add(DB.MakeInParam("@PrimaryContactCellPhoneNumber", SqlDbType.NVarChar, 15, objPrimaryContactCellPhone.Number));
					prm.Add(DB.MakeInParam("@PrimaryContactCellPhoneIsAcceptTextMessages", SqlDbType.Bit, 1, objPrimaryContactCellPhone.IsAcceptTextMessages));
					prm.Add(DB.MakeInParam("@PrimaryContactCellPhoneTypeId", SqlDbType.Int, 4, objPrimaryContactCellPhone.PhoneTypeId));
					prm.Add(DB.MakeInParam("@PrimaryContactCellPhoneIsActive", SqlDbType.Bit, 1, objPrimaryContactCellPhone.IsActive));

					#endregion

					#region Business Organization Address Info

					prm.Add(DB.MakeInParam("@BusinessOrganization_AddressZipCodeId", SqlDbType.Int, 4, objBusinessOrganization_Address.ZipCodeID));
					prm.Add(DB.MakeInParam("@BusinessOrganization_AddressZipCode", SqlDbType.NVarChar, 100, objBusinessOrganization_Address.ZipPostalCode));
					prm.Add(DB.MakeInParam("@BusinessOrganizationAddress1", SqlDbType.NVarChar, 250, objBusinessOrganization_Address.Address1));
					prm.Add(DB.MakeInParam("@BusinessOrganizationAddress2", SqlDbType.NVarChar, 250, objBusinessOrganization_Address.Address2));
					prm.Add(DB.MakeInParam("@BusinessOrganization_AddressCity", SqlDbType.NVarChar, 100, objBusinessOrganization_Address.City));
					prm.Add(DB.MakeInParam("@BusinessOrganization_AddressStateId", SqlDbType.Int, 4, objBusinessOrganization_Address.StateID));
					prm.Add(DB.MakeInParam("@BusinessOrganization_AddressCountryID", SqlDbType.Int, 4, objBusinessOrganization_Address.CountryID));
					prm.Add(DB.MakeInParam("@BusinessOrganization_AddressIsActive", SqlDbType.Bit, 1, objBusinessOrganization_Address.IsActive));
					prm.Add(DB.MakeInParam("@BusinessOrganization_AddressDateCreated", SqlDbType.DateTime, 8, objBusinessOrganization_Address.DateCreated));
					prm.Add(DB.MakeInParam("@BusinessOrganization_AddressTypeId", SqlDbType.Int, 4, objBusinessOrganization_Address.Organization_AddressTypeId));

					#endregion

					objOrg.OrganizationId = DB.RunProc("up_OrganizationAdditionalLocationAdd", prm.ToArray());
				}
			}
			catch (Exception ex)
			{
				new SqlLog().InsertSqlLog(0, "OrganizationInfo.SaveAdditionalLocationInfo", ex);
			}
		}
		public static void SaveBasicInfo(OrganizationInfo ObjOrg, ContactInfo objContactInfo, Phones objPhones)
		{
			try
			{
				using (DbManager DB = DbManager.GetDbManager())
				{
					List<SqlParameter> prm = new List<SqlParameter>();

					if (ObjOrg.OrganizationId > 0)
						prm.Add(DB.MakeInParam("@OrganizationId", SqlDbType.Int, 4, ObjOrg.OrganizationId));
					else
						prm.Add(DB.MakeInParam("@OrganizationId", SqlDbType.Int, 4, DBNull.Value));

					prm.Add(DB.MakeInParam("@LegalName", SqlDbType.NVarChar, 255, ObjOrg.LegalName));
					prm.Add(DB.MakeInParam("@DBAName", SqlDbType.NVarChar, 255, ObjOrg.DBAName));
					prm.Add(DB.MakeInParam("@FranchiseName", SqlDbType.NVarChar, 255, ObjOrg.FranchiseName));
					if(ObjOrg.BusinessType != null)
						prm.Add(DB.MakeInParam("@BusinessType", SqlDbType.VarChar, -1, String.Join<int>(",", ObjOrg.BusinessType)));
					else
						prm.Add(DB.MakeInParam("@BusinessType", SqlDbType.VarChar, -1, DBNull.Value));
					prm.Add(DB.MakeInParam("@OrgIsActive", SqlDbType.Bit, 1, ObjOrg.IsActive));
					prm.Add(DB.MakeInParam("@OrganizationTypeId", SqlDbType.Int, 4, ObjOrg.OrganizationTypeId));
                    prm.Add(DB.MakeInParam("@OrganizationSubTypeId", SqlDbType.Int, 4, ObjOrg.OrganizationSubTypeID));
					prm.Add(DB.MakeInParam("@ParentId", SqlDbType.Int, 4, ObjOrg.ParentId));
					prm.Add(DB.MakeInParam("@Website", SqlDbType.NVarChar, 255, ObjOrg.Website));
					prm.Add(DB.MakeInParam("@TX_ID", SqlDbType.NVarChar, 90, ObjOrg.TX_ID));
					prm.Add(DB.MakeInParam("@OrgLanguageId", SqlDbType.Int, 4, ObjOrg.LanguageId));
					prm.Add(DB.MakeInParam("@AgencyType", SqlDbType.Int, 4, ObjOrg.AgencyType));
					prm.Add(DB.MakeInParam("@RoleId", SqlDbType.Int, 4, ObjOrg.RoleId));

					prm.Add(DB.MakeInParam("@PhoneId", SqlDbType.Int, 4, objPhones.PhoneId));
					prm.Add(DB.MakeInParam("@Number", SqlDbType.NVarChar, 15, objPhones.Number));
					prm.Add(DB.MakeInParam("@Extension", SqlDbType.NVarChar, 7, objPhones.Extension));
					prm.Add(DB.MakeInParam("@PhoneTypeId", SqlDbType.Int, 4, objPhones.PhoneTypeId));
					prm.Add(DB.MakeInParam("@PhoneIsActive", SqlDbType.Bit, 1, objPhones.IsActive));

					prm.Add(DB.MakeInParam("@ContactId", SqlDbType.Int, 4, objContactInfo.ContactId));
					prm.Add(DB.MakeInParam("@ContactTypeId", SqlDbType.Int, 4, objContactInfo.ContactTypeId));
					prm.Add(DB.MakeInParam("@FirstName", SqlDbType.NVarChar, 30, objContactInfo.FirstName));
					prm.Add(DB.MakeInParam("@MiddleName", SqlDbType.NVarChar, 10, objContactInfo.MiddleName));
					prm.Add(DB.MakeInParam("@LastName", SqlDbType.NVarChar, 30, objContactInfo.LastName));
					prm.Add(DB.MakeInParam("@Email", SqlDbType.NVarChar, 90, objContactInfo.Email));
					prm.Add(DB.MakeInParam("@IsPrimary", SqlDbType.Bit, 1, objContactInfo.IsPrimary));
					prm.Add(DB.MakeInParam("@ContactIsActive", SqlDbType.Bit, 1, objContactInfo.IsActive));
					prm.Add(DB.MakeInParam("@ContactLanguageId", SqlDbType.Int, 4, objContactInfo.LanguageId));

					//prm.Add(DB.MakeInParam("@LocationID", SqlDbType.Int, 4, ObjOrg.LocationID));
					//prm.Add(DB.MakeInParam("@Description", SqlDbType.NVarChar, 100, ObjOrg.Description));
					//prm.Add(DB.MakeInParam("@Address", SqlDbType.NVarChar, 250, ObjOrg.Address));
					//prm.Add(DB.MakeInParam("@City", SqlDbType.NVarChar, 100, ObjOrg.City));
					//prm.Add(DB.MakeInParam("@StateId", SqlDbType.Int, 4, ObjOrg.StateID));
					//prm.Add(DB.MakeInParam("@CountryID", SqlDbType.Int, 4, ObjOrg.CountryID));
					//prm.Add(DB.MakeInParam("@ZipPostalCode", SqlDbType.NVarChar, 100, ObjOrg.ZipPostalCode));
					//prm.Add(DB.MakeInParam("@AddressIsActive", SqlDbType.Bit, 1, ObjOrg.IsActive));
					//prm.Add(DB.MakeInParam("@DateCreated", SqlDbType.DateTime, 8, ObjOrg.DateCreated));
					//prm.Add(DB.MakeInParam("@BillMailAddress", SqlDbType.NVarChar, 250, ObjOrg.BillMailAddress));
					//prm.Add(DB.MakeInParam("@OwnerManager", SqlDbType.NVarChar, 50, ObjOrg.OwnerManager));
					//prm.Add(DB.MakeInParam("@BilingContact", SqlDbType.NVarChar, 50, ObjOrg.BillingContact));
					//prm.Add(DB.MakeInParam("@Fax", SqlDbType.NVarChar, 20, ObjOrg.Fax));

					ObjOrg.OrganizationId = DB.RunProc("up_OrganizationInsertUpdateBasicInfo", prm.ToArray());
				}
			}
			catch (Exception ex)
			{
				new SqlLog().InsertSqlLog(0, "OrganizationInfo.SaveBasicInfo", ex);
			}
		}