protected void BtnNew_Click(object sender, EventArgs e)
{
try
{
ClearAll();
TxtCompName.Focus();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
if (TxtCompName.Text.Length == 0)
{
//LblMsg.Text = "Company Name Is Blank, Enter Valid Company Name....";
TxtCompName.Focus();
return;
}
if (TxtStartDate.Text.Length == 0)
{
//LblMsg.Text = "Start Date Is Blank, Enter Valid Start Date....";
TxtStartDate.Focus();
return;
}
if (TxtMobNo.Text.Length == 0)
{
//LblMsg.Text = "Mob.No Is Blank, Enter Valid Mob.No....";
TxtMobNo.Focus();
return;
}
if (TxtEMailId.Text.Length == 0)
{
// LblMsg.Text = "Email Id Is Blank, Enter Valid Email Id....";
TxtEMailId.Focus();
return;
}
StrSql = new StringBuilder();
StrSql.Length = 0;
if (HidFldId.Value.Length == 0)
{
StrSql.AppendLine("Insert Into Com_Mast (CompName,StartDate");
StrSql.AppendLine(",CountryId,StateId ");
StrSql.AppendLine(",CityId,Address1,PinCode");
StrSql.AppendLine(",MobNo,Phone,EMailId");
StrSql.AppendLine(",WebSite");
StrSql.AppendLine(",Entry_Date,Entry_Time");
StrSql.AppendLine(",Entry_UID,UPDFLAG)");
StrSql.AppendLine("Values(@CompName,@StartDate");
StrSql.AppendLine(",@CountryId,@StateId ");
StrSql.AppendLine(",@CityId,@Address1,@PinCode");
StrSql.AppendLine(",@MobNo,@Phone,@EMailId");
StrSql.AppendLine(",@WebSite");
StrSql.AppendLine(",GetDate(),Convert(VarChar,GetDate(),108)");
StrSql.AppendLine(",@Entry_UID,0)");
}
else
{
StrSql.AppendLine("Update Com_Mast Set CompName=@CompName,StartDate=@StartDate");
StrSql.AppendLine(",CountryId=@CountryId,StateId=@StateId ");
StrSql.AppendLine(",CityId=@CityId,Address1=@Address1,PinCode=@PinCode");
StrSql.AppendLine(",MobNo=@MobNo,Phone=@Phone,EMailId=@EMailId");
StrSql.AppendLine(",WebSite=@WebSite");
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("@CompName", TxtCompName.Text.Trim());
Cmd.Parameters.AddWithValue("@StartDate", ValueConvert.ConvertDate(TxtStartDate.Text));
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());
Cmd.Parameters.AddWithValue("@WebSite", TxtWebSite.Text.Trim());
Cmd.Parameters.AddWithValue("@EMailId", TxtEMailId.Text.Trim());
Cmd.Parameters.AddWithValue("@Entry_UID", HidFldUID.Value.ToString());
if (HidFldId.Value.Length == 0)
{
SqlFunc.ExecuteNonQuery(Cmd);
LblMsg.Text = "Company added successfully";
}
else
{
Cmd.Parameters.AddWithValue("@ID", HidFldId.Value.ToString());
SqlFunc.ExecuteNonQuery(Cmd);
LblMsg.Text = "Company updated successfully";
}
FillGrid();
ClearAll();
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)
{
Response.Write(ex);
}
}
