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);
}
}
