protected void grdCompany_RowCommand(object sender, GridViewCommandEventArgs e)
{
int rowIndex = int.Parse(e.CommandArgument.ToString());
Session.Add("rowIndex", rowIndex);
ManageCompany companyObj = new ManageCompany();
DataTable dt = companyObj.getACompany(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString, rowIndex);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
txtCompanyName.Value = DBUtility.readDBString(dr, "Company_Name");
txtCompanyAddress.Value = DBUtility.readDBString(dr, "Address_Line_1");
txtCompanyAddressLine2.Value = DBUtility.readDBString(dr, "Address_Line_2");
txtCompanyCity.Value = DBUtility.readDBString(dr, "City");
txtCompanyCode.Value = DBUtility.readDBString(dr, "Code");
txtCompanyTelephone.Value = DBUtility.readDBString(dr, "telephone_1");
txtCompanyTelephone2.Value = DBUtility.readDBString(dr, "telephone_2");
txtCompanyFax.Value = DBUtility.readDBString(dr, "fax");
txtCompanyEmail.Value = DBUtility.readDBString(dr, "email");
txtCompanyWebsite.Value = DBUtility.readDBString(dr, "website");
txtCompanyVATNumbwer.Value = DBUtility.readDBString(dr, "VAT_Number");
txtCompanyVATPercentage.Value = DBUtility.readDBString(dr, "VAT_percentage");
if (dr["Disable"] != null && !dr.IsNull("Disable"))
{
chkBoxCompanyDisable.Checked = Convert.ToBoolean(dr["Disable"]);
}
}
}
// Gaat naar de usercontrols voor het bewerken/verwijderen van data
private void buttonManageEdit_Click(object sender, EventArgs e)
{
if (ListViewActors.FocusedItem != null)
{
if (CurrentChoice == tableToDisplay.company)
{
ManageCompany ManageCompany = new ManageCompany(ref CompanyList, ref ContactpersonList, ref ContactpersonPeriodList, ListViewActors.FocusedItem, "Wijzigen");
ManageCompany.Size = new Size(908, 616);
ManageCompany.Location = new Point(0, 86);
this.Controls.Add(ManageCompany);
ManageCompany.BringToFront();
}
else if (CurrentChoice == tableToDisplay.user)
{
ManageUser ManageUser = new ManageUser(ref UserList, ref ContactpersonList, ref ContactpersonPeriodList, ListViewActors.FocusedItem, "Wijzigen");
ManageUser.Size = new Size(908, 616);
ManageUser.Location = new Point(0, 86);
this.Controls.Add(ManageUser);
ManageUser.BringToFront();
}
else if (CurrentChoice == tableToDisplay.contactperson)
{
ManageContactperson ManageContactperson = new ManageContactperson(ref UserList, ref CompanyList, ref ContactpersonList, ref ContactpersonPeriodList, ActivePerson, ListViewActors.FocusedItem, "Wijzigen");
ManageContactperson.Size = new Size(908, 616);
ManageContactperson.Location = new Point(0, 86);
this.Controls.Add(ManageContactperson);
ManageContactperson.BringToFront();
}
else if (CurrentChoice == tableToDisplay.contactperson_period)
{
ManageContactpersonPeriod ManageContactpersonPeriod = new ManageContactpersonPeriod(ref ContactpersonPeriodList, ref ContactpersonList, ref PeriodList, ListViewActors.FocusedItem);
ManageContactpersonPeriod.buttonContactpersonPeriodDelete_Click();
}
}
}
public async Task SaveManageCompany(ManageCompany manageCompany)
{
var manageConfig = new ManageConfig();
await Connection.OpenAsync();
using var cmd = Connection.CreateCommand();
cmd.CommandText = @"INSERT INTO managecompanies (Id, Name, Identifier) VALUES (@Id, @Name, @Identifier) ON DUPLICATE KEY UPDATE Id = @Id, Name = @Name, Identifier = @Identifier;";
cmd.Parameters.Add(new MySqlParameter
{
ParameterName = "@Id",
DbType = DbType.String,
Value = manageCompany.Id
});
cmd.Parameters.Add(new MySqlParameter
{
ParameterName = "@Name",
DbType = DbType.String,
Value = manageCompany.Name
});
cmd.Parameters.Add(new MySqlParameter
{
ParameterName = "@Identifier",
DbType = DbType.String,
Value = manageCompany.Identifier
});
await cmd.ExecuteNonQueryAsync();
cmd.Connection.Close();
}
public ActionResult ViewJob()
{
ManageCompany dbhandle = new ManageCompany();
ModelState.Clear();
return(View(dbhandle.ViewJob()));
}
public ActionResult AddManageCompany(ManageCompanyModel mc)
{
var categoryList = dbEnt.ManageCompany.Select(s => s.Category);
var nameList = dbEnt.ManageCompany.Select(s => s.Name);
var emailList = dbEnt.Users.Select(s => s.Email);
if (!categoryList.Contains(mc.Category) && !nameList.Contains(mc.Name) && !emailList.Contains(mc.Email))
{
ManageCompany _mcObj = new ManageCompany {
Name = mc.Name, Category = mc.Category, Street = mc.Street, HouseNumber = mc.HouseNumber
};
dbEnt.ManageCompany.Add(_mcObj);
dbEnt.SaveChanges();
Users _usrObj = new Users {
FirstName = mc.FirstName, SecondName = mc.SecondName, ThirdName = mc.ThirdName, Email = mc.Email, EmailConfirm = false, manageCompany_id = _mcObj.id
};
dbEnt.Users.Add(_usrObj);
dbEnt.SaveChanges();
var roleList = dbEnt.Roles.Select(r => r.Name);
Roles _rlobj;
if (!roleList.Contains("ManageCompany"))
{
_rlobj = new Roles {
Name = "ManageCompany"
};
dbEnt.Roles.Add(_rlobj);
dbEnt.SaveChanges();
}
else
{
_rlobj = dbEnt.Roles.Where(r => r.Name == "ManageCompany").Select(r => r).FirstOrDefault();
}
dbEnt.Accounts.Add(new Accounts {
user_id = _usrObj.id, password = ISCityFramework.GetPass(rnd)
});
dbEnt.SaveChanges();
dbEnt.UserRoles.Add(new UserRoles {
user_id = _usrObj.id, role_id = _rlobj.id
});
dbEnt.SaveChanges();
ISCityFramework.SendMail(_usrObj, dbEnt);
return(RedirectToAction("Index", "Admin", null));
}
else
{
ModelState.AddModelError("", "Организация с таким Наименованием, Категорией или Email уже существует.");
}
return(View(mc));
}
public ActionResult Edit(int id, Companyadd smodel)
{
try
{
ManageCompany sdb = new ManageCompany();
sdb.UPDATECOMPANYS(smodel);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult DeleteJob(int id)
{
try
{
ManageCompany sdb = new ManageCompany();
if (sdb.DeleteJob(id))
{
ViewBag.AlertMsg = "Student Deleted Successfully";
}
return(RedirectToAction("Index", "Admin"));
}
catch
{
return(View());
}
}
public async Task <List <ManageCompany> > GetManageCompaniesAsync()
{
var manageCompanies = new List <ManageCompany>();
await Connection.OpenAsync();
using (var cmd = new MySqlCommand("SELECT Id, Name, Identifier FROM managecompanies", Connection))
using (var reader = await cmd.ExecuteReaderAsync())
while (await reader.ReadAsync())
{
var manageCompany = new ManageCompany()
{
Id = reader.GetInt32(0),
Name = reader.GetString(1),
Identifier = reader.GetString(2),
};
manageCompanies.Add(manageCompany);
}
Connection.Close();
return(manageCompanies);
}
public ActionResult Create(Companyadd regi, string ReturnUrl = "")
{
if (ModelState.IsValid)
{
ManageCompany jm = new ManageCompany();
if (jm.Add_Company1(regi))
{
ViewBag.Message = "You Have Done Registration";
ModelState.Clear();
if (Url.IsLocalUrl(ReturnUrl))
{
return(Redirect(ReturnUrl));
}
else
{
return(RedirectToAction("Index", "Company"));
}
}
}
return(View());
}
public ActionResult UpdadeJob(int id)
{
ManageCompany sdb = new ManageCompany();
return(View(sdb.ViewJob().Find(smodel => smodel.J_Id == id)));
}
public ActionResult Edit(int id)
{
ManageCompany sdb = new ManageCompany();
return(View(sdb.ViewC_Regi().Find(smodel => smodel.C_Id == id)));
}
