//FILTRU private void LblSearch_Click(object sender, EventArgs e) { BlClient blClient = new BlClient(); DAClient cautaList = new DAClient(); GridViewClients.DataSource = cautaList.ListaSearchById(txtSearch.Text); }
public JsonResult SelectClientAll(string PageIndex = "1", string SearchItem = "") { try { int statusCode = 1; DataSet ds = new DataSet(); BlClient blclient = new BlClient(); blclient.PageIndex = Convert.ToInt32(PageIndex); blclient.FK_Company = Convert.ToInt64(Session["ID_Company"]); blclient.CliCode = SearchItem; blclient.CliName = SearchItem; blclient.ResName = SearchItem; ds = blclient.SelectAllData(); DataTable dtblClient = ds.Tables[0]; DataTable dtblClientDetail = ds.Tables[1]; return(Json(Converttojson(dtblClient), JsonRequestBehavior.AllowGet)); } catch (Exception ex) { /// return(Json(ex)); } }
//ADRESA : private void LblAddress_Click(object sender, EventArgs e) { BlClient blClient = new BlClient(); DaClientAddress AddressList = new DaClientAddress(); DataTable dt = new DataTable(); dt = AddressList.dataTableCA(ClientId); GridViewAddresss.DataSource = dt; GridViewAddresss.Columns["ClientAddressId"].Visible = false; GridViewAddresss.Columns["ClientId"].Visible = false; }
public void AfiseazaClient() { BlClient blClient = new BlClient(); var blclient = blClient.FindClientById(ClientId); //are clientul cu toate datele. txtName.Text = blclient.ClientName; txtSurname.Text = blclient.ClientSurname; txtClientCode.Text = blclient.ClientCode.ToString(); txtEmail.Text = blclient.Email; txtPhoneNo.Text = blclient.PhoneNo.ToString(); }
public ClientAddressForm(int ClientId) { InitializeComponent(); AddAndModify ptrGridView = new AddAndModify(); BlClient blClientAddress = new BlClient(); // ptrGridView.GridViewAddresss.DataSource = blClientAddress.Adresa(ClientId); //ptrGridView.GridViewAddresss.Columns["ClientAddressId"].Visible = false; //ptrGridView.GridViewAddresss.Columns["ClientId"].Visible = false; this.ClientId = ClientId; }
public ActionResult UpdateClient(BlClient ObjBlClient) { long statusCode = 0; ObjBlClient.UserCode = Convert.ToInt64(Session["ID_Agent"]); ObjBlClient.FK_Company = Convert.ToInt64(Session["ID_Company"]); if (ObjBlClient.MasterID == 0) { statusCode = ObjBlClient.InsertData(); } else { statusCode = ObjBlClient.UpdateData(); } return(Json(new { statusCode = "" + statusCode + "" }, JsonRequestBehavior.AllowGet)); }
public JsonResult DeleteClient(Int64 ID_Client) { try { long statusCode = 0; BlClient blclient = new BlClient(); blclient.MasterID = ID_Client; blclient.UserCode = Convert.ToInt64(Session["ID_Agent"]); blclient.FK_Company = Convert.ToInt64(Session["ID_Company"]); statusCode = blclient.DeleteData(); return(Json(new { statusCode = "" + statusCode + "" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex)); } }
public JsonResult FillClient(Int64 ID_Client) { try { DataSet ds = new DataSet(); DataTable dtbl = new DataTable(); BlClient blclient = new BlClient(); blclient.MasterID = ID_Client; blclient.UserCode = Convert.ToInt64(Session["ID_Agent"]); blclient.FK_Company = Convert.ToInt64(Session["ID_Company"]); ds = blclient.SelectAllData(); DataTable Dt = ds.Tables[0]; DataTable Dt1 = ds.Tables[1]; return(Json(new { table = "" + Converttojson(Dt) + "", table1 = "" + Converttojson(Dt1) + "" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex)); } }
private void BtnModify_Click(object sender, EventArgs e) { BlClient modificaClient = new BlClient(); var result = modificaClient.SalveazaClienti(txtName.Text, ClientId, txtSurname.Text, txtClientCode.Text, txtPhoneNo.Text, txtEmail.Text); if (result) { MessageBox.Show("Ai reusit! "); } else { MessageBox.Show(" Ceva nu e in regula, Clientul nu a fost modificat"); } ClientForm clientformC = new ClientForm(); clientformC.Show(); this.Hide(); clientformC.FormClosed += ClientForm_FormClosed; }
//Adrese Clienti: ClientId este in plus private void BtnSaveAddress_Click(object sender, EventArgs e) { if (String.IsNullOrWhiteSpace(txtCity.Text)) { MessageBox.Show("Orasul nu este completat", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (String.IsNullOrWhiteSpace(txtCounty.Text)) { MessageBox.Show("Judetul nu este completat", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } BlClient addAddress = new BlClient(); addAddress.addClientAddress(this.ClientId, txtCity.Text, txtCounty.Text, txtStreetName.Text, txtStreetNo.Text); //BlClient daAdresa = new BlClient(); ////apelez datele(txt) din winUI, in locul parametrilor AddClients. //DaClientAddress addressList = new DaClientAddress(); //AddAndModify adaugaAdress = new AddAndModify(); //adaugaAdress.GridViewAddresss.DataSource = addressList.AddClientAddress(ClientId, txtCity.Text, txtCounty.Text, txtStreetName.Text, null); //// daAdresa.AddClientAddress(ClientId, txtCity.Text, txtCounty.Text, txtStreetName.Text, StreetNo); ClientForm clientformAB = new ClientForm(); clientformAB.Show(); MessageBox.Show("Adresa a fost adaugata"); this.Hide(); clientformAB.FormClosed += ClientForm_FormClosed; }