public int SaveContactDeatails(Entity.Customer.CustomerContactDetails ObjElCustomerContactDetails)
{
int rowsAffacted = 0;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "usp_Customer_CustomerContactDetails_Save";
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@CustomerAddressId", ObjElCustomerContactDetails.CustomerAddressId);
//cmd.Parameters.AddWithValue("@tAddress", ObjElCustomerContactDetails.TAddress);
//cmd.Parameters.AddWithValue("@tStreet", ObjElCustomerContactDetails.TStreet);
cmd.Parameters.AddWithValue("@CustomerContactDetailsId", ObjElCustomerContactDetails.CustomerContactDetailsId);
cmd.Parameters.AddWithValue("@CustomerMasterId_FK", ObjElCustomerContactDetails.CustomerMasterId_FK);
cmd.Parameters.AddWithValue("@ContactPerson", ObjElCustomerContactDetails.ContactPerson);
cmd.Parameters.AddWithValue("@CPDesignation", ObjElCustomerContactDetails.CPDesignation);
cmd.Parameters.AddWithValue("@CPPhoneNo", ObjElCustomerContactDetails.CPPhoneNo);
cmd.Parameters.AddWithValue("UserId", ObjElCustomerContactDetails.UserId);
cmd.Parameters.AddWithValue("CompanyMasterId_FK", ObjElCustomerContactDetails.CompanyMasterId_FK);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
rowsAffacted = cmd.ExecuteNonQuery();
con.Close();
}
}
return(rowsAffacted);
}
public DataTable FetchCustomerContactDetailsById(Entity.Customer.CustomerContactDetails ObjElCustomerContactDetails)
{
using (DataTable dt = new DataTable())
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_Customer_CustomerContactDetails_GetById";
cmd.Parameters.AddWithValue("@CustomerContactDetailsId", ObjElCustomerContactDetails.CustomerContactDetailsId);
//cmd.Parameters.AddWithValue("CompanyMasterId_FK", ObjElCustomerAddress.CompanyMasterId_FK);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
con.Close();
}
}
return(dt);
}
}
private void FetchCustomerContactDetailsById(long Id)
{
Business.Customer.CustomerContactDetails objCustomerContactDetails = new Business.Customer.CustomerContactDetails();
Entity.Customer.CustomerContactDetails customerContactDetails = new Entity.Customer.CustomerContactDetails();
customerContactDetails.CustomerContactDetailsId = Id;
DataTable dr = objCustomerContactDetails.FetchCustomerContactDetailsById(customerContactDetails);
if (dr.Rows.Count > 0)
{
txtcontactDesignation.Text = dr.Rows[0]["CPDesignation"].ToString();
txtcontactPerson.Text = dr.Rows[0]["ContactPerson"].ToString();
txtCphoneNumber.Text = dr.Rows[0]["CPPhoneNo"].ToString();
CustomerContactDetailsId = Convert.ToInt64(dr.Rows[0]["CustomerContactDetailsId"].ToString());
}
}
protected void gvContactDetails_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "E")
{
CustomerContactDetailsId = Convert.ToInt64(e.CommandArgument.ToString());
FetchCustomerContactDetailsById(Convert.ToInt64(e.CommandArgument.ToString()));
TabContainer1.ActiveTab = AddContact;
ModalPopupExtender1.Show();
}
else if (e.CommandName == "D")
{
CustomerContactDetailsId = Convert.ToInt64(e.CommandArgument.ToString());
TabContainer1.ActiveTab = AddContact;
int i = 0;
Business.Customer.CustomerContactDetails ObjBelCustomerContactDetails = new Business.Customer.CustomerContactDetails();
Entity.Customer.CustomerContactDetails ObjElCustomerContactDetails = new Entity.Customer.CustomerContactDetails();
ObjElCustomerContactDetails.CustomerContactDetailsId = CustomerContactDetailsId;
i = ObjBelCustomerContactDetails.DeleteCustomerContactDetailsById(ObjElCustomerContactDetails);
if (i > 0)
{
CleartextBoxes(this);
ScriptManager.RegisterStartupScript(this, this.GetType(), "mmsg", "alert('Data Delete Succesfully....');", true);
CustomerContactDetailsId = 0;
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "mmsg", "alert('Data Can not Delete!!!....');", true);
}
//ModalPopupExtender1.Show();
CustomerContactDetailsId = 0;
}
}
catch (Exception ex)
{
ex.WriteException();
Message.IsSuccess = false;
Message.Text = ex.Message;
Message.Show = true;
}
}
private void GetAllACustomerContactDetails(long Id)
{
Business.Customer.CustomerContactDetails objustomerContactDetails = new Business.Customer.CustomerContactDetails();
Entity.Customer.CustomerContactDetails customerContactDetails = new Entity.Customer.CustomerContactDetails();
customerContactDetails.CompanyMasterId_FK = 1;
customerContactDetails.CustomerMasterId_FK = Id;
DataTable dt = objustomerContactDetails.GetAllACustomerContactDetails(customerContactDetails);
if (dt.Rows.Count > 0)
{
gvContactDetails.DataSource = dt;
gvContactDetails.DataBind();
}
else
{
gvContactDetails.DataSource = null;
gvContactDetails.DataBind();
}
}
protected void btnTSave_Click(object sender, EventArgs e)
{
try
{
Business.Customer.CustomerContactDetails objCustomerContactDetails = new Business.Customer.CustomerContactDetails();
Entity.Customer.CustomerContactDetails customerContactDetails = new Entity.Customer.CustomerContactDetails();
customerContactDetails.CustomerContactDetailsId = CustomerContactDetailsId;
customerContactDetails.CustomerMasterId_FK = CustomerId;
customerContactDetails.ContactPerson = txtcontactPerson.Text;
customerContactDetails.CPDesignation = txtcontactDesignation.Text;
customerContactDetails.CPPhoneNo = txtCphoneNumber.Text;
customerContactDetails.CompanyMasterId_FK = 1;
customerContactDetails.UserId = 1;
int i = 0;
i = objCustomerContactDetails.SaveContactDeatails(customerContactDetails);
if (i > 0)
{
CleartextBoxes(this);
ScriptManager.RegisterStartupScript(this, this.GetType(), "mmsg", "alert('Data Save Succesfully....');", true);
GetAllACustomerContactDetails(CustomerId);
CustomerContactDetailsId = 0;
TabContainer1.ActiveTab = ContactDetails;
ModalPopupExtender1.Show();
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "mmsg", "alert('Data Can not Save!!!....');", true);
//Message.IsSuccess = false;
//Message.Text = "Can not save!!!";
}
}
catch (Exception ex)
{
ex.WriteException();
Message.IsSuccess = false;
Message.Text = ex.Message;
Message.Show = true;
}
}
public int DeleteCustomerContactDetailsById(Entity.Customer.CustomerContactDetails ObjElCustomerContactDetails)
{
int rowsAffacted = 0;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "usp_Customer_CustomerContactDetails_Delete";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CustomerContactDetailsId", ObjElCustomerContactDetails.CustomerContactDetailsId);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
rowsAffacted = cmd.ExecuteNonQuery();
con.Close();
}
}
return(rowsAffacted);
}
public DataTable GetAllACustomerContactDetails(Entity.Customer.CustomerContactDetails ObjElCustomerContactDetails)
{
using (DataTable dt = new DataTable())
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_Customer_CustomerContactDetails_GetAll";
cmd.Parameters.AddWithValue("@CustomerMasterId_FK", ObjElCustomerContactDetails.CustomerMasterId_FK);
cmd.Parameters.AddWithValue("CompanyMasterId_FK", ObjElCustomerContactDetails.CompanyMasterId_FK);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
con.Close();
}
}
return(dt);
}
}
public int SaveContactDeatails(Entity.Customer.CustomerContactDetails ObjElCustomerContactDetails)
{
return(ObjDelelCustomerContactDetails.SaveContactDeatails(ObjElCustomerContactDetails));
}
public int DeleteCustomerContactDetailsById(Entity.Customer.CustomerContactDetails ObjElCustomerContactDetails)
{
return(ObjDelelCustomerContactDetails.DeleteCustomerContactDetailsById(ObjElCustomerContactDetails));
}
public DataTable FetchCustomerContactDetailsById(Entity.Customer.CustomerContactDetails ObjElCustomerContactDetails)
{
return(ObjDelelCustomerContactDetails.FetchCustomerContactDetailsById(ObjElCustomerContactDetails));
}
public System.Data.DataTable GetAllACustomerContactDetails(Entity.Customer.CustomerContactDetails ObjElCustomerContactDetails)
{
return(ObjDelelCustomerContactDetails.GetAllACustomerContactDetails(ObjElCustomerContactDetails));
}
