protected void ClearAll()
{
TxtClientName.Text = "";
TxtFirmName.Text = "";
TxtEMailId.Text = "";
TxtFDOJ.Text = "";
TxtTDOJ.Text = "";
TxtFLeftDate.Text = "";
TxtTLeftDate.Text = "";
var ContryDs = from c in HRMLinq.Country_Masts
orderby c.CountryName
select new { CountryId = c.Id, c.CountryName };
ddlCountry.Items.Clear();
ddlCountry.DataSource = ContryDs; //BLayer.FillCountry();
ddlCountry.DataValueField = "CountryId";
ddlCountry.DataTextField = "CountryName";
ddlCountry.DataBind();
ddlCountry.Items.Insert(0, new ListItem("--Select Country--", "0"));
ddlState.Items.Clear();
ddlState.Items.Insert(0, new ListItem("---Select State---", "0"));
ddlCity.Items.Clear();
ddlCity.Items.Insert(0, new ListItem("---Select City---", "0"));
//ReportViewer1.ProcessingMode = ProcessingMode.Local;
//ReportViewer1.LocalReport.ReportPath = Server.MapPath("ClientInfo.rdlc");
ReportViewer1.Reset();
TxtClientName.Focus();
}
//protected void GridClient_SelectedIndexChanged(object sender, EventArgs e)
//{
// try
// {
// HidFldId.Value = GridClient.DataKeys[GridClient.SelectedRow.RowIndex].Value.ToString();
// StrSql = new StringBuilder();
// StrSql.Length = 0;
// StrSql.AppendLine("Select C.Id,C.ClientName,C.FirmName,C.EMailId,C.MobNo ");
// StrSql.AppendLine(",Convert(Varchar(10),C.DOJ,103) As DOJ");
// StrSql.AppendLine(",C.CountryId,C.StateId,C.CityId");
// StrSql.AppendLine(",C.Address1,C.PinCode");
// StrSql.AppendLine(",C.Phone,Convert(Varchar(10),C.LeftDate,103) As LeftDate");
// StrSql.AppendLine("From Client_Mast C");
// StrSql.AppendLine("Where C.Id=" + int.Parse(HidFldId.Value));
// dtTemp = new DataTable();
// dtTemp = SqlFunc.ExecuteDataTable(StrSql.ToString());
// if (dtTemp.Rows.Count == 0)
// {
// LblMsg.Text = "Data not found";
// return;
// }
// TxtClientName.Text = dtTemp.Rows[0]["ClientName"].ToString();
// TxtFirmName.Text = dtTemp.Rows[0]["FirmName"].ToString();
// TxtDOJ.Text = dtTemp.Rows[0]["DOJ"].ToString();
// TxtEMailId.Text = dtTemp.Rows[0]["EMailId"].ToString();
// ddlCountry.Items.Clear();
// ddlCountry.DataSource = BLayer.FillCountry();
// ddlCountry.DataValueField = "CountryId";
// ddlCountry.DataTextField = "CountryName";
// ddlCountry.DataBind();
// ddlCountry.Items.Insert(0, new ListItem("--Select Country--", "0"));
// if (dtTemp.Rows[0]["CountryId"].ToString() != "")
// {
// ddlCountry.SelectedValue = dtTemp.Rows[0]["CountryId"].ToString();
// }
// ddlState.Items.Clear();
// ddlState.DataSource = BLayer.FillState(int.Parse(ddlCountry.SelectedValue));
// ddlState.DataValueField = "StateId";
// ddlState.DataTextField = "StateName";
// ddlState.DataBind();
// ddlState.Items.Insert(0, new ListItem("--Select State--", "0"));
// if (dtTemp.Rows[0]["StateID"].ToString() != "")
// {
// ddlState.SelectedValue = dtTemp.Rows[0]["StateID"].ToString();
// }
// ddlCity.Items.Clear();
// ddlCity.DataSource = BLayer.FillCity(int.Parse(ddlState.SelectedValue));
// ddlCity.DataValueField = "CityId";
// ddlCity.DataTextField = "CityName";
// ddlCity.DataBind();
// ddlCity.Items.Insert(0, new ListItem("--Select City--", "0"));
// if (dtTemp.Rows[0]["CityId"].ToString() != "")
// {
// ddlCity.SelectedValue = dtTemp.Rows[0]["CityId"].ToString();
// }
// TxtAddress1.Text = dtTemp.Rows[0]["Address1"].ToString();
// TxtPinCode.Text = dtTemp.Rows[0]["PinCode"].ToString();
// TxtMobNo.Text = dtTemp.Rows[0]["MobNo"].ToString();
// TxtPhone.Text = dtTemp.Rows[0]["Phone"].ToString();
// TxtLeftDate.Text = dtTemp.Rows[0]["LeftDate"].ToString();
// // Move to Edit Tab
// MyMenu.Items[0].ImageUrl = "~/Images/ViewDisable.jpg";
// MyMenu.Items[1].ImageUrl = "~/Images/NewOrEditEnable.jpg";
// MyMenu.Items[1].Selected = true;
// MyMultiView.ActiveViewIndex = 1;
// }
// catch (Exception ex)
// {
// Response.Write(ex.ToString());
// }
//}
protected void BtnNew_Click(object sender, EventArgs e)
{
try
{
ClearAll();
TxtClientName.Focus();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
private void TxtClientName_GotKeyboardFocus(object sender, KeyboardFocusChangedEventArgs e)
{
ImgClientNameError.Visibility = Visibility.Hidden;
TxtClientName.ClearValue(ToolTipProperty);
TxtClientName.ClearValue(BorderBrushProperty);
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
if (TxtClientName.Text.Length == 0)
{
//LblMsg.Text = "Client Name Is Blank, Enter Valid Name....";
TxtClientName.Focus();
return;
}
if (TxtFirmName.Text.Length == 0)
{
//LblMsg.Text = "Firm Name Is Blank, Enter Valid Name....";
TxtFirmName.Focus();
return;
}
if (TxtDOJ.Text.Length == 0)
{
//LblMsg.Text = "Date Of Join Is Blank, Enter Valid Join Date....";
TxtDOJ.Focus();
return;
}
if (TxtEMailId.Text.Length == 0)
{
//LblMsg.Text = "EMail Id Is Blank, Enter Valid EMail Id....";
TxtEMailId.Focus();
return;
}
if (TxtMobNo.Text.Length == 0)
{
//LblMsg.Text = "Mob.No Is Blank, Enter Valid Mob.No....";
TxtMobNo.Focus();
return;
}
StrSql = new StringBuilder();
StrSql.Length = 0;
if (HidFldId.Value.Length == 0)
{
StrSql.AppendLine("Insert Into Client_Mast");
StrSql.AppendLine("(ClientName,FirmName");
StrSql.AppendLine(",DOJ");
StrSql.AppendLine(",EMailId");
StrSql.AppendLine(",CountryId,StateId,CityId");
StrSql.AppendLine(",Address1,PinCode");
StrSql.AppendLine(",MobNo,Phone");
StrSql.AppendLine(",LeftDate");
StrSql.AppendLine(",Entry_Date,Entry_Time");
StrSql.AppendLine(",Entry_UID,UPDFLAG");
StrSql.AppendLine(")");
StrSql.AppendLine("Values(@ClientName,@FirmName");
StrSql.AppendLine(",@DOJ");
StrSql.AppendLine(",@EMailId");
StrSql.AppendLine(",@CountryId,@StateId,@CityId");
StrSql.AppendLine(",@Address1,@PinCode");
StrSql.AppendLine(",@MobNo,@Phone");
StrSql.AppendLine(",@LeftDate");
StrSql.AppendLine(",GetDate(),Convert(VarChar,GetDate(),108)");
StrSql.AppendLine(",@Entry_UID,0)");
}
else
{
StrSql.AppendLine("Update Client_Mast");
StrSql.AppendLine("Set ClientName=@ClientName,FirmName=@FirmName");
StrSql.AppendLine(",DOJ=@DOJ");
StrSql.AppendLine(",EMailId=@EMailId");
StrSql.AppendLine(",CountryId=@CountryId,StateId=@StateId,CityId=@CityId");
StrSql.AppendLine(",Address1=@Address1,PinCode=@PinCode");
StrSql.AppendLine(",MobNo=@MobNo,Phone=@Phone");
StrSql.AppendLine(",LeftDate=@LeftDate");
StrSql.AppendLine(",MEntry_Date=GetDate(),MEntry_Time=Convert(Varchar,GetDate(),108)");
StrSql.AppendLine(",MEntry_UID=@Entry_UID,UPDFLAG=IsNull(UPDFlag,0)+1");
StrSql.AppendLine("Where Id=@Id");
}
Cmd = new SqlCommand(StrSql.ToString(), SqlFunc.gConn);
Cmd.Parameters.AddWithValue("@ClientName", TxtClientName.Text.Trim());
Cmd.Parameters.AddWithValue("@FirmName", TxtFirmName.Text.Trim());
Cmd.Parameters.AddWithValue("@DOJ", ValueConvert.ConvertDate(TxtDOJ.Text));
Cmd.Parameters.AddWithValue("@EMailId", TxtEMailId.Text.Trim());
if (ddlCountry.SelectedValue != "0")
{
Cmd.Parameters.AddWithValue("@CountryId", ddlCountry.SelectedValue);
}
else
{
Cmd.Parameters.AddWithValue("@CountryId", DBNull.Value);
}
if (ddlState.SelectedValue != "0")
{
Cmd.Parameters.AddWithValue("@StateId", ddlState.SelectedValue);
}
else
{
Cmd.Parameters.AddWithValue("@StateId", DBNull.Value);
}
if (ddlCity.SelectedValue != "0")
{
Cmd.Parameters.AddWithValue("@CityId", ddlCity.SelectedValue);
}
else
{
Cmd.Parameters.AddWithValue("@CityId", DBNull.Value);
}
Cmd.Parameters.AddWithValue("@Address1", TxtAddress1.Text.Trim());
Cmd.Parameters.AddWithValue("@PinCode", TxtPinCode.Text.Trim());
Cmd.Parameters.AddWithValue("@MobNo", TxtMobNo.Text.Trim());
Cmd.Parameters.AddWithValue("@Phone", TxtPhone.Text.Trim());
if (TxtLeftDate.Text.Length != 0)
{
Cmd.Parameters.AddWithValue("@LeftDate", ValueConvert.ConvertDate(TxtLeftDate.Text));
}
else
{
Cmd.Parameters.AddWithValue("@LeftDate", DBNull.Value);
}
Cmd.Parameters.AddWithValue("@Entry_UID", HidFldUID.Value.ToString());
if (HidFldId.Value.Length == 0)
{
SqlFunc.ExecuteNonQuery(Cmd);
LblMsg.Text = "Client added successfully";
}
else
{
Cmd.Parameters.AddWithValue("@ID", HidFldId.Value.ToString());
SqlFunc.ExecuteNonQuery(Cmd);
LblMsg.Text = "Client updated successfully";
}
FillGrid();
ClearAll();
// Move to View Tab
MyMenu.Items[0].Selected = true;
MyMenu.Items[0].ImageUrl = "~/Images/ViewEnable.jpg";
MyMultiView.ActiveViewIndex = 0;
MyMenu.Items[1].ImageUrl = "~/Images/NewOrEditDisable.jpg";
}
catch (Exception ex)
{
throw(ex);
}
}
private void ClientClick(UInt32 ClientID_UL)
{
// Load client info in each control
String SQLRequest_ST;
SqlDataReader SqlDataReader_O;
UInt32 TypeSocID_UL = 0;
UInt32 CPID_UL = 0;
int RappConf_i = 0, NoteEnvoi_i = 0, Certif_i = 0;
// Fill info in panel edit controls
mInitializingData_b = true;
TxtClientNumber.Clear();
TxtClientName.Clear();
TxtTel.Clear();
TxtFax.Clear();
TxtAdressFact.Clear();
TxtAdressLivr.Clear();
TxtContactMail.Clear();
TxtContactTel.Clear();
TxtContactName.Clear();
TxtTVA.Clear();
TxtMail.Clear();
TxtRem.Clear();
CheckBoxRappConf.Checked = false;
CheckBoxNE.Checked = false;
CheckBoxCertif.Checked = false;
DBComboxTypeSoc.ClearSelectedItem();
DBComboxCPFact.ClearSelectedItem();
DBComboxCPLivr.ClearSelectedItem();
DBComboxCPLibFact.ClearSelectedItem();
DBComboxCPLibLivr.ClearSelectedItem();
mInitializingData_b = false;
if (mDBManager_O != null && mDBManager_O.mConnected_b)
{
SQLRequest_ST = "SELECT * FROM Client WHERE ClientID=" + ClientID_UL;
SqlDataReader_O = mDBManager_O.Select(SQLRequest_ST);
mInitializingData_b = true;
while (SqlDataReader_O.Read())
{
int.TryParse(SqlDataReader_O["RappConf"].ToString(), out RappConf_i);
int.TryParse(SqlDataReader_O["NoteEnvoi"].ToString(), out NoteEnvoi_i);
int.TryParse(SqlDataReader_O["Certif"].ToString(), out Certif_i);
// Fill info in panel edit controls
TxtClientNumber.Text = SqlDataReader_O["NumClientInterne"].ToString();
TxtClientName.Text = SqlDataReader_O["ClientNom"].ToString();
TxtTel.Text = SqlDataReader_O["ClientTel"].ToString();
TxtFax.Text = SqlDataReader_O["ClientFax"].ToString();
TxtAdressFact.Text = SqlDataReader_O["AdresseFact"].ToString();
TxtAdressLivr.Text = SqlDataReader_O["AdresseLivraison"].ToString();
TxtContactMail.Text = SqlDataReader_O["ContactEmail"].ToString();
TxtContactTel.Text = SqlDataReader_O["ContactTel"].ToString();
TxtContactName.Text = SqlDataReader_O["Contact"].ToString();
TxtTVA.Text = SqlDataReader_O["NrTVA"].ToString();
TxtMail.Text = SqlDataReader_O["ClientMail"].ToString();
TxtRem.Text = SqlDataReader_O["ClientRem"].ToString();
CheckBoxRappConf.Checked = RappConf_i != 0 ? true : false;
CheckBoxNE.Checked = NoteEnvoi_i != 0 ? true : false;
CheckBoxCertif.Checked = Certif_i != 0 ? true : false;
if (UInt32.TryParse(SqlDataReader_O["TypeSocID"].ToString(), out TypeSocID_UL))
{
DBComboxTypeSoc.SelectItemByID(TypeSocID_UL);
}
if (UInt32.TryParse(SqlDataReader_O["CodePostalFactID"].ToString(), out CPID_UL))
{
DBComboxCPFact.SelectItemByID(CPID_UL);
DBComboxCPLibFact.SelectItemByID(CPID_UL);
}
else
{
DBComboxCPFact.ClearSelectedItem();
DBComboxCPLibFact.ClearSelectedItem();
}
if (UInt32.TryParse(SqlDataReader_O["CodePostalLivraisonID"].ToString(), out CPID_UL))
{
DBComboxCPLivr.SelectItemByID(CPID_UL);
DBComboxCPLibLivr.SelectItemByID(CPID_UL);
}
else
{
DBComboxCPLivr.ClearSelectedItem();
DBComboxCPLibLivr.ClearSelectedItem();
}
// Refresh job recap
if (!String.IsNullOrEmpty(SqlDataReader_O["ClientNom"].ToString()))
{
DBListViewComjobRecap.SetInitialFilter("ClientNom='" + SqlDataReader_O["ClientNom"].ToString() + "'", "DelaiPromis desc");
DBListViewComjobRecap.Refresh();
}
}
SqlDataReader_O.Close();
mInitializingData_b = false;
}
}
