public Resultset <Object> ExecuteScalar(string storedProcName, DBParams parameterValues)
{
//bool IsTrans = false;
DBParams retVal = new DBParams();
Object retScalarValue;
SqlCommand cmd = GetCommand(CommandType.StoredProcedure, storedProcName);
//ravi patel
//AddErrorParameter(parameterValues);
retVal = AddParameters(parameterValues, cmd);
if (objTrans != null)
{
PrepareCommand(cmd, true);
}
else
{
PrepareCommand(cmd, false);
}
//cmd.CommandTimeout = objTrans.Connection.ConnectionTimeout;
retScalarValue = DoExecuteScalar(cmd);
foreach (SqlParameter pRetVal in retVal)
{
pRetVal.Value = this.GetParameterValue(cmd, pRetVal.ParameterName);
}
Resultset <Object> retResultset;
retResultset = new Resultset <Object>(retScalarValue, retVal);
return(retResultset);
}
public Resultset <DataSet> ExecuteDataSet(string storedProcName, DBParams parameterValues)
{
DataSet retResultset = new DataSet();
DBParams retVal;
SqlCommand cmd = GetCommand(CommandType.StoredProcedure, storedProcName);
cmd.CommandTimeout = 43200000;
// AddErrorParameter(parameterValues);
retVal = AddParameters(parameterValues, cmd);
if (objTrans != null)
{
PrepareCommand(cmd, true);
}
else
{
PrepareCommand(cmd, false);
}
DoLoadDataSet(cmd, retResultset, new string[] { "Table" });
foreach (SqlParameter pRetVal in retVal)
{
pRetVal.Value = GetParameterValue(cmd, pRetVal.ParameterName);
}
Resultset <DataSet> objReturnValue;
objReturnValue = new Resultset <DataSet>(retResultset, retVal);
return(objReturnValue);
}
public static async Task <GeneralResponse> ProcessGenerateOTPRequest(OTPRequest _req, OTPEmailSender sender, DBContext _dBContext)
{
OTPRequest _otpReq = _req;
GeneralResponse _resp = null;
//write request to queue.
//string _msg = JsonConvert.SerializeObject(_req);
//Generate OTP here
_req._reqid = UniqueCodeGenerator.GetUniqueCodeForRequest();
_req._emailotp = GenerateOTP();
_req._mobileotpCode = GenerateOTP();
_req.ParkDB = _dBContext;
DBParams param1 = new DBParams();
param1.FieldName = "fsReqId";
param1.FieldValue = _req._reqid;
DBParams param2 = new DBParams();
param2.FieldName = "fsMobileNo";
param2.FieldValue = _req.Mobile;
DBParams param3 = new DBParams();
param3.FieldName = "fsEmail";
param3.FieldValue = _req.Email;
DBParams param4 = new DBParams();
param4.FieldName = "fsMobileOTP";
param4.FieldValue = _req._mobileotpCode;
DBParams param5 = new DBParams();
param5.FieldName = "fsEmailOTP";
param5.FieldValue = _req._emailotp;
int _retCode = await _req.InsertAsync(param1, param2, param3, param4, param5);
#if DIRECTMAIL
EmailMessage _message = new EmailMessage();
_message.To = _req.Email;
_message.Subject = "Account Activatio Code from StarParkz";
_message.Body = _req._emailotp;
await sender.SendEmailAsync(_message);
#endif
//QM.WriteStringToQueue(_msg);
//var t = Task.Run(() => _resp = new GeneralResponseMsg() { RespCode = (int)RESPONSE.OTPRESPONSE, RespMsg = PREDEFINEDMESSAGE.MOBILE_OTP_GENERATED, Data = "OK" });
//t.Wait();
return(_resp);
//validation to check if user exist or not. If exist return message that user already exist else proceed with OTP generation.
//we are going to write the code to generate the OTP.
// User the API to send the otp to the mobile number
// also save the OTP in the database against mobile number. There has to be a time also for OTP expiration.
//throw new Exception("Error");
}
public DBParams ExecuteNonQuery(string storedProcName, DBParams parameterValues)
{
if (objTrans != null)
{
return(ExecuteNonQuery(storedProcName, parameterValues, true));
}
else
{
return(ExecuteNonQuery(storedProcName, parameterValues, false));
}
}
private void create_db_btn_Click(object sender, EventArgs e)
{
if (textbox_servername.Text == "" /* ||
* textbox_dbfilename.Text == "" */||
textbox_dbname.Text == "" /* ||
* textbox_userid.Text == "" ||
* textbox_userpwd.Text == ""*/)
{
MessageBox.Show("Fill in all the required fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DBParams dbParams = new DBParams(textbox_servername.Text, textbox_dbname.Text, textbox_dbname.Text,
textbox_dbfilename.Text, "", "", textbox_userid.Text, textbox_userpwd.Text);
Database newDB = new Database(dbParams);
newDB.CreateDatabase(GlobalContext.masterParams);
GlobalContext.Databases.Add(newDB);
}
public DBParams ExecuteNonQuery(string storedProcName, DBParams parameterValues, bool IsTransaction)
{
bool IsTrans = IsTransaction;
DBParams retVal = new DBParams();
int rowsAffected;
SqlCommand cmd = GetCommand(CommandType.StoredProcedure, storedProcName);
//ravi patel
//AddErrorParameter(parameterValues);
retVal = AddParameters(parameterValues, cmd);
PrepareCommand(cmd, IsTrans);
//cmd.CommandTimeout = objTrans.Connection.ConnectionTimeout;
rowsAffected = DoExecuteNonQuery(cmd);
foreach (SqlParameter pRetVal in retVal)
{
pRetVal.Value = this.GetParameterValue(cmd, pRetVal.ParameterName);
}
return(retVal);
}
private DBParams AddParameters(DBParams parameterValues, SqlCommand cmd)
{
DBParams retVal = new DBParams();
string parameterprefix = ConfigurationManager.AppSettings["ParameterPrefix"].ToString();
foreach (SqlParameter pval in parameterValues)
{
pval.ParameterName = pval.ParameterName.Replace("@", parameterprefix);
switch (pval.Direction)
{
case ParameterDirection.Input:
//cmd.Parameters.Add(pval);
AddParameter(pval, cmd);
break;
case ParameterDirection.InputOutput:
//cmd.Parameters.Add(pval);
AddParameter(pval, cmd);
retVal.Add(pval);
break;
case ParameterDirection.Output:
//cmd.Parameters.Add(pval);
AddParameter(pval, cmd);
retVal.Add(pval);
break;
case ParameterDirection.ReturnValue:
//cmd.Parameters.Add(pval);
AddParameter(pval, cmd);
retVal.Add(pval);
break;
default:
break;
}
}
return(retVal);
}
public Resultset <SqlDataReader> ExecuteDataReader(string storedProcName, DBParams parameterValues)
{
SqlDataReader oDataReader;
DBParams retParams;
SqlCommand cmd = GetCommand(CommandType.StoredProcedure, storedProcName);
cmd.CommandTimeout = 43200000;
//ravi patel
//AddErrorParameter(parameterValues);
retParams = AddParameters(parameterValues, cmd);
if (objTrans != null)
{
PrepareCommand(cmd, true);
}
else
{
PrepareCommand(cmd, false);
}
//if (Transaction.Current != null)
if (objTrans != null)
{
oDataReader = DoExecuteReader(cmd, CommandBehavior.Default);
}
else
{
oDataReader = DoExecuteReader(cmd, CommandBehavior.Default);
}
//CloseConnection();
foreach (SqlParameter pRetVal in retParams)
{
pRetVal.Value = GetParameterValue(cmd, pRetVal.ParameterName);
}
Resultset <SqlDataReader> objReturnValue;
objReturnValue = new Resultset <SqlDataReader>(oDataReader, retParams);
return(objReturnValue);
}
public static Resultset <DataSet> GetDataSetWithStoreprocedure(String strStoreProceureName, DBParams dbpParameterName)
{
MasterDal oDal = new MasterDal();
Resultset <DataSet> oDStore = oDal.ExecuteDataSet(strStoreProceureName, dbpParameterName);
oDal.Dispose();
oDal = null;
return(oDStore);
}
public static void ExceteQueryWithStoreprocedure(String strStoreProceureName, DBParams dbpParameterName)
{
MasterDal oDal = new MasterDal();
oDal.ExecuteNonQuery(strStoreProceureName, dbpParameterName);
oDal.Dispose();
oDal = null;
//return oDStore;
}
