//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;
}
