protected void btnActiveOrDeactive_Command(object sender, CommandEventArgs e)
        {
            try
            {
                string id = Convert.ToString(e.CommandArgument);
                if (!string.IsNullOrEmpty(id))
                {
                    CountryBLL countryBLL = new CountryBLL();
                    DataTable  dt         = countryBLL.GetById(Convert.ToInt32(QuaintSecurityManager.Decrypt(id)));
                    if (dt != null)
                    {
                        if (dt.Rows.Count > 0)
                        {
                            string    actionStatus = "Updated";
                            Countries country      = new Countries();
                            country.CountryId         = Convert.ToInt32(Convert.ToString(dt.Rows[0]["CountryId"]));
                            country.CountryCode       = Convert.ToString(dt.Rows[0]["CountryCode"]);
                            country.Name              = Convert.ToString(dt.Rows[0]["Name"]);
                            country.CountryCodeAlpha2 = Convert.ToString(dt.Rows[0]["CountryCodeAlpha2"]);
                            country.CountryCodeAlpha3 = Convert.ToString(dt.Rows[0]["CountryCodeAlpha3"]);
                            country.Description       = Convert.ToString(dt.Rows[0]["Description"]);
                            country.IsActive          = Convert.ToBoolean(Convert.ToString(dt.Rows[0]["IsActive"]));
                            country.CreatedDate       = (string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["CreatedDate"]))) ? (DateTime?)null : Convert.ToDateTime(Convert.ToString(dt.Rows[0]["CreatedDate"]));
                            country.CreatedBy         = Convert.ToString(dt.Rows[0]["CreatedBy"]);
                            country.CreatedFrom       = Convert.ToString(dt.Rows[0]["CreatedFrom"]);

                            country.UpdatedDate = DateTime.Now;
                            country.UpdatedBy   = UserInfo;
                            country.UpdatedFrom = StationInfo;

                            if (country.IsActive)
                            {
                                country.IsActive = false;
                                actionStatus     = "Deactivated";
                            }
                            else
                            {
                                country.IsActive = true;
                                actionStatus     = "Activated";
                            }

                            if (countryBLL.Update(country))
                            {
                                Alert(AlertType.Success, actionStatus + " successfully.");
                                LoadList();
                            }
                            else
                            {
                                Alert(AlertType.Error, "Failed to update.");
                            }
                        }
                    }
                }
            }
            catch (Exception)
            {
                Alert(AlertType.Error, "Failed to process.");
            }
        }
示例#2
0
        static public Country GetById(int id)
        {
            Country       country       = null;
            Role          user_role     = Role.Admin;
            Type          type          = typeof(CountryBLL);
            MethodInfo    method        = type.GetMethod("GetById");
            RoleAttribute attribute     = method.GetCustomAttribute <RoleAttribute>();
            Role          function_role = attribute.Role;

            if (user_role == function_role)
            {
                DataRow dr = CountryBLL.GetById(id);
                country = new Country();

                country.ID           = dr.Field <int>("ID");
                country.Country_Name = dr.Field <string>("Name");
            }
            return(country);
        }
示例#3
0
 private void Edit(int id)
 {
     try
     {
         CountryBLL countryBLL = new CountryBLL();
         DataTable  dt         = countryBLL.GetById(id);
         if (dt != null)
         {
             if (dt.Rows.Count > 0)
             {
                 this.ModelId              = Convert.ToInt32(Convert.ToString(dt.Rows[0]["CountryId"]));
                 this.ModelCode            = Convert.ToString(dt.Rows[0]["CountryCode"]);
                 txtName.Text              = Convert.ToString(dt.Rows[0]["Name"]);
                 txtCountryCodeAlpha2.Text = Convert.ToString(dt.Rows[0]["CountryCodeAlpha2"]);
                 txtCountryCodeAlpha3.Text = Convert.ToString(dt.Rows[0]["CountryCodeAlpha3"]);
                 txtDescription.Text       = Convert.ToString(dt.Rows[0]["Description"]);
             }
         }
     }
     catch (Exception)
     {
         Alert(AlertType.Error, "Failed to edit.");
     }
 }
示例#4
0
        private void SaveAndUpdate()
        {
            try
            {
                if (string.IsNullOrEmpty(txtName.Text))
                {
                    Alert(AlertType.Warning, "Enter country name.");
                    txtName.Focus();
                }
                else
                {
                    string name = Convert.ToString(txtName.Text);
                    string countryCodeAlpha2 = Convert.ToString(txtCountryCodeAlpha2.Text);
                    string countryCodeAlpha3 = Convert.ToString(txtCountryCodeAlpha3.Text);
                    string description       = Convert.ToString(txtDescription.Text);

                    CountryBLL countryBLL = new CountryBLL();
                    if (this.ModelId > 0)
                    {
                        DataTable dt      = countryBLL.GetById(this.ModelId);
                        Countries country = new Countries();
                        country.CountryId         = Convert.ToInt32(Convert.ToString(dt.Rows[0]["CountryId"]));
                        country.CountryCode       = Convert.ToString(dt.Rows[0]["CountryCode"]);
                        country.Name              = Convert.ToString(dt.Rows[0]["Name"]);
                        country.CountryCodeAlpha2 = Convert.ToString(dt.Rows[0]["CountryCodeAlpha2"]);
                        country.CountryCodeAlpha3 = Convert.ToString(dt.Rows[0]["CountryCodeAlpha3"]);
                        country.Description       = Convert.ToString(dt.Rows[0]["Description"]);
                        country.IsActive          = Convert.ToBoolean(Convert.ToString(dt.Rows[0]["IsActive"]));
                        country.CreatedDate       = (string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["CreatedDate"]))) ? (DateTime?)null : Convert.ToDateTime(Convert.ToString(dt.Rows[0]["CreatedDate"]));
                        country.CreatedBy         = Convert.ToString(dt.Rows[0]["CreatedBy"]);
                        country.CreatedFrom       = Convert.ToString(dt.Rows[0]["CreatedFrom"]);

                        country.Name = name.Trim();
                        country.CountryCodeAlpha2 = countryCodeAlpha2;
                        country.CountryCodeAlpha3 = countryCodeAlpha3;
                        country.Description       = description;

                        country.UpdatedDate = DateTime.Now;
                        country.UpdatedBy   = this.UserInfo;
                        country.UpdatedFrom = this.StationInfo;

                        if (countryBLL.Update(country))
                        {
                            this.MultiEntryDisallow = true;
                            Alert(AlertType.Success, "Updated successfully.");
                            ClearFields();
                        }
                        else
                        {
                            Alert(AlertType.Error, "Failed to update.");
                        }
                    }
                    else
                    {
                        Countries country = new Countries();
                        country.CountryCode       = this.ModelCode;
                        country.Name              = name.Trim();
                        country.CountryCodeAlpha2 = countryCodeAlpha2;
                        country.CountryCodeAlpha3 = countryCodeAlpha3;
                        country.Description       = description;
                        country.IsActive          = true;
                        country.CreatedDate       = DateTime.Now;
                        country.CreatedBy         = this.UserInfo;
                        country.CreatedFrom       = this.StationInfo;

                        if (countryBLL.Save(country))
                        {
                            Alert(AlertType.Success, "Saved successfully.");
                            ClearFields();
                            GenerateCode();
                        }
                        else
                        {
                            Alert(AlertType.Error, "Failed to save.");
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Alert(AlertType.Error, ex.Message.ToString());
            }
        }