/// <summary>
/// Description : Get MWorkOrderType from database for Type dropdown in WorkOrder.
/// Created By : Shiva
/// Created Date : 20 May 2014
/// Modified By :
/// Modified Date:
/// </summary>
/// <returns></returns>
public static WorkOrdersAndDItemsInfo GetWorkOrderType()
{
var data = new WorkOrdersAndDItemsInfo();
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SPGetMWorkOrderType");
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var getIDFromDIType = new DisbursementItem();
getIDFromDIType.FetchIDAndNameFromWOType(getIDFromDIType, safe);
data.OrdersList.Add(getIDFromDIType);
}
return data;
}
/// <summary>
/// Created By : Pavan
/// Created Date : 19 May 2014
/// Modified By :
/// Modified Date :
/// <returns> Insert the Type, Description, Status to Work order </returns>
/// </summary>
public WorkOrdersAndDItemsInfo InsertWorkOrder()
{
SqlParameter[] sqlParams = new SqlParameter[11];
sqlParams[0] = new SqlParameter("@Type", this.Type);
sqlParams[1] = new SqlParameter("@Billable", this.Billable);
sqlParams[2] = new SqlParameter("@Description", this.Description);
//sqlParams[4] = new SqlParameter("@Status", this.Status);
sqlParams[3] = new SqlParameter("@CreatedBy", this.CreatedBy);
// sqlParams[5] = new SqlParameter("@ID", this.ID);
sqlParams[4] = new SqlParameter("@GroupCode", this.GroupCode);
sqlParams[5] = new SqlParameter("@IsAdhoc", this.IsAdhoc);
sqlParams[6] = new SqlParameter("@ClientOrCustomerID", this.ClientOrCustomerID);
sqlParams[7] = new SqlParameter("@SourceID", this.SourceID);
sqlParams[8] = new SqlParameter("@StatusCode", this.StatusCode);
sqlParams[9] = new SqlParameter("@IsPostedToCss1", this.IsPostedToCss1);
if (this.IsPostedToCss1 == true)
sqlParams[10] = new SqlParameter("@PostedTOCss1Date", DateTime.Now);
else
sqlParams[10] = new SqlParameter("@PostedTOCss1Date", DBNull.Value);
//sqlParams[12] = new SqlParameter("@Output", 0);
//sqlParams[12].Direction = ParameterDirection.Output;
var data = new WorkOrdersAndDItemsInfo();
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpInsertWorkOrder", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var getWO = new DisbursementItem();
FetchInsertedWO(getWO, safe);
data.OrdersList.Add(getWO);
}
return data;
// int output = Convert.ToInt32(sqlParams[12].Value);
// return output;
}
/// <summary>
/// Description : To get the MDIType Details By ItemNumber for the partial view.
/// Created By : Shiva
/// Created Date : 4 June 2014
/// Modified By :
/// Modified Date:
/// </summary>
/// <returns></returns>
///
public static WorkOrdersAndDItemsInfo GetMDITypeDetailsByItemNumber(int DIID)
{
var MCurrencyTypeData = new WorkOrdersAndDItemsInfo();
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
SqlParameter[] sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@ID", DIID);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpGetMDITypeDetailsByID", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var Item = new DisbursementItem();
Item.FetchDITypeDetailsByItemNumber(Item, safe);
MCurrencyTypeData.OrdersList.Add(Item);
}
return MCurrencyTypeData;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return MCurrencyTypeData;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
/// <summary>
/// Description : Get FeeItems Invoice preview by ID
/// Created By : SHIVA
/// Created Date : 4 Feb 2015
/// Modified By :
/// Modified Date:
/// </summary>
/// <param name="ID">Get FeeItems Invoice preview details based on FeeID's</param>
/// <returns></returns>
public static WorkOrdersAndDItemsInfo GetInvoicePreviewDataByFeeID(string FeeIDs)
{
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
var WorkOrdersAndDItemsInfo = new WorkOrdersAndDItemsInfo();
try
{
SqlParameter[] sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@FeeIDs", FeeIDs);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SPInvoicePreviewDataByFee]", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var InvoicePreview = new DIFeeInvoicePreview();
InvoicePreview.FetchInvoicePreview(InvoicePreview, safe);
WorkOrdersAndDItemsInfo.DiInvoicePreview.Add(InvoicePreview);
}
return WorkOrdersAndDItemsInfo;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return WorkOrdersAndDItemsInfo;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
/// <summary>
/// Created By : Shiva
/// Created Date : 19 May 2014
/// Modified By :
/// Modified Date :
/// <returns> Get the current WorkOrderID Disbursement Items data </returns>
/// </summary>
public static WorkOrdersAndDItemsInfo GetDisbursementItemsData(int WOID, int startpage, int rowsperpage)
{
var disbursementItemsData = new WorkOrdersAndDItemsInfo();
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
SqlParameter[] sqlParams = new SqlParameter[3];
sqlParams[0] = new SqlParameter("@WorkOrderID", WOID);
sqlParams[1] = new SqlParameter("@startpage", startpage);
sqlParams[2] = new SqlParameter("@rowsPerPage", rowsperpage);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[GetDisbursementItemsByWOID]", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var Item = new DisbursementItem();
Item.FetchDisbursementItemsForSearch(Item, safe);
disbursementItemsData.OrdersList.Add(Item);
disbursementItemsData.OrdersCount = Convert.ToInt32(reader["DICount"]);
}
reader.NextResult();
while (reader.Read())
{
var Instate = new DIInstate();
Instate.FetchDIInstate(Instate, safe);
disbursementItemsData.DiInstate.Add(Instate);
}
reader.NextResult();
while (reader.Read())
{
var Rules = new DIActionRules();
Rules.FetchDIActionRules(Rules, safe);
disbursementItemsData.DiActionRules.Add(Rules);
}
return disbursementItemsData;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return disbursementItemsData;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
/// <summary>
/// Description : Get Disbursement details by ID
/// Created By : Shiva
/// Created Date : 6 June 2014
/// Modified By :
/// Modified Date:
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public static WorkOrdersAndDItemsInfo GetDisbursementItemsByID(int ID, string VenderRefID)
{
var data = new WorkOrdersAndDItemsInfo();
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
SqlParameter[] sqlParams = new SqlParameter[2];
sqlParams[0] = new SqlParameter("@ID", ID);
sqlParams[1] = new SqlParameter("@VenderRefID", VenderRefID);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SPGetDisbursementDataByID", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var SearchDisbursementItem = new DisbursementItem();
SearchDisbursementItem.FetchDisbursementItemsByID(SearchDisbursementItem, safe);
data.OrdersList.Add(SearchDisbursementItem);
}
safe.NextResult();
while (reader.Read())
{
data.VendorAmount = Convert.ToDecimal(reader["Amount"]);
data.VendorReport = Convert.ToString(reader["VRID"]);
}
safe.NextResult();
while (reader.Read())
{
data.OrdersCount = Convert.ToInt32(reader["RelatedDICount"]);
}
return data;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return data;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
/// <summary>
/// Description : Get DisburesementItems as per search Results.
/// Created By : pavan
/// Created Date : 19 May 2014
/// Modified By : Shiva
/// Modified Date: 11 Aug 2014
/// </summary>
/// <returns></returns>
public static WorkOrdersAndDItemsInfo GetAllSearchDisbursementItems(string clientID, string SourceID, string WO, string venderRefId, string Type, string IsVerified, string IsBilled, string IsArchived, string IsAdhoc, string OrderBy, int startpage, int rowsperpage, string FromDate, string ToDate,int ACCPACStatus)
{
var data = new WorkOrdersAndDItemsInfo();
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
SqlParameter[] sqlParams = new SqlParameter[15];
//sqlParams[0] = new SqlParameter("@ItemNumber", clientName);
sqlParams[0] = new SqlParameter("@WO", WO);
sqlParams[1] = new SqlParameter("@VenderRefId", venderRefId);
sqlParams[2] = new SqlParameter("@Type", Type);
sqlParams[3] = new SqlParameter("@IsVerified", IsVerified);
sqlParams[4] = new SqlParameter("@IsBilled", IsBilled);
sqlParams[5] = new SqlParameter("@IsArchived", IsArchived);
sqlParams[6] = new SqlParameter("@IsAdhoc", IsAdhoc);
sqlParams[7] = new SqlParameter("@OrderBy", OrderBy);
sqlParams[8] = new SqlParameter("@startPage", startpage);
sqlParams[9] = new SqlParameter("@resultPerPage", rowsperpage);
sqlParams[10] = new SqlParameter("@ClientID", clientID);
sqlParams[11] = new SqlParameter("@SourceID", SourceID);
sqlParams[12] = new SqlParameter("@FromDate", HelperClasses.ConvertDateFormat(FromDate));
sqlParams[13] = new SqlParameter("@ToDate", HelperClasses.ConvertDateFormat(ToDate));
sqlParams[14] = new SqlParameter("@ACCPACStatus", ACCPACStatus);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpGetAllDisbursementItems", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var SearchDisbursementItem = new DisbursementItem();
SearchDisbursementItem.FetchDisbursementItemsForSearch(SearchDisbursementItem, safe);
data.OrdersList.Add(SearchDisbursementItem);
data.OrdersCount = Convert.ToInt32(reader["DICount"]);
}
reader.NextResult();
while (reader.Read())
{
var Instate = new DIInstate();
Instate.FetchDIInstate(Instate, safe);
data.DiInstate.Add(Instate);
}
reader.NextResult();
while (reader.Read())
{
var ActionRules = new DIActionRules();
ActionRules.FetchDIActionRules(ActionRules, safe);
data.DiActionRules.Add(ActionRules);
}
return data;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return data;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
