public long InsertUpdateSmsConfigDetails(SMSBE.SmsConfigurationBE _objSmsBE) { return(_objSmcDL.InsertUpdateSmsConfigDetails(_objSmsBE)); }
public long InsertUpdateSmsConfigDetails(SMSBE.SmsConfigurationBE _objSmsBE) { try { long returnValue = 0; SqlParameter ParamAutoID = new SqlParameter("@AutoID", SqlDbType.Int); ParamAutoID.Value = _objSmsBE.AutoID; SqlParameter ParameServerID = new SqlParameter("@sC_ServerDetail", SqlDbType.NVarChar); ParameServerID.Value = _objSmsBE.sC_ServerDetail; SqlParameter ParamUserName = new SqlParameter("@sC_UserName", SqlDbType.NVarChar); ParamUserName.Value = _objSmsBE.sC_UserName; SqlParameter ParamPassword = new SqlParameter("@sC_Password", SqlDbType.NVarChar); ParamPassword.Value = _objSmsBE.sC_Password; SqlParameter ParamClientID = new SqlParameter("@sC_ClientID", SqlDbType.Int); ParamClientID.Value = _objSmsBE.sC_ClientID; SqlParameter ParamCompanyId = new SqlParameter("@CompanyId", SqlDbType.Int); ParamCompanyId.Value = _objSmsBE.CompanyId; SqlParameter ParamLocationId = new SqlParameter("@LocationId", SqlDbType.Int); ParamLocationId.Value = _objSmsBE.LocationId; SqlParameter ParamisActive = new SqlParameter("@sC_isActive", SqlDbType.Bit); ParamisActive.Value = _objSmsBE.sC_isActive; SqlParameter ParamisDefault = new SqlParameter("@sC_isDefault", SqlDbType.Bit); ParamisDefault.Value = _objSmsBE.sC_isDefault; SqlParameter ParamAddeddBy = new SqlParameter("@AddedBy", SqlDbType.Int); ParamAddeddBy.Value = _objSmsBE.AddeddBy; SqlParameter ParamModifiedBy = new SqlParameter("@LastModifiedBy", SqlDbType.Int); ParamModifiedBy.Value = _objSmsBE.ModifiedBy; SqlParameter ParamAddeddOn = new SqlParameter("@AddedOn", SqlDbType.DateTime); ParamAddeddOn.Value = _objSmsBE.AddeddOn; SqlParameter ParamModifiedOn = new SqlParameter("@LastModifiedOn", SqlDbType.DateTime); ParamModifiedOn.Value = _objSmsBE.ModifiedOn; SqlParameter paramsC_status = new SqlParameter("@sC_status", SqlDbType.Bit); paramsC_status.Value = 1; SqlParameter paramSuccess = new SqlParameter("@success", SqlDbType.Bit); paramSuccess.Value = 0; paramSuccess.Direction = ParameterDirection.Output; SqlParameter[] _parameter = { ParamAutoID, ParameServerID, ParamUserName, ParamPassword, ParamClientID, ParamCompanyId, ParamLocationId, ParamisActive, ParamisDefault, ParamAddeddBy, ParamModifiedBy, ParamAddeddOn, ParamModifiedOn, paramsC_status, paramSuccess }; returnValue = _objComDL.executeReturnLongNonSelectQuery("[EINS_RBMS_SMS].[dbo].Isp_SMSConfiguration", _parameter); return(returnValue); } catch { return(0); } }