public AdHocSearchResults GetAdHocPaymentDetails(int PaymentListID)
{
AdHocSearchResults ObjResult = new AdHocSearchResults();
try
{
if (SessionManager.IsValidSession(UserSessionId))
{
Exception error = null;
ObjResult = dal.GetAdHocPaymentDetails(PaymentListID, out error);
if (error == null)
{
return(ObjResult);
}
else
{
throw error;
}
}
else
{
SessionManager.RemoveSession(UserSessionId, true);
return(ObjResult);
}
}
catch (Exception)
{
throw;
}
}
public string SaveAdHocDetails(AdHocSearchResults InputData)
{
string returnvalue = string.Empty;
try
{
if (SessionManager.IsValidSession(UserSessionId))
{
Exception error = null;
if (InputData.PaymentListId > 0)
{
returnvalue = dal.UpdateAdHocDetails(InputData, out error);
}
else
{
returnvalue = dal.SaveAdHocDetails(InputData, out error);
}
if (error == null)
{
return(returnvalue);
}
else
{
throw error;
}
}
else
{
SessionManager.RemoveSession(UserSessionId, true);
return(returnvalue);
}
}
catch (Exception)
{
throw;
}
}
public AdHocSearchResults GetAdHocPaymentDetails(int PaymentListID, out Exception error)
{
try
{
AdHocSearchResults returnValue = new AdHocSearchResults();
error = null;
try
{
using (DbCommand command = _db.GetStoredProcCommand(Constants.SpGetAdHocPaymentDetails))
{
using (DbConnection connection = _db.CreateConnection())
{
connection.Open();
command.Connection = connection;
var parameter = command.CreateParameter();
parameter.ParameterName = "@PaymentListID";
parameter.Value = PaymentListID;
command.Parameters.Add(parameter);
using (IDataReader reader = _db.ExecuteReader(command))
{
while (reader.Read())
{
returnValue.PaymentMemoId = Convert.ToInt32(reader["PaymentMemoId"]);
returnValue.SchemeId = Convert.ToInt32(reader["SchemeId"]);
returnValue.SchemeName = reader["SchemeName"].ToString();
returnValue.ARNNo = reader["ARNNo"].ToString();
returnValue.ARNName = reader["ARNName"].ToString();
returnValue.DateFrom = reader["DateFrom"].ToString();
returnValue.DateTo = reader["DateTo"].ToString();
returnValue.MemoTypeID = Convert.ToInt32(reader["MemoTypeID"]);
returnValue.BranchId = Convert.ToInt32(reader["BranchId"]);
returnValue.AmountBasisName = reader["AmountBasisName"].ToString();
returnValue.PaymentAmount = reader["PaymentAmount"].ToString();
returnValue.Rate = reader["Rate"].ToString();
returnValue.MobilizationAmount = reader["MobilizationAmount"].ToString();
returnValue.FreeTextField1 = reader["FreeTextField1"].ToString();
returnValue.FreeTextField2 = reader["FreeTextField2"].ToString();
returnValue.Remarks = reader["Remarks"].ToString();
returnValue.PanNumber = reader["PanNumber"].ToString();
//returnValue.ChannelName = reader["Channel"].ToString();
//returnValue.ChannelName = string.Empty;
returnValue.SchemeCategoryId = Convert.ToInt32(reader["SchemeCategoryId"]);
}
}
connection.Close();
}
}
}
catch (InvalidOperationException invalid)
{
error = invalid;
}
catch (Exception ex)
{
error = ex;
}
return(returnValue);
}
catch (Exception)
{
throw;
}
}
public string SaveAdHocDetails(AdHocSearchResults InputData, out Exception error)
{
string Output = string.Empty;
try
{
error = null;
try
{
using (DbCommand command = _db.GetStoredProcCommand(Constants.SpInsertAdHocDetails))
{
using (DbConnection connection = _db.CreateConnection())
{
connection.Open();
command.Connection = connection;
var parameter = command.CreateParameter();
parameter.ParameterName = "@ARNNO";
parameter.Value = InputData.ARNNo;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@MemoTypeID";
parameter.Value = InputData.MemoTypeID;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@SchemeID";
parameter.Value = InputData.SchemeId;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@SchemeCategoryID";
parameter.Value = InputData.SchemeCategoryId;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@PeriodFrom";
parameter.Value = (InputData.DateFrom == "" ? null : DateTime.ParseExact(InputData.DateFrom.Insert(6, "20"), "dd/MM/yyyy", CultureInfo.InvariantCulture).ToString("MM/dd/yyyy", CultureInfo.InvariantCulture));
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@PeriodTo";
parameter.Value = (InputData.DateTo == "" ? null : DateTime.ParseExact(InputData.DateTo.Insert(6, "20"), "dd/MM/yyyy", CultureInfo.InvariantCulture).ToString("MM/dd/yyyy", CultureInfo.InvariantCulture));
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@BranchID";
parameter.Value = InputData.BranchId;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@AmountBasis";
parameter.Value = InputData.AmountBasisName;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@MobilizationAmount";
parameter.Value = InputData.MobilizationAmount;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@Rate";
parameter.Value = InputData.Rate;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@PanNumber";
parameter.Value = InputData.PanNumber;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@PaymentAmount";
parameter.Value = InputData.PaymentAmount;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@FreeTextOne";
parameter.Value = InputData.FreeTextField1;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@FreeTextTwo";
parameter.Value = InputData.FreeTextField2;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@MemoStatus";
parameter.Value = InputData.MemoStatus;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@IsActive";
parameter.Value = true;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@CreatedBy";
parameter.Value = UserId;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@Remarks";
parameter.Value = InputData.Remarks;
command.Parameters.Add(parameter);
Output = command.ExecuteScalar().ToString();
//if (Output == "Inserted Successfully")
// returnValue = true;
//else if (Output == "Inserted Successfully")
//else
// returnValue = false;
connection.Close();
}
}
}
catch (InvalidOperationException invalid)
{
error = invalid;
}
catch (Exception ex)
{
error = ex;
}
return(Output);
}
catch (Exception)
{
throw;
}
}
public List <AdHocSearchResults> GetAdHocDetails(int PaymentTypeID, string AdhocStatus, int AdhocBatchID, int CreatedByID, string SearchFilter, out Exception error)
{
try
{
List <AdHocSearchResults> returnValue = new List <AdHocSearchResults>();
error = null;
try
{
using (DbCommand command = _db.GetStoredProcCommand(Constants.SpGetAdHocDetails))
{
using (DbConnection connection = _db.CreateConnection())
{
connection.Open();
command.Connection = connection;
var parameter = command.CreateParameter();
parameter.ParameterName = "@PaymentTypeID";
parameter.Value = PaymentTypeID;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@AdhocStatus";
parameter.Value = AdhocStatus;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@AdhocBatchID";
parameter.Value = AdhocBatchID;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@CreatedByID";
parameter.Value = UserId;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@SearchFilter";
parameter.Value = SearchFilter;
command.Parameters.Add(parameter);
//using (IDataReader reader = _db.ExecuteReader(command))
//{
// returnValue = Conversion.ConvertDataReaderToList<AdHocSearchResults>(reader);
//}
using (IDataReader reader = _db.ExecuteReader(command))
{
while (reader.Read())
{
AdHocSearchResults temp = new AdHocSearchResults();
temp.SerialNo = Convert.ToInt32(reader["SerialNo"]);
temp.PaymentMemoId = Convert.ToInt32(reader["PaymentMemoId"]);
temp.PaymentListId = Convert.ToInt32(reader["PaymentListId"]);
temp.SchemeId = Convert.ToInt32(reader["SchemeId"]);
temp.SchemeName = reader["Scheme"].ToString();
temp.ARNNo = reader["ARNNo"].ToString();
temp.ARNName = reader["ARNName"].ToString();
temp.DateFrom = reader["DateFrom"].ToString();
temp.DateTo = reader["DateTo"].ToString();
temp.PaymentAmount = reader["PaymentAmount"].ToString();
temp.BranchId = Convert.ToInt32(reader["BranchId"]);
temp.BranchName = reader["Branch"].ToString();
temp.MemoTypeID = Convert.ToInt32(reader["MemoTypeID"]);
temp.MemoTypeName = reader["MemoType"].ToString();
temp.AmountBasisID = Convert.ToInt32(reader["AmountBasisID"]);
temp.AmountBasisName = reader["AmountBasis"].ToString();
temp.MobilizationAmount = reader["AUM_Gross_Sales"].ToString();
temp.Rate = reader["Rate"].ToString();
temp.Remarks = reader["Remarks"].ToString();
temp.MemoNumber = reader["MemoNumber"].ToString();
temp.DistributorCategoryId = reader["DistributorCategoryId"].ToString();
temp.DistributorCategoryName = reader["DistributorCategoryName"].ToString();
temp.CreatedByName = reader["RaisedBy"].ToString();
temp.MemoStatus = reader["MemoStatus"].ToString();
temp.FreeTextField1 = reader["ActualAmountPayable"].ToString();
temp.FreeTextField2 = reader["FreeTextField2"].ToString();
temp.PanNumber = reader["PanNumber"].ToString();
temp.IsRequired = Convert.ToBoolean(reader["IsRequired"]);
temp.MemoStatusDisplay = reader["MemoStatusDisplay"].ToString();
temp.RaisedOnDate = reader["RaisedOnDate"].ToString();
temp.RaisedOnTime = reader["RaisedOnTime"].ToString();
temp.Ageing = Convert.ToInt32(reader["Ageing"]);
temp.ModifiedByName = reader["ModifiedByName"].ToString();
temp.SchemeCategoryId = Convert.ToInt32(reader["SchemeCategoryId"]);
temp.ChannelName = reader["Channel"].ToString();
temp.RaisedByEmail = reader["RaisedByEmail"].ToString();
returnValue.Add(temp);
}
}
connection.Close();
}
}
}
catch (InvalidOperationException invalid)
{
error = invalid;
}
catch (Exception ex)
{
error = ex;
}
return(returnValue);
}
catch (Exception)
{
throw;
}
}
