public async Task <MsgRetriever> SaveMilestoneMerchant(Milestone _milestone)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
await objDataEngine.InitiateConnectionAsync();
SqlParameter[] Parameters = new SqlParameter[12];
Parameters[0] = new SqlParameter("@Id", ConvertLongToDb(_milestone.ID));
Parameters[1] = String.IsNullOrEmpty(_milestone.SelectedTaskNo) ? new SqlParameter("@TaskNo", DBNull.Value) : new SqlParameter("@TaskNo", _milestone.SelectedTaskNo);//new SqlParameter("@TaskNo", ConvertIntToDb(_milestone.SelectedTaskNo));
Parameters[2] = new SqlParameter("@RefKey", ConvertLongToDb(_milestone.aprId));
Parameters[3] = String.IsNullOrEmpty(_milestone.RefNo) ? new SqlParameter("@RefNo", DBNull.Value) : new SqlParameter("@RefNo", _milestone.RefNo);
Parameters[4] = String.IsNullOrEmpty(_milestone.selectedOwner) ? new SqlParameter("@Owner", DBNull.Value) : new SqlParameter("@Owner", _milestone.selectedOwner);
Parameters[5] = String.IsNullOrEmpty(_milestone.selectedPriority) ? new SqlParameter("@Priority", DBNull.Value) : new SqlParameter("@Priority", _milestone.selectedPriority); //new SqlParameter("@Priority", ConvertIntToDb(_milestone.selectedPriority));
Parameters[6] = String.IsNullOrEmpty(_milestone.Remarks) ? new SqlParameter("@Remarks", DBNull.Value) : new SqlParameter("@Remarks", _milestone.Remarks);
Parameters[7] = String.IsNullOrEmpty(_milestone.selectedReasonCd) ? new SqlParameter("@ReasonCd", DBNull.Value) : new SqlParameter("@ReasonCd", _milestone.selectedReasonCd);
Parameters[8] = new SqlParameter("@RecallDate", ConvertDatetimeDB(_milestone.RecallDate));
Parameters[9] = String.IsNullOrEmpty(_milestone.selectedStatus) ? new SqlParameter("@Sts", DBNull.Value) : new SqlParameter("@Sts", _milestone.selectedStatus);
Parameters[10] = String.IsNullOrEmpty(this.GetUserId) ? new SqlParameter("@UserId", DBNull.Value) : new SqlParameter("@UserId", this.GetUserId);
Parameters[11] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[11].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebMilestoneMerchAdjustmentApproval", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <List <LookupParameters> > WebEventTypeListSelect()
{
var objEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
await objEngine.InitiateConnectionAsync();
var getObjData = await objEngine.ExecuteCommandAsync("[WebEventTypeListSelect]", CommandType.StoredProcedure);
var list = new List <LookupParameters>();
while (getObjData.Read())
{
var item = new LookupParameters
{
EventTypeId = Convert.ToString(getObjData["ID"]),
SelectedEventType = Convert.ToString(getObjData["Type"]),
ShortDescp = Convert.ToString(getObjData["Short Description"]),
DetailedDescp = Convert.ToString(getObjData["Detailed Description"]),
SelectedStatus = Convert.ToString(getObjData["Status"]),
LastUpdated = DateConverter(getObjData["Update Date"]),
UpdatedBy = Convert.ToString(getObjData["Update By"])
};
list.Add(item);
}
return(list);
}
finally
{
objEngine.CloseConnection();
}
}
public async Task <List <TmplDisplayer> > WebEventTypeTemplateSelect(string EventTypeId)
{
var objEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
await objEngine.InitiateConnectionAsync();
SqlParameter[] Parameters = new SqlParameter[1];
Parameters[0] = new SqlParameter("@EventTypeId", EventTypeId);
var execResult = await objEngine.ExecuteCommandAsync("WebEventTypeTemplateSelect", CommandType.StoredProcedure, Parameters);
var _Parameters = new TmplDisplayer();
var list = new List <TmplDisplayer>();
while (execResult.Read())
{
_Parameters = new TmplDisplayer
{
ContentTmplt = Convert.ToString(execResult["Template Displayer"]),
Descp = Convert.ToString(execResult["Descp"]),
LangInd = Convert.ToString(execResult["Template Language Indicator"]),
Type = Convert.ToString(execResult["Type"])
};
list.Add(_Parameters);
}
return(list);
}
finally
{
objEngine.CloseConnection();
}
}
public async Task <List <LookupParameters> > WebUndefinedProdType()
{
var objEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
await objEngine.InitiateConnectionAsync();
SqlParameter[] Parameters = new SqlParameter[1];
SqlCommand cmd = new SqlCommand();
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
var getObjData = await objEngine.ExecuteCommandAsync("WebUndefinedProdType", CommandType.StoredProcedure, Parameters);
var list = new List <LookupParameters>();
while (getObjData.Read())
{
var item = new LookupParameters
{
ProductCode = Convert.ToString(getObjData["ProdCd"]),
ProductName = Convert.ToString(getObjData["ProdName"]),
Descp = Convert.ToString(getObjData["ProdDescp"]),
SelectedProductCategory = Convert.ToString(getObjData["ProdCategory"]),
SelectedProductType = Convert.ToString(getObjData["ProdType"]),
UnitPrice = ConverterDecimal(getObjData["ProdUnitPrice"])
};
list.Add(item);
}
return(list);
}
finally
{
objEngine.CloseConnection();
}
}
