public CompanyDO UpdateCompany(CompanyDO company)
{
var original = _companyDao.ReadCompanyById(company.CompanyId);
company.SubscriptionReference = original.SubscriptionReference;
return(_companyDao.Update(company));
}
/// <summary>
/// Selects Company records by PK
/// </summary>
public static CompanyDO[] GetByPK(Int32 CompanyId)
{
SqlParameter _CompanyId = new SqlParameter("CompanyId", SqlDbType.Int);
_CompanyId.Value = CompanyId;
SqlParameter[] _params = new SqlParameter[] {
_CompanyId
};
string pid = ConfigurationManager.AppSettings["PID"];
SafeReader sr = DataCommon.ExecuteSafeReader(String.Format("[{0}].[Company_GetByPK]", pid), _params, pid);
List <CompanyDO> objs = new List <CompanyDO>();
while (sr.Read())
{
CompanyDO obj = new CompanyDO();
obj.CompanyId = sr.GetInt32(sr.GetOrdinal("CompanyId"));
obj.Name = sr.GetString(sr.GetOrdinal("Name"));
obj.PhoneNumber = sr.GetString(sr.GetOrdinal("PhoneNumber"));
objs.Add(obj);
}
return(objs.ToArray());
}
private void btnAccept_Click(object sender, EventArgs e)
{
string Name = txtCompanyName.Text;
string Address = txtAddress.Text;
string District = txtDistrict.Text;
string City = txtCity.Text;
string Country = txtCountry.Text;
string TaxCode = txtTaxCode.Text;
string BankName = txtBankName.Text;
string BankAccount = txtBankAccount.Text;
string Tel = txtTel.Text;
string Fax = txtFax.Text;
string Email = txtEmail.Text;
string Website = txtWeb.Text;
DateTime FoundedDay = dtFoundedDay.Value;
string Note = txtNote.Text;
string companycode = txtCompanyCode.Text;
string healthInsuranceID = txtHealthInsuranceID.Text;
CompanyDO companyDO = new CompanyDO();
int result = 0;
try
{
result = companyDO.UpdateDefaultCompanyInfo(Name, Address, City, Country, Tel, Fax, Email, District, Website, TaxCode, BankName, BankAccount, FoundedDay, Note, healthInsuranceID, companycode);
}
catch (Exception ex)
{
MessageBox.Show("Lỗi cập nhật CSDL !", "Thông báo");
}
if (result == 1)
{
MessageBox.Show("Cập nhật thành công !", "Thông báo");
}
this.Close();
}
//private SystemDataConnect Sysconnect = new SystemDataConnect();
private void frmCompanyUserInfo_Load(object sender, EventArgs e)
{
CompanyDO companyDO = new CompanyDO();
DataSet dsCompany = companyDO.GetCompanyInfo();
if (dsCompany.Tables[0].Rows.Count == 0)
{
return;
}
DataRow row = dsCompany.Tables[0].Rows[0];
txtCompanyName.Text = row["Name"].ToString();
txtAddress.Text = row["Address"].ToString();
txtDistrict.Text = row["District"].ToString();
txtCity.Text = row["City"].ToString();
txtCountry.Text = row["Country"].ToString();
txtTaxCode.Text = row["TaxCode"].ToString();
txtBankAccount.Text = row["BankAccount"].ToString();
txtBankName.Text = row["BankName"].ToString();
txtTel.Text = row["Tel"].ToString();
txtFax.Text = row["Fax"].ToString();
txtEmail.Text = row["Email"].ToString();
txtWeb.Text = row["Website"].ToString();
dtFoundedDay.Value = DateTime.Parse(row["FoundedDay"].ToString());
txtNote.Text = row["Note"].ToString();
txtCompanyCode.Text = row["CompanyCode"].ToString();
txtHealthInsuranceID.Text = row["HealthInsuranceID"].ToString();
}
/// <summary>
/// Deletes a Company record
/// </summary>
public int Delete(CompanyDO DO, DalapiTransaction Transaction)
{
SqlParameter _CompanyId = new SqlParameter("CompanyId", SqlDbType.Int);
_CompanyId.Value = DO.CompanyId;
SqlParameter[] _params = new SqlParameter[] {
_CompanyId
};
return(DataCommon.ExecuteScalar(String.Format("[{0}].[Company_Delete]", pid), _params, pid, Transaction));
}
/// <summary>
/// Deletes a Company record
/// </summary>
public static int Delete(CompanyDO DO, DalapiTransaction Transaction)
{
SqlParameter _CompanyId = new SqlParameter("CompanyId", SqlDbType.Int);
_CompanyId.Value = DO.CompanyId;
SqlParameter[] _params = new SqlParameter[] {
_CompanyId
};
string pid = ConfigurationManager.AppSettings["PID"];
return(DataCommon.ExecuteScalar(String.Format("[{0}].[Company_Delete]", pid), _params, pid, Transaction));
}
/// <summary>
/// Creates a new Company record
/// </summary>
public int Create(CompanyDO DO, DalapiTransaction Transaction)
{
SqlParameter _Name = new SqlParameter("Name", SqlDbType.VarChar);
SqlParameter _PhoneNumber = new SqlParameter("PhoneNumber", SqlDbType.VarChar);
_Name.Value = DO.Name;
_PhoneNumber.Value = DO.PhoneNumber;
SqlParameter[] _params = new SqlParameter[] {
_Name,
_PhoneNumber
};
return(DataCommon.ExecuteScalar(String.Format("[{0}].[Company_Insert]", pid), _params, pid, Transaction));
}
/// <summary>
/// Updates a Company record and returns the number of records affected
/// </summary>
public static int Update(CompanyDO DO, DalapiTransaction Transaction)
{
SqlParameter _CompanyId = new SqlParameter("CompanyId", SqlDbType.Int);
SqlParameter _Name = new SqlParameter("Name", SqlDbType.VarChar);
SqlParameter _PhoneNumber = new SqlParameter("PhoneNumber", SqlDbType.VarChar);
_CompanyId.Value = DO.CompanyId;
_Name.Value = DO.Name;
_PhoneNumber.Value = DO.PhoneNumber;
SqlParameter[] _params = new SqlParameter[] {
_CompanyId,
_Name,
_PhoneNumber
};
string pid = ConfigurationManager.AppSettings["PID"];
return(DataCommon.ExecuteScalar(String.Format("[{0}].[Company_Update]", pid), _params, pid, Transaction));
}
/// <summary>
/// Gets all Company records
/// </summary>
public CompanyDO[] GetAll()
{
SafeReader sr = DataCommon.ExecuteSafeReader(String.Format("[{0}].[Company_GetAll]", pid), new SqlParameter[] { }, pid);
List <CompanyDO> objs = new List <CompanyDO>();
while (sr.Read())
{
CompanyDO obj = new CompanyDO();
obj.CompanyId = sr.GetInt32(sr.GetOrdinal("CompanyId"));
obj.Name = sr.GetString(sr.GetOrdinal("Name"));
obj.PhoneNumber = sr.GetString(sr.GetOrdinal("PhoneNumber"));
objs.Add(obj);
}
return(objs.ToArray());
}
public UserDO CreateSubscription(Subscription subscription, string originalEmail)
{
//create Subscription
var subscriptionDo = _mapper.Map <SubscriptionDO>(subscription);
subscriptionDo.OriginalEmail = originalEmail;
_log.InfoFormat("Subscription ID:{0}, subscription created in DB. {1}", subscription.SubscriptionReference,
subscriptionDo);
//create Company
var company = new CompanyDO();
if (string.IsNullOrEmpty(subscription.Customer.Company))
{
company.Name = $"{subscription.Customer.FirstName} {subscription.Customer.LastName}";
}
else
{
company.Name = subscription.Customer.Company;
}
company.SubscriptionReference = subscriptionDo.SubscriptionReference;
company.Subscription = subscriptionDo;
_companyDao.Create(company);
_log.InfoFormat("Subscription ID:{0}, company created in DB. {1}", subscription.SubscriptionReference,
company);
//create master User
var user = new UserDO();
user.EMail = subscription.Customer.Email;
user.FirstName = subscription.Customer.FirstName;
user.FamilyName = subscription.Customer.LastName;
user.PhoneNumber = subscription.Customer.PhoneNumber;
user.IsCompanyAdmin = true;
user.CompanyId = company.CompanyId;
user.IsPinzSuperAdmin = false;
user.Password = RandomPassword.Generate();
user = _userDao.Create(user);
_log.InfoFormat("Subscription ID:{0}, user created in DB. {1}", subscription.SubscriptionReference, user);
//create Project
var project = new ProjectDO
{
CompanyId = company.CompanyId,
Name = "GetStarted",
Description = "Project to get you started with PINZ! Feel free to rename and use as you like."
};
project = _projectDao.Create(project);
//staff user as admin on project
var ps = new ProjectStaffDO
{
ProjectId = project.ProjectId,
UserId = user.UserId,
IsProjectAdmin = true
};
_projectStaffDao.Create(ps);
//create tasks
var categoryAdministration = CreateCategory(project, "Administration");
CreateTask(categoryAdministration, user, "Rename this project",
"In the Outlook Ribbon, click on PINZ tab. Fromo there you can navigate to Administration panel.");
CreateTask(categoryAdministration, user, "Invite more users",
"In the Outlook Ribbon, click on PINZ tab. Fromo there you can navigate to Administration panel.");
CreateTask(categoryAdministration, user, "Close Tasks",
"Close Tasks by ticking the checkboxes in the task list.");
CreateTask(categoryAdministration, user, "Delete Categories",
"Only empty categories can be deleted.");
var educationAdministration = CreateCategory(project, "Education");
CreateTask(educationAdministration, user, "Visit Support Page",
"Visit our Support Senter at https://pinzonline.zendesk.com for more information.");
return(user);
}
/// <summary>
/// Deletes a Company record
/// </summary>
public static int Delete(CompanyDO DO)
{
return(Delete(DO, null));
}
/// <summary>
/// Updates a Company record and returns the number of records affected
/// </summary>
public static int Update(CompanyDO DO)
{
return(Update(DO, null));
}
/// <summary>
/// Creates a new Company record
/// </summary>
public static int Create(CompanyDO DO)
{
return(Create(null));
}
public void DeleteCompany(CompanyDO company)
{
_companyDao.Delete(company);
}
public CompanyDO CreateCompany(CompanyDO company)
{
return(_companyDao.Create(company));
}
