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);
}
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
try
{
if (TxtName.Text.Length == 0)
{
TxtName.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 ContactDet");
StrSql.AppendLine("(Name,EMailId,WebSite,MobNo,Msg,Contact_Status");
StrSql.AppendLine(",Entry_Date,Entry_Time,UPDFLAG");
StrSql.AppendLine(")");
StrSql.AppendLine("Values(@Name,@EMailId,@WebSite");
StrSql.AppendLine(",@MobNo,@Msg,@Contact_Status");
StrSql.AppendLine(",GetDate(),Convert(VarChar,GetDate(),108),0");
StrSql.AppendLine(")");
Cmd = new SqlCommand(StrSql.ToString(), SqlFunc.gConn);
Cmd.Parameters.AddWithValue("@Name", TxtName.Text.Trim());
Cmd.Parameters.AddWithValue("@EMailId", TxtEMailId.Text.Trim());
Cmd.Parameters.AddWithValue("@WebSite", TxtWebSite.Text.Trim());
Cmd.Parameters.AddWithValue("@MobNo", TxtMobNo.Text.Trim());
Cmd.Parameters.AddWithValue("@Msg", TxtMsg.Text.Trim());
Cmd.Parameters.AddWithValue("@Contact_Status", DdlContactStat.SelectedValue.ToString());
SqlFunc.ExecuteNonQuery(Cmd);
LblMsg.Text = "Entry added successfully";
}
else
{
StrSql.AppendLine("Update ContactDet");
StrSql.AppendLine("Set Contact_Status=@Contact_Status");
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("@Contact_Status", DdlContactStat.SelectedValue.ToString());
Cmd.Parameters.AddWithValue("@Entry_UID", HidFldUID.Value.ToString());
Cmd.Parameters.AddWithValue("@ID", HidFldId.Value.ToString());
SqlFunc.ExecuteNonQuery(Cmd);
LblMsg.Text = "Employee updated successfully";
}
ClearAll();
}
catch (Exception ex)
{
Response.Write(ex);
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
if (TxtUserId.Text.Length == 0)
{
// LblMsg.Text = "User Id Is Blank, Enter Valid User Id....";
TxtUserId.Focus();
return;
}
if (TxtUserName.Text.Length == 0)
{
// LblMsg.Text = "User Name Is Blank, Enter Valid User Name....";
TxtUserName.Focus();
return;
}
if (TxtLoginName.Text.Length == 0)
{
//LblMsg.Text = "Login Name Is Blank, Enter Valid Login Name....";
TxtLoginName.Focus();
return;
}
if (DDLUserGroup.SelectedValue == "0")
{
//LblMsg.Text = "Select User Group....";
DDLUserGroup.Focus();
return;
}
if (TxtDOB.Text.Length == 0)
{
//LblMsg.Text = "DOB Is Blank, Enter Valid Brith Date....";
TxtDOB.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;
}
if (TxtPassword.Text.Length == 0)
{
//LblMsg.Text = "Password Is Blank, Enter Valid Password....";
TxtPassword.Focus();
return;
}
if (TxtQuestion.Text.Length == 0)
{
//LblMsg.Text = "Question Is Blank, Enter Valid Question....";
TxtQuestion.Focus();
return;
}
if (TxtAnswer.Text.Length == 0)
{
//LblMsg.Text = "Answer Is Blank, Enter Valid Answer....";
TxtAnswer.Focus();
return;
}
StrSql = new StringBuilder();
StrSql.Length = 0;
if (HidFldId.Value.Length == 0)
{
StrSql.AppendLine("Insert Into User_Mast (UId,UserName,LoginName");
StrSql.AppendLine(",UserGroup,Password ");
StrSql.AppendLine(",Gender,EMailId,DOB");
StrSql.AppendLine(",CountryId,StateId,CityId");
StrSql.AppendLine(",MobNo,Phone");
StrSql.AppendLine(",Question,Answer");
StrSql.AppendLine(",Activation");
StrSql.AppendLine(",Entry_Date,Entry_Time");
StrSql.AppendLine(",Entry_UID,UPDFLAG)");
StrSql.AppendLine("Values(@UserId,@UserName,@LoginName");
StrSql.AppendLine(",@UserGroup,@Password ");
StrSql.AppendLine(",@Gender,@EMailId,@DOB");
StrSql.AppendLine(",@CountryId,@StateId,@CityId");
StrSql.AppendLine(",@MobNo,@Phone");
StrSql.AppendLine(",@Question,@Answer");
StrSql.AppendLine(",@Activation");
StrSql.AppendLine(",GetDate(),Convert(VarChar,GetDate(),108)");
StrSql.AppendLine(",@Entry_UID,0)");
}
else
{
StrSql.AppendLine("Update User_Mast Set UId=@UserId,UserName=@UserName,LoginName=@LoginName");
StrSql.AppendLine(",UserGroup=@UserGroup,Password=@Password ");
StrSql.AppendLine(",Gender=@Gender,EMailId=@EMailId,DOB=@DOB");
StrSql.AppendLine(",CountryId=@CountryId,StateId=@StateId,CityId=@CityId");
StrSql.AppendLine(",MobNo=@MobNo,Phone=@Phone");
StrSql.AppendLine(",Question=@Question,Answer=@Answer");
StrSql.AppendLine(",Activation=@Activation");
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("@UserId", TxtUserId.Text.Trim());
Cmd.Parameters.AddWithValue("@UserName", TxtUserName.Text.Trim());
Cmd.Parameters.AddWithValue("@LoginName", TxtLoginName.Text.Trim());
Cmd.Parameters.AddWithValue("@UserGroup", DDLUserGroup.SelectedValue);
Cmd.Parameters.AddWithValue("@Password", Sec.Encrypt(TxtPassword.Text.Trim()));
Cmd.Parameters.AddWithValue("@Gender", rblGender.SelectedValue);
Cmd.Parameters.AddWithValue("@EMailId", TxtEMailId.Text.Trim());
Cmd.Parameters.AddWithValue("@DOB", ValueConvert.ConvertDate(TxtDOB.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("@MobNo", TxtMobNo.Text.Trim());
Cmd.Parameters.AddWithValue("@Phone", TxtPhone.Text.Trim());
Cmd.Parameters.AddWithValue("@Question", TxtQuestion.Text.Trim());
Cmd.Parameters.AddWithValue("@Answer", TxtAnswer.Text.Trim());
Cmd.Parameters.AddWithValue("@Activation", 0);
Cmd.Parameters.AddWithValue("@Entry_UID", HidFldUID.Value.ToString());
if (HidFldId.Value.Length == 0)
{
SqlFunc.ExecuteNonQuery(Cmd);
LblMsg.Text = "User added successfully";
}
else
{
Cmd.Parameters.AddWithValue("@ID", HidFldId.Value.ToString());
SqlFunc.ExecuteNonQuery(Cmd);
LblMsg.Text = "User 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);
}
}