Beispiel #1
0
    public static DataSet Title_Send_To_DB(Admin_State objAdmin_State)
    {
        try
        {
            SqlParameter[] objSqlParameter = new SqlParameter[10];

            objSqlParameter[0] = new SqlParameter("@TitleName", objAdmin_State.TitleName);
            objSqlParameter[1] = new SqlParameter("@TitleId", objAdmin_State.TitleId);
            objSqlParameter[2] = new SqlParameter("@DumpTitleName", objAdmin_State.DumpTitleName);
            objSqlParameter[3] = new SqlParameter("@Isactive", objAdmin_State.Isactive);
            objSqlParameter[4] = new SqlParameter("@CreatedDate", objAdmin_State.CreatedDate);
            objSqlParameter[5] = new SqlParameter("@UserId", objAdmin_State.UserId);

            objSqlParameter[6] = new SqlParameter("@Tag", objAdmin_State.Tag);
            objSqlParameter[7] = new SqlParameter("@Languages", objAdmin_State.Languages);
            objSqlParameter[8] = new SqlParameter("@DumpLanguesIds", objAdmin_State.DumpLanguesIds);
            objSqlParameter[9] = new SqlParameter("@DumpTag", objAdmin_State.DumpTag);

            return(SqlHelper.ExecuteDataSet(con, CommandType.StoredProcedure, "Sp_New_Register", objSqlParameter));
        }
        catch (Exception Ex)
        {
            throw Ex;
        }
    }
Beispiel #2
0
    public static DataSet Artist_Send_To_DB_Details(Admin_State objAdmin_State)
    {
        try
        {
            SqlParameter[] objSqlParameter = new SqlParameter[14];

            objSqlParameter[0] = new SqlParameter("@ArtistName", objAdmin_State.ArtistName);
            objSqlParameter[1] = new SqlParameter("@ArtistId", objAdmin_State.ArtistId);
            objSqlParameter[2] = new SqlParameter("@DumpArtistName", objAdmin_State.DumpArtistName);
            objSqlParameter[3] = new SqlParameter("@Isactive", objAdmin_State.Isactive);
            objSqlParameter[4] = new SqlParameter("@CreatedDate", objAdmin_State.CreatedDate);
            objSqlParameter[5] = new SqlParameter("@UserId", objAdmin_State.UserId);

            objSqlParameter[6]  = new SqlParameter("@Description", objAdmin_State.Description);
            objSqlParameter[7]  = new SqlParameter("@Img", objAdmin_State.Img);
            objSqlParameter[8]  = new SqlParameter("@Gender", objAdmin_State.Gender);
            objSqlParameter[9]  = new SqlParameter("@Interestarea", objAdmin_State.Interestarea);
            objSqlParameter[10] = new SqlParameter("@AId", objAdmin_State.AId);

            objSqlParameter[11] = new SqlParameter("@ContactInformation", objAdmin_State.ContactInformation);
            objSqlParameter[12] = new SqlParameter("@LocationId", objAdmin_State.LocationId);
            objSqlParameter[13] = new SqlParameter("@LanguageId", objAdmin_State.LanguesIds);

            return(SqlHelper.ExecuteDataSet(con, CommandType.StoredProcedure, "Sp_Artist_Details", objSqlParameter));
        }
        catch (Exception Ex)
        {
            throw Ex;
        }
    }
Beispiel #3
0
    public static DataSet State_Send_To_DB(Admin_State objAdmin_State)
    {
        try
        {
            SqlParameter[] objSqlParameter = new SqlParameter[8];

            objSqlParameter[0] = new SqlParameter("@StateName", objAdmin_State.StateName);
            objSqlParameter[1] = new SqlParameter("@StateId", objAdmin_State.StateId);
            objSqlParameter[2] = new SqlParameter("@DumpState", objAdmin_State.DumpState);
            objSqlParameter[3] = new SqlParameter("@Isactive", objAdmin_State.Isactive);
            objSqlParameter[4] = new SqlParameter("@CreatedDate", objAdmin_State.CreatedDate);
            objSqlParameter[5] = new SqlParameter("@UserId", objAdmin_State.UserId);
            objSqlParameter[6] = new SqlParameter("@CountryId", objAdmin_State.CountryId);
            objSqlParameter[7] = new SqlParameter("@DumpCountryId", objAdmin_State.DumpCountryId);

            objSqlParameter[6] = new SqlParameter("@CountryId", objAdmin_State.CountryId);
            objSqlParameter[7] = new SqlParameter("@DumpCountryId", objAdmin_State.DumpCountryId);

            return(SqlHelper.ExecuteDataSet(con, CommandType.StoredProcedure, "Sp_Admin_State", objSqlParameter));
        }
        catch (Exception Ex)
        {
            throw Ex;
        }
    }
Beispiel #4
0
    public void Send_Language_Data(string Language_Name, int Language_Id, string DumpLanguage_Name, bool Isactive)
    {
        try
        {
            if (Language_Name != "")
            {
                if (Session["UserCode"] != null)
                {
                    Admin_State objAdmin_State = new Admin_State();

                    objAdmin_State.LanguageName     = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(Language_Name.ToLower());
                    objAdmin_State.LanguageId       = Language_Id;
                    objAdmin_State.DumpLanguageName = DumpLanguage_Name;
                    objAdmin_State.Isactive         = Isactive;
                    objAdmin_State.CreatedDate      = DateTime.Now.AddHours(Connection.SetHours);
                    objAdmin_State.UserId           = Convert.ToInt32(Session["UserId"].ToString());

                    DataSet objDataSet = Admin_State.Language_Send_To_DB(objAdmin_State);
                    if (objDataSet.Tables[0].Rows[0][0].ToString() == "1")
                    {
                        if (Language_Id == 0)
                        {
                            ShowNotification("Language", "Inserted Successfully..", NotificationType.success);
                            txtLanguage.Text = "";
                            Languages_List(gvLanguage, "select Language_Id,Language_Name,Isactive from tbl_Admin_Language Order by Language_Name");
                        }
                        else
                        {
                            ShowNotification("Language", "Updated Successfully..", NotificationType.success);
                            Languages_List(gvLanguage, "select Language_Id,Language_Name,Isactive from tbl_Admin_Language Order by Language_Name");
                        }
                    }
                    else if (objDataSet.Tables[0].Rows[0][0].ToString() == "-5")
                    {
                        ShowNotification("Language", "Language Already Existed..!", NotificationType.error);
                        if (Language_Id == 0)
                        {
                            txtLanguage.Focus();
                        }
                        else
                        {
                            txtUpdateLanguage.Focus();
                        }
                    }
                    else
                    {
                        ShowNotification("Language", "Not inserted..!", NotificationType.error);
                    }
                }
                else
                {
                    ShowNotification("Language", "Sorry, Your Session had been Expired.. So Please Logout Once & Login Again..!", NotificationType.error);
                }
            }
            else
            {
                ShowNotification("Language", "Please fill all Fields..!", NotificationType.error);
            }
        }
        catch (Exception Ex)
        {
        }
    }
Beispiel #5
0
    public void Send_Artist_Data(string AId, string Artist_Name, int Artist_Id, string DumpArtist_Name, bool Isactive, string Description, string Img, string Gender, string Interestarea, int LocationId, string ContactInformation, string LanguagesIds)
    {
        try
        {
            if (Artist_Name != "" && Description != "" && Interestarea != "")
            {
                if (Session["UserCode"] != null)
                {
                    Admin_State objAdmin_State = new Admin_State();

                    objAdmin_State.ArtistName     = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(Artist_Name.ToLower());
                    objAdmin_State.ArtistId       = Artist_Id;
                    objAdmin_State.DumpArtistName = DumpArtist_Name;
                    objAdmin_State.Isactive       = Isactive;
                    objAdmin_State.CreatedDate    = DateTime.Now.AddHours(Connection.SetHours);
                    objAdmin_State.UserId         = Convert.ToInt32(Session["UserId"].ToString());
                    objAdmin_State.Description    = Description;
                    objAdmin_State.Img            = Img;
                    if (Gender == "True")
                    {
                        objAdmin_State.Gender = "Male";
                    }
                    else
                    {
                        objAdmin_State.Gender = "Female";
                    }
                    objAdmin_State.Interestarea = Interestarea;
                    objAdmin_State.AId          = AId;

                    objAdmin_State.ContactInformation = ContactInformation;
                    objAdmin_State.LocationId         = LocationId.ToString();
                    objAdmin_State.LanguesIds         = LanguagesIds;

                    DataSet objDataSet = Admin_State.Artist_Send_To_DB_Details(objAdmin_State);
                    if (Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString()) >= 0)
                    {
                        if (Artist_Id == 0)
                        {
                            if (Img != "")
                            {
                                fupupdatePhoto.SaveAs(Server.MapPath("~/Artist_Photo/") + "Ar" + objDataSet.Tables[0].Rows[0][0].ToString() + ".jpg");
                            }


                            DropDownList((gvArtist.FooterRow.FindControl("ddlArtist") as DropDownList), "Artist_Id", "Artist_Name", "Select Artist_Id,Artist_Name from tbl_admin_Artist where Isactive='True' Order by Artist_Name", "Select");

                            (gvArtist.FooterRow.FindControl("ddlArtist") as DropDownList).ClearSelection();
                            if ((gvArtist.FooterRow.FindControl("ddlArtist") as DropDownList).Items.FindByValue(ddlUpdateInterestArea.SelectedValue.ToString()) != null)
                            {
                                (gvArtist.FooterRow.FindControl("ddlArtist") as DropDownList).Items.FindByValue(ddlUpdateInterestArea.SelectedValue.ToString()).Selected = true;
                            }

                            //DropDownList((gvArtist.FooterRow.FindControl("ddlAName") as DropDownList), "Artist_Details_Id", "Name", "SELECT Artist_Details_Id,Name FROM tbl_Artist_Details where Interest_Areas=" + (gvArtist.FooterRow.FindControl("ddlArtist") as DropDownList).SelectedValue.ToString() + " Order by Name", "Select");

                            CheckBoxList((gvArtist.FooterRow.FindControl("ddlAName") as ListBox), "Artist_Details_Id", "Name", "SELECT Artist_Details_Id,Name+'$'+'../Artist_Photo/'+Photo as Name FROM tbl_Artist_Details where Interest_Areas=" + (gvArtist.FooterRow.FindControl("ddlArtist") as DropDownList).SelectedValue.ToString() + " Order by Name");

                            (gvArtist.FooterRow.FindControl("ddlAName") as ListBox).ClearSelection();
                            string sss = (Artist_Name + "$../Artist_Photo/" + objDataSet.Tables[0].Rows[0][0].ToString() + ".jpg");
                            if ((gvArtist.FooterRow.FindControl("ddlAName") as ListBox).Items.FindByText((Artist_Name + "$../Artist_Photo/Ar" + objDataSet.Tables[0].Rows[0][0].ToString() + ".jpg")) != null)
                            {
                                (gvArtist.FooterRow.FindControl("ddlAName") as ListBox).Items.FindByText((Artist_Name + "$../Artist_Photo/Ar" + objDataSet.Tables[0].Rows[0][0].ToString() + ".jpg")).Selected = true;
                            }

                            ShowNotification("Artist", "Inserted Successfully..", NotificationType.success);
                            txtUpdateArtist.Text                = "";
                            txtUpdateDescription.Text           = "";
                            ddlUpdateInterestArea.SelectedIndex = 0;
                            ddlLocation.SelectedIndex           = 0;
                            txtContactInformation.Text          = "";
                        }
                        else
                        {
                            ShowNotification("Artist", "Updated Successfully..", NotificationType.success);
                        }
                    }
                    else if (objDataSet.Tables[0].Rows[0][0].ToString() == "-5")
                    {
                        ShowNotification("Artist", "Artist Already Existed..!", NotificationType.error);
                        if (Artist_Id == 0)
                        {
                            txtUpdateArtist.Focus();
                        }
                        else
                        {
                            txtUpdateArtist.Focus();
                        }
                    }
                    else
                    {
                        ShowNotification("Artist", "Not inserted..!", NotificationType.error);
                    }
                }
                else
                {
                    ShowNotification("Artist", "Sorry, Your Session had been Expired.. So Please Logout Once & Login Again..!", NotificationType.error);
                }
            }
            else
            {
                ShowNotification("Artist", "Please fill all Fields..!", NotificationType.error);
            }
        }
        catch (Exception Ex)
        {
        }
    }
Beispiel #6
0
    public void Send_District_Data(int StateId, string District_Name, int District_Id, string DumpDistrict_Name, bool Isactive, int DumpState_Id)
    {
        try
        {
            if (District_Name != "")
            {
                if (Session["UserCode"] != null)
                {
                    Admin_State objAdmin_State = new Admin_State();

                    objAdmin_State.StateId      = StateId;
                    objAdmin_State.DistrictName = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(District_Name.ToLower());
                    objAdmin_State.DumpDistrict = DumpDistrict_Name;
                    objAdmin_State.DistrictId   = District_Id;
                    objAdmin_State.Isactive     = Isactive;
                    objAdmin_State.CreatedDate  = DateTime.Now.AddHours(Connection.SetHours);
                    objAdmin_State.UserId       = Convert.ToInt32(Session["UserId"].ToString());
                    objAdmin_State.DumpSateId   = DumpState_Id;

                    DataSet objDataSet = Admin_State.District_Send_To_DB(objAdmin_State);
                    if (objDataSet.Tables[0].Rows[0][0].ToString() == "1")
                    {
                        if (District_Id == 0)
                        {
                            ShowNotification("District", "Inserted Successfully..", NotificationType.success);
                            Clear_District();
                            if (ddlSearchState.SelectedIndex != 0)
                            {
                                Districts_List(gvDistrict, "select District_Id,District_Name,State_Id,Isactive,(Select State_Name from tbl_admin_state TAS where TAS.State_Id=AD.State_Id)as State_Name from tbl_Admin_District AD where State_Id=" + ddlSearchState.SelectedValue.ToString() + " Order by District_Name");
                            }
                            else
                            {
                                Districts_List(gvDistrict, "select District_Id,District_Name,State_Id,Isactive,(Select State_Name from tbl_admin_state TAS where TAS.State_Id=AD.State_Id)as State_Name from tbl_Admin_District AD Order by District_Name");
                            }
                        }
                        else
                        {
                            ShowNotification("District", "Updated Successfully..", NotificationType.success);
                            //if (txtSearchDistrict.Text != "")
                            //    Districts_List(gvDistrict, "select District_Id,District_Name,State_Id,Isactive,(Select State_Name from tbl_admin_state TAS where TAS.State_Id=AD.State_Id)as State_Name from tbl_Admin_District AD where State_Id=" + ddlSearchState.SelectedValue.ToString() + " and District_Name Like '" + txtSearchDistrict.Text + "%' Order by District_Name");
                            //else
                            if (ddlSearchState.SelectedIndex != 0)
                            {
                                Districts_List(gvDistrict, "select District_Id,District_Name,State_Id,Isactive,(Select State_Name from tbl_admin_state TAS where TAS.State_Id=AD.State_Id)as State_Name from tbl_Admin_District AD where State_Id=" + ddlSearchState.SelectedValue.ToString() + " Order by District_Name");
                            }
                            else
                            {
                                Districts_List(gvDistrict, "select District_Id,District_Name,State_Id,Isactive,(Select State_Name from tbl_admin_state TAS where TAS.State_Id=AD.State_Id)as State_Name from tbl_Admin_District AD Order by District_Name");
                            }
                        }
                    }
                    else if (objDataSet.Tables[0].Rows[0][0].ToString() == "-5")
                    {
                        ShowNotification("District", "District Already Existed..!", NotificationType.error);
                        if (District_Id == 0)
                        {
                            txtDistrict.Focus();
                        }
                        else
                        {
                            txtUpdateDistrict.Focus();
                        }
                    }
                    else
                    {
                        ShowNotification("District", "Not inserted..!", NotificationType.error);
                    }
                }
                else
                {
                    ShowNotification("District", "Sorry, Your Session had been Expired.. So Please Logout Once & Login Again..!", NotificationType.error);
                }
            }
            else
            {
                ShowNotification("District", "Please fill all Fields..!", NotificationType.error);
            }
        }
        catch (Exception Ex)
        {
        }
    }
    public void Send_Title_Data(string Title_Name, int Title_Id, string DumpTitle_Name, bool Isactive, string Tag, string Languages, string Image)
    {
        try
        {
            if (Title_Name != "" && Tag != "" && Languages != "" && Image != "")
            {
                if (Session["UserCode"] != null)
                {
                    Admin_State objAdmin_State = new Admin_State();

                    objAdmin_State.TitleName     = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(Title_Name.ToLower());
                    objAdmin_State.TitleId       = Title_Id;
                    objAdmin_State.DumpTitleName = DumpTitle_Name;
                    objAdmin_State.Isactive      = Isactive;
                    objAdmin_State.CreatedDate   = DateTime.Now.AddHours(Connection.SetHours);
                    objAdmin_State.UserId        = Convert.ToInt32(Session["UserId"].ToString());

                    objAdmin_State.Tag       = Tag;
                    objAdmin_State.Languages = Languages;

                    DataSet objDataSet = Admin_State.Title_Send_To_DB(objAdmin_State);
                    if (Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString()) > 0)
                    {
                        if (Title_Id == 0)
                        {
                            //if (Image != "")
                            //    fupUploadImage.SaveAs(Server.MapPath("~/Video_Images/") + "Reg" + objDataSet.Tables[0].Rows[0][0].ToString() + ".jpg");

                            ShowNotification("Title", "Inserted Successfully..", NotificationType.success);
                            ddlTitle.SelectedIndex    = 0;
                            txtTag.Text               = "";
                            ddlLanguage.SelectedIndex = 0;
                            Titles_List(gvTitle, "select Title_Id,Title_Name,Isactive,Tag,(Select ','+Language_Name from tbl_admin_language where Language_Id in (select val from fn_String_To_Table(Languages,',',1))FOR XML PATH (''))as Languages,Languages as Languages1 from tbl_Register_Title Order by Title_Name");
                        }
                        else
                        {
                            //if (Image != "")
                            //    fupUpdateImage.SaveAs(Server.MapPath("~/Video_Images/") + "Reg" + objDataSet.Tables[0].Rows[0][0].ToString() + ".jpg");

                            ShowNotification("Title", "Updated Successfully..", NotificationType.success);
                            Titles_List(gvTitle, "select Title_Id,Title_Name,Isactive,Tag,(Select ','+Language_Name from tbl_admin_language where Language_Id in (select val from fn_String_To_Table(Languages,',',1))FOR XML PATH (''))as Languages,Languages as Languages1 from tbl_Register_Title Order by Title_Name");
                        }
                    }
                    else if (objDataSet.Tables[0].Rows[0][0].ToString() == "-5")
                    {
                        ShowNotification("Title", "Title Already Existed..!", NotificationType.error);
                        if (Title_Id == 0)
                        {
                            ddlTitle.Focus();
                        }
                        else
                        {
                            txtUpdateTitle.Focus();
                        }
                    }
                    else
                    {
                        ShowNotification("Title", "Not inserted..!", NotificationType.error);
                    }
                }
                else
                {
                    ShowNotification("Title", "Sorry, Your Session had been Expired.. So Please Logout Once & Login Again..!", NotificationType.error);
                }
            }
            else
            {
                ShowNotification("Title", "Please fill all Fields..!", NotificationType.error);
            }
        }
        catch (Exception Ex)
        {
        }
    }
    public void Send_Artist_Data(string AId, string Artist_Name, int Artist_Id, string DumpArtist_Name, bool Isactive, string Description, string Img, string Gender, string Interestarea)
    {
        try
        {
            if (Artist_Name != "" && Description != "" && Interestarea != "")
            {
                if (Session["UserCode"] != null)
                {
                    Admin_State objAdmin_State = new Admin_State();

                    objAdmin_State.ArtistName     = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(Artist_Name.ToLower());
                    objAdmin_State.ArtistId       = Artist_Id;
                    objAdmin_State.DumpArtistName = DumpArtist_Name;
                    objAdmin_State.Isactive       = Isactive;
                    objAdmin_State.CreatedDate    = DateTime.Now.AddHours(Connection.SetHours);
                    objAdmin_State.UserId         = Convert.ToInt32(Session["UserId"].ToString());
                    objAdmin_State.Description    = Description;
                    objAdmin_State.Img            = Img;
                    if (Gender == "true")
                    {
                        objAdmin_State.Gender = "Male";
                    }
                    else
                    {
                        objAdmin_State.Gender = "Female";
                    }
                    objAdmin_State.Interestarea = Interestarea;
                    objAdmin_State.AId          = AId;

                    DataSet objDataSet = Admin_State.Artist_Send_To_DB_Details(objAdmin_State);
                    if (Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString()) >= 0)
                    {
                        if (Artist_Id == 0)
                        {
                            if (Img != "")
                            {
                                fupupdatePhoto.SaveAs(Server.MapPath("~/Artist_Photo/") + "Ar" + objDataSet.Tables[0].Rows[0][0].ToString() + ".jpg");
                            }

                            ShowNotification("Artist", "Inserted Successfully..", NotificationType.success);
                            txtUpdateArtist.Text                = "";
                            txtUpdateDescription.Text           = "";
                            ddlUpdateInterestArea.SelectedIndex = 0;
                        }
                        else
                        {
                            ShowNotification("Artist", "Updated Successfully..", NotificationType.success);
                        }
                    }
                    else if (objDataSet.Tables[0].Rows[0][0].ToString() == "-5")
                    {
                        ShowNotification("Artist", "Artist Already Existed..!", NotificationType.error);
                        if (Artist_Id == 0)
                        {
                            txtUpdateArtist.Focus();
                        }
                        else
                        {
                            txtUpdateArtist.Focus();
                        }
                    }
                    else
                    {
                        ShowNotification("Artist", "Not inserted..!", NotificationType.error);
                    }
                }
                else
                {
                    ShowNotification("Artist", "Sorry, Your Session had been Expired.. So Please Logout Once & Login Again..!", NotificationType.error);
                }
            }
            else
            {
                ShowNotification("Artist", "Please fill all Fields..!", NotificationType.error);
            }
        }
        catch (Exception Ex)
        {
        }
    }
Beispiel #9
0
    public void Send_State_Data(string State_Name, int State_Id, string DumpState_Name, bool Isactive, int DumpCountryId, int CountryId)
    {
        try
        {
            if (State_Name != "")
            {
                if (Session["UserCode"] != null)
                {
                    Admin_State objAdmin_State = new Admin_State();

                    objAdmin_State.StateName     = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(State_Name.ToLower());
                    objAdmin_State.StateId       = State_Id;
                    objAdmin_State.DumpState     = DumpState_Name;
                    objAdmin_State.Isactive      = Isactive;
                    objAdmin_State.CreatedDate   = DateTime.Now.AddHours(Connection.SetHours);
                    objAdmin_State.UserId        = Convert.ToInt32(Session["UserId"].ToString());
                    objAdmin_State.DumpCountryId = DumpCountryId;
                    objAdmin_State.CountryId     = CountryId;

                    DataSet objDataSet = Admin_State.State_Send_To_DB(objAdmin_State);
                    if (objDataSet.Tables[0].Rows[0][0].ToString() == "1")
                    {
                        if (State_Id == 0)
                        {
                            ShowNotification("State", "Inserted Successfully..", NotificationType.success);
                            txtState.Text            = "";
                            ddlCountry.SelectedIndex = 0;
                            States_List(gvState, "select Country_Id,State_Id,State_Name,Isactive,(Select Country_Name from tbl_admin_country AC where AC.Country_Id=S.Country_Id)as Country_Name from tbl_Admin_State S Order by State_Name");
                        }
                        else
                        {
                            ShowNotification("State", "Updated Successfully..", NotificationType.success);
                            States_List(gvState, "select Country_Id,State_Id,State_Name,Isactive,(Select Country_Name from tbl_admin_country AC where AC.Country_Id=S.Country_Id)as Country_Name from tbl_Admin_State S Order by State_Name");
                        }
                    }
                    else if (objDataSet.Tables[0].Rows[0][0].ToString() == "-5")
                    {
                        ShowNotification("State", "State Already Existed..!", NotificationType.error);
                        if (State_Id == 0)
                        {
                            txtState.Focus();
                        }
                        else
                        {
                            txtUpdateState.Focus();
                        }
                    }
                    else
                    {
                        ShowNotification("State", "Not inserted..!", NotificationType.error);
                    }
                }
                else
                {
                    ShowNotification("State", "Sorry, Your Session had been Expired.. So Please Logout Once & Login Again..!", NotificationType.error);
                }
            }
            else
            {
                ShowNotification("State", "Please fill all Fields..!", NotificationType.error);
            }
        }
        catch (Exception Ex)
        {
        }
    }
Beispiel #10
0
    public void Send_Artist_Data(string AId, string Artist_Name, int Artist_Id, string DumpArtist_Name, bool Isactive, string Description, string Img, string Gender, string Interestarea, int LocationId, string ContactInformation, string LanguesIds)
    {
        try
        {
            if (Artist_Name != "" && Description != "" && Interestarea != "" && LocationId != 0 && ContactInformation != "" && LanguesIds != "")
            {
                if (Session["UserCode"] != null)
                {
                    Admin_State objAdmin_State = new Admin_State();

                    objAdmin_State.ArtistName     = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(Artist_Name.ToLower());
                    objAdmin_State.ArtistId       = Artist_Id;
                    objAdmin_State.DumpArtistName = DumpArtist_Name;
                    objAdmin_State.Isactive       = Isactive;
                    objAdmin_State.CreatedDate    = DateTime.Now.AddHours(Connection.SetHours);
                    objAdmin_State.UserId         = Convert.ToInt32(Session["UserId"].ToString());
                    objAdmin_State.Description    = Description;
                    objAdmin_State.Img            = Img;
                    if (Gender == "True")
                    {
                        objAdmin_State.Gender = "Male";
                    }
                    else
                    {
                        objAdmin_State.Gender = "Female";
                    }
                    objAdmin_State.Interestarea = Interestarea;
                    objAdmin_State.AId          = AId;

                    objAdmin_State.ContactInformation = ContactInformation;
                    objAdmin_State.LocationId         = LocationId.ToString();
                    objAdmin_State.LanguesIds         = LanguesIds.ToString();

                    DataSet objDataSet = Admin_State.Artist_Send_To_DB_Details(objAdmin_State);
                    if (Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString()) >= 0)
                    {
                        if (Artist_Id == 0)
                        {
                            if (Img != "")
                            {
                                fupPhoto.SaveAs(Server.MapPath("~/Artist_Photo/") + "Ar" + objDataSet.Tables[0].Rows[0][0].ToString() + ".jpg");
                            }

                            ShowNotification("Artist", "Inserted Successfully..", NotificationType.success);

                            Display_List(lstRecentVideos, "Select Artist_Details_Id,Name,Description,'../Artist_Photo/'+Photo as Photo,Gender,Interest_Areas as Artist_Name,Isactive from tbl_Artist_Details where Isactive='true'and CreatedById=" + Session["UserId"].ToString() + " order by Name");

                            txtName.Text                  = "";
                            txtDescription.Text           = "";
                            ddlInterestArea.SelectedIndex = 0;
                            ddlLocation.SelectedIndex     = 0;
                            txtContactInformation.Text    = "";
                            lstLanguage.ClearSelection();
                        }
                        else
                        {
                            ShowNotification("Artist", "Updated Successfully..", NotificationType.success);
                            Display_List(lstRecentVideos, "Select Artist_Details_Id,Name,Description,'../Artist_Photo/'+Photo as Photo,Gender,Interest_Areas as Artist_Name,Isactive from tbl_Artist_Details where Isactive='true'and CreatedById=" + Session["UserId"].ToString() + " order by Name");
                        }
                    }
                    else if (objDataSet.Tables[0].Rows[0][0].ToString() == "-5")
                    {
                        ShowNotification("Artist", "Artist Already Existed..!", NotificationType.error);
                        if (Artist_Id == 0)
                        {
                            txtName.Focus();
                        }
                        else
                        {
                            txtUpdateArtist.Focus();
                        }
                    }
                    else
                    {
                        ShowNotification("Artist", "Not inserted..!", NotificationType.error);
                    }
                }
                else
                {
                    ShowNotification("Artist", "Sorry, Your Session had been Expired.. So Please Logout Once & Login Again..!", NotificationType.error);
                }
            }
            else
            {
                ShowNotification("Artist", "Please fill all Fields..!", NotificationType.error);
            }
        }
        catch (Exception Ex)
        {
        }
    }