示例#1
0
    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);
        }
    }
示例#2
0
    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);
        }
    }
示例#3
0
    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);
        }
    }