private void Onsearch()
{
try
{
grdCompany.Rows.Clear();
master = new Master_Company();
List <Company_GetCompany_Result> result = master.Get_Company(txtSearch.Text.Trim());
foreach (Company_GetCompany_Result re in result)
{
grdCompany.Rows.Add(grdCompany.Rows.Count + 1
, re.companyID
, re.companyName
, re.phone
, re.address);
}
if (result.Count > 0)
{
GrdComclick(0);
}
}
catch (Exception ex)
{
Log_Error(ex);
}
}
private void Product_Load(object sender, EventArgs e)
{
design_Dgv();
masterCom = new Master_Company();
List <Company_GetCompany_Result> result = masterCom.Get_Company(string.Empty);
foreach (Company_GetCompany_Result re in result)
{
ComboboxItem item = new ComboboxItem();
item.Text = re.companyName;
item.Value = re.companyID;
cbCompany.Items.Add(item);
}
MasterStore = new Master_StoreManagement();
List <Store_GetListbank_Result> result2 = MasterStore.Get_Listbank();
foreach (Store_GetListbank_Result re2 in result2)
{
ComboboxItem item = new ComboboxItem();
item.Text = re2.bankName;
item.Value = re2.bankID;
cbbType.Items.Add(item);
}
ViewMode();
}
//company add
public int Addcompany(Master_Company c)
{
int i;
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
string q = "insert into Master_Company(CompanyName,Address1,Address2,Tagline,LogoUrl,Username,Password,LocalArea,CityCode,CompanyEmail) values(@CompanyName, @Address1, @Address2, @Tagline, @LogoUrl, @Username, @Password, @LocalArea, @CityCode, @CompanyEmail)";
SqlCommand com = new SqlCommand(q, con);
//com.Parameters.AddWithValue("@CompanyID", c.CompanyID);
com.Parameters.AddWithValue("@CompanyName", c.CompanyName);
com.Parameters.AddWithValue("@Address1", c.Address1);
com.Parameters.AddWithValue("@Address2", c.Address2);
com.Parameters.AddWithValue("@Tagline", c.Tagline);
com.Parameters.AddWithValue("@LogoUrl", c.LogoUrl);
com.Parameters.AddWithValue("@Username", c.Username);
com.Parameters.AddWithValue("@Password", c.Password);
com.Parameters.AddWithValue("@LocalArea", c.LocalArea);
com.Parameters.AddWithValue("@CityCode", c.CityCode);
com.Parameters.AddWithValue("@CompanyEmail", c.CompanyEmail);
i = com.ExecuteNonQuery();
}
return(i);
}
private void OnEdit()
{
DialogResult dialog = MessageBox.Show(Messge.INF_Edit, Messge.CM_Confirm, MessageBoxButtons.YesNo);
if (dialog == DialogResult.Yes)
{
master = new Master_Company();
master.Edit_Company(Convert.ToInt32(txtID.Text), txtCompany.Text, txtPhone.Text, txtAddress.Text);
MessageBox.Show(Messge.INF_Edit, Messge.CM_Confirm);
}
else
{
MessageBox.Show(Messge.INF_Cancel, Messge.CM_Confirm);
}
}
private void OnAdd()
{
DialogResult dialog = MessageBox.Show(Messge.CM_Add, Messge.CM_Confirm, MessageBoxButtons.YesNo);
if (dialog == DialogResult.Yes)
{
master = new Master_Company();
master.Add_Company(txtCompany.Text, txtPhone.Text, txtAddress.Text);
MessageBox.Show(Messge.INF_Save, Messge.CM_Confirm);
}
else
{
MessageBox.Show(Messge.INF_Cancel, Messge.CM_Confirm);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult dialog = MessageBox.Show(Messge.CM_Delete, Messge.CM_Confirm, MessageBoxButtons.YesNo);
if (dialog == DialogResult.Yes)
{
master = new Master_Company();
master.Del_Company(Convert.ToInt32(txtID.Text));
MessageBox.Show(Messge.INF_Delete, Messge.CM_Confirm);
Onsearch();
}
else
{
MessageBox.Show(Messge.INF_Cancel, Messge.CM_Confirm);
}
}
public JsonResult Add(Master_Company c)
{
return(Json(db.Addcompany(c), JsonRequestBehavior.AllowGet));
}
