public void Delete(int id)
{
CRM_CustomerUtility ru = new CRM_CustomerUtility();
//int id = Convert.ToInt32(DeleteTextBox.Text);
ru.Delete(id);
}
public List <CRM_Customer> Customers()
{
CRM_CustomerUtility ru = new CRM_CustomerUtility();
List <CRM_Customer> rList = ru.GetCustomers();
return(rList);
}
protected void SelectBtn_Click(object sender, EventArgs e)
{
try
{
ErrorLab.Text = "";
int id = Convert.ToInt32(CompanyIDTextBox.Text);
CRM_CustomerUtility ru = new CRM_CustomerUtility();
List <CRM_Customer> rList = ru.GetCustomer(id);
CompanyNameTextBox.Text = rList[0].CompanyName;
CompanyAddressTextBox.Text = rList[0].CompanyAddress;
CompanyPhoneTextBox.Text = rList[0].CompanyPhone;
OfficialWebsiteTextBox.Text = rList[0].OfficialWebsite;
ContactPersonTextBox.Text = rList[0].ContactPerson;
CP_PhoneTextBox.Text = rList[0].CP_Phone;
CP_EmailTextBox.Text = rList[0].CP_Email;
CompanyScaleDropDownList.SelectedValue = rList[0].CompanyScale;
CompanyCategoryDropDownList.SelectedValue = rList[0].CompanyCategory;
}
catch (Exception)
{
ErrorLab.Text = "查無此客戶資料";
CompanyNameTextBox.Text = "";
CompanyAddressTextBox.Text = "";
CompanyPhoneTextBox.Text = "";
OfficialWebsiteTextBox.Text = "";
ContactPersonTextBox.Text = "";
CP_PhoneTextBox.Text = "";
CP_EmailTextBox.Text = "";
CompanyScaleDropDownList.SelectedValue = "未選擇";
CompanyCategoryDropDownList.SelectedValue = "未選擇";
}
}
protected void InsertBtn_Click(object sender, EventArgs e)
{
try
{
ErrorLab.Text = "客戶資料新增成功";
CRM_Customer r = new CRM_Customer()
{
CompanyID = Convert.ToInt32(CompanyIDTextBox.Text),
CompanyName = CompanyNameTextBox.Text,
CompanyAddress = CompanyAddressTextBox.Text,
CompanyPhone = CompanyPhoneTextBox.Text,
OfficialWebsite = OfficialWebsiteTextBox.Text,
ContactPerson = ContactPersonTextBox.Text,
CP_Phone = CP_PhoneTextBox.Text,
CP_Email = CP_EmailTextBox.Text,
CompanyScale = CompanyScaleDropDownList.Text,
CompanyCategory = CompanyCategoryDropDownList.Text
};
CRM_CustomerUtility ru = new CRM_CustomerUtility();
ru.Insert(r);
}
catch (Exception)
{
ErrorLab.Text = "客戶資料格式錯誤或已建立，請確認統編";
}
}
protected void InsertCompanyCategorysBtn_Click(object sender, EventArgs e)
{
CRM_Customer r = new CRM_Customer()
{
CompanyCategory = InsertCompanyCategorysTextBox.Text
};
CRM_CustomerUtility ru = new CRM_CustomerUtility();
ru.InsertCompanyCategorys(r);
}
protected void SelectBtn_Click(object sender, EventArgs e)
{
try
{
ErrorLab.Text = "";
int id = Convert.ToInt32(CompanyIDTextBox.Text);
CRM_CustomerUtility ru = new CRM_CustomerUtility();
List <CRM_Customer> rList = ru.GetCustomer(id);
CompanyNameTextBox.Text = rList[0].CompanyName;
}
catch (Exception)
{
ErrorLab.Text = "查無此客戶資料";
CompanyNameTextBox.Text = "";
}
}
protected void UpdateBtn_Click(object sender, EventArgs e)
{
CRM_Customer r = new CRM_Customer()
{
CompanyID = Convert.ToInt32(CompanyID.Text)
};
r.CompanyName = CompanyName.Text;
r.CompanyAddress = CompanyAddress.Text;
r.CompanyPhone = CompanyPhone.Text;
r.OfficialWebsite = OfficialWebsite.Text;
r.ContactPerson = ContactPerson.Text;
r.CP_Phone = CP_Phone.Text;
r.CP_Email = CP_Email.Text;
r.CompanyScale = CompanyScale.Text;
r.CompanyCategory = CompanyCategory.Text;
CRM_CustomerUtility ru = new CRM_CustomerUtility();
ru.Update(r);
}
protected void UpdateBtn_Click(object sender, EventArgs e)
{
CRM_Customer r = new CRM_Customer()
{
CompanyID = Convert.ToInt32(CompanyIDTextBox.Text)
};
r.CompanyName = CompanyNameTextBox.Text;
r.CompanyAddress = CompanyAddressTextBox.Text;
r.CompanyPhone = CompanyPhoneTextBox.Text;
r.OfficialWebsite = OfficialWebsiteTextBox.Text;
r.ContactPerson = ContactPersonTextBox.Text;
r.CP_Phone = CP_PhoneTextBox.Text;
r.CP_Email = CP_EmailTextBox.Text;
r.CompanyScale = CompanyScaleDropDownList.Text;
r.CompanyCategory = CompanyCategoryDropDownList.Text;
CRM_CustomerUtility ru = new CRM_CustomerUtility();
ru.Update(r);
ErrorLab.Text = "修改客戶資料成功";
}
