protected void uiGridViewCompanies_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditCompany")
{
Companies objData = new Companies();
objData.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString()));
uiTextBoxEnName.Text = objData.EnName;
uiTextBoxArName.Text = objData.ArName;
uiTextBoxEnAddress.Text = objData.EnAddress;
uiTextBoxArAddress.Text = objData.ArAddress;
uiTextBoxTele.Text = objData.Tele;
uiTextBoxFax.Text = objData.Fax;
uiDropDownListCity.SelectedValue = objData.CityID.ToString();
uiDropDownListCategory.SelectedValue = objData.CategoryID.ToString();
if (!objData.IsColumnNull("SubCategoryID"))
{
uiDropDownListSubCategory.SelectedValue = objData.SubCategoryID.ToString();
}
uiImageLogo.ImageUrl = objData.LogoPath;
uiLinkButtonResetPassword.Enabled = true;
uiTextBoxUserName.Text = objData.UserName;
uiTextBoxPassword.TextMode = TextBoxMode.SingleLine;
uiTextBoxPassword.Text = Membership.GetUser(objData.UserName).GetPassword();
uiTextBoxPassword.Enabled = false;
uiTextBoxUserName.Enabled = false;
if (!objData.IsColumnNull("PackageTypeID"))
{
uiDropDownListPackages.SelectedValue = objData.PackageTypeID.ToString();
}
// load packjage
CompanyEnabledOptions options = new CompanyEnabledOptions();
options.GetCompanyEnabledOptionsByCompanyID(Convert.ToInt32(e.CommandArgument.ToString()));
for (int i = 0; i < options.RowCount; i++)
{
foreach (ListItem item in uiCheckBoxListPackageOptions.Items)
{
if (item.Value == options.PackageOptionID.ToString())
{
item.Selected = options.Enabled;
break;
}
}
options.MoveNext();
}
uiPanelViewCompanies.Visible = false;
uiPanelEdit.Visible = true;
CurrentCompany = objData;
}
else if (e.CommandName == "DeleteCompany")
{
Companies objData = new Companies();
objData.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString()));
if (Membership.GetUser(objData.UserName) != null)
{
Membership.DeleteUser(objData.UserName);
}
CompanyEnabledOptions options = new CompanyEnabledOptions();
options.GetCompanyEnabledOptionsByCompanyID(objData.CompanyID);
options.DeleteAll();
options.Save();
Photos pics = new Photos();
pics.GetPhotosByCompanyID(objData.CompanyID);
pics.DeleteAll();
pics.Save();
BLL.Vedios videos = new BLL.Vedios();
videos.GetVedioByCompanyID(objData.CompanyID);
videos.DeleteAll();
videos.Save();
objData.MarkAsDeleted();
objData.Save();
BindData();
uiPanelViewCompanies.Visible = true;
uiPanelEdit.Visible = false;
}
}
protected void uiButtonUpdate_Click(object sender, EventArgs e)
{
if (uiFileUpload.HasFile)
{
ArrayList notUploaded = new ArrayList();
uiFileUpload.SaveAs(Server.MapPath("~/FileUploads/" + uiFileUpload.FileName));
string connectionString = string.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0;HDR=NO;""", Server.MapPath("~/FileUploads/" + uiFileUpload.FileName));
string strSQL = "SELECT * FROM [ورقة1$]";
OleDbConnection excelConnection = new OleDbConnection(connectionString);
excelConnection.Open();
OleDbCommand dbCommand = new OleDbCommand(strSQL, excelConnection);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(dbCommand);
DataTable dTable = new DataTable();
dataAdapter.Fill(dTable);
Companies objData = new Companies();
foreach (DataRow item in dTable.Rows)
{
MembershipCreateStatus obj;
string Username = item[1].ToString().Replace(" ", "");
Username = Username.Replace("&", "");
string Password = "";
if (Username.Length > 10)
{
Password = Username.Substring(0,10);
}
else
{
Password = Username;
}
if (Password.Length < 6)
{
Password = Password + Password;
}
MembershipUser objUser = Membership.CreateUser(Username, Password, "*****@*****.**", null, null, true, out obj);
bool success = true;
switch (obj)
{
case MembershipCreateStatus.DuplicateUserName:
success = false;
break;
case MembershipCreateStatus.InvalidPassword:
success = false;
break;
case MembershipCreateStatus.ProviderError:
case MembershipCreateStatus.UserRejected:
success = false;
break;
default:
break;
}
try
{
if (!Roles.IsUserInRole(Username, "Company"))
{
Roles.AddUserToRole(Username, "Company");
}
}
catch (Exception ex)
{
uiLabelError.Text += "001";
uiLabelError.Visible = true;
}
if (success)
{
try
{
objData.AddNew();
objData.EnName = item[1].ToString();
objData.ArName = item[0].ToString();
objData.EnAddress = item[3].ToString();
objData.ArAddress = item[2].ToString();
objData.Rank = 0;
try
{
objData.Tele = item[4].ToString();
}
catch (Exception ex)
{
}
try
{
objData.Fax = item[5].ToString();
}
catch (Exception ex)
{
}
objData.CityID = Convert.ToInt32(uiDropDownListCity.SelectedValue);
objData.CategoryID = Convert.ToInt32(uiDropDownListCategory.SelectedValue);
if(!string.IsNullOrEmpty(uiDropDownListSubCategory.SelectedValue))
objData.SubCategoryID = Convert.ToInt32(uiDropDownListSubCategory.SelectedValue);
objData.UserName = Username;
}
catch (Exception ex)
{
uiLabelError.Visible = true;
Membership.DeleteUser(Username);
notUploaded.Add(item[1].ToString() + " - " + ex.Message);
objData.MarkAsDeleted();
}
}
else
{
notUploaded.Add(item[1].ToString() + " - " + obj.ToString());
continue;
}
}
objData.Save();
if (notUploaded.Count < dTable.Rows.Count)
uiLabelmsg.Visible = true;
uiGridViewLog.DataSource = notUploaded;
uiGridViewLog.Columns[0].HeaderText = "These items faild to insert";
uiGridViewLog.DataBind();
}
}
