public MessageViewDomain Command(_014_invRefItemImageDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Extension", Value = projectDomain.Extension, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ImageName", Value = projectDomain.ImageName, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@isProfile", Value = projectDomain.isProfile, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ItemID_011", Value = projectDomain.ItemID_011, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Order", Value = projectDomain.Order, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp014invRefItemImageCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_024_invTransInfoDelMetAttrValueDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@TransMasterID_021", Value = projectDomain.TransMasterID_021, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@DeliveryAttrID_008", Value = projectDomain.DeliveryAttrID_008, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@AttributeValueID", Value = projectDomain.AttributeValueID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@AttributeValue", Value = projectDomain.AttributeValue, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@isDestination", Value = projectDomain.isDestination, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp024invTransInfoDelMetAttrValueCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_027_invWithdrawMasterListDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@CtrlNumber", Value = projectDomain.CtrlNumber, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@WidraweeNameID_Hrms", Value = projectDomain.WidraweeNameID_Hrms, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ProjectNameID_EnggDB", Value = projectDomain.ProjectNameID_EnggDB, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@RequestedByID_HrmsDB", Value = projectDomain.RequestedByID_HrmsDB, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ApprovedByID_HrmsDB", Value = projectDomain.ApprovedByID_HrmsDB, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ReceivedByID_HrmsDB", Value = projectDomain.ReceivedByID_HrmsDB, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Date", Value = projectDomain.Date, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp027invWithdrawMasterListCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_002c_hrmEmploymentInfoDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@empMasterId_002a", Value = projectDomain.empMasterId_002a, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@employmentTypeID", Value = projectDomain.employmentTypeID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@biometricIdentity", Value = projectDomain.biometricIdentity, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@resignedDate", Value = projectDomain.resignedDate, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@employementStatusID", Value = projectDomain.employementStatusID, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp002chrmEmploymentInfoCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_002d_hrmSpouseNameDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@empMasterID_002a", Value = projectDomain.empMasterID_002a, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@firstName", Value = projectDomain.firstName, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@middleName", Value = projectDomain.middleName, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@lastName", Value = projectDomain.lastName, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@dateOfBirth", Value = projectDomain.dateOfBirth, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp002dhrmSpouseNameCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_019_invReleasedItemHeaderDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Ctrlnumber", Value = projectDomain.Ctrlnumber, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ProjectID_ENGGDB", Value = projectDomain.ProjectID_ENGGDB, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Date", Value = projectDomain.Date, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Requestedby_HRMSDB", Value = projectDomain.Requestedby_HRMSDB, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Approvedby_HRMSDB", Value = projectDomain.Approvedby_HRMSDB, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Receivedby_HRMSDB", Value = projectDomain.Receivedby_HRMSDB, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ReceivedDate", Value = projectDomain.ReceivedDate, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp019invReleasedItemHeaderCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_022_invTransInfoOriginDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@TransMasterID_021", Value = projectDomain.TransMasterID_021, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ProjectID_EnggDB", Value = projectDomain.ProjectID_EnggDB, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@WHInchargeID_HrmsDB", Value = projectDomain.WHInchargeID_HrmsDB, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@TransDelMethodID_024", Value = projectDomain.TransDelMethodID_024, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Date", Value = projectDomain.Date, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp022invTransInfoOriginCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_028_invWithdrawItemEntryListDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@WithdrawMasterID_027", Value = projectDomain.WithdrawMasterID_027, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ItemID_011", Value = projectDomain.ItemID_011, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@UnitsID_009", Value = projectDomain.UnitsID_009, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Quantity", Value = projectDomain.Quantity, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ItemCondID_018", Value = projectDomain.ItemCondID_018, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp028invWithdrawItemEntryListCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_007_invNewItemHeaderListDomain entity, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter
{
ParameterName = "@DocEntry",
Value = Newtonsoft.Json.JsonConvert.SerializeObject(entity),// projectDomain.ID,
Direction = ParameterDirection.Input
},
new SqlParameter
{
ParameterName = "@ItemsEntry",
Value = Newtonsoft.Json.JsonConvert.SerializeObject(entity.ItemEntryList),// projectDomain.Name,
Direction = ParameterDirection.Input
},
new SqlParameter
{
ParameterName = "@DeliveryEntry",
Value = Newtonsoft.Json.JsonConvert.SerializeObject(entity.DeliveryMethod.DelMethodAttribute[0].DeliveryMethodEntryList),// projectDomain.Name,
Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("spDeriveStockEntryCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_026_invTransItemReceivedListDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@TransMasterID_021", Value = projectDomain.TransMasterID_021, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ItemID_011", Value = projectDomain.ItemID_011, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@UnitsID_009", Value = projectDomain.UnitsID_009, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Quantity", Value = projectDomain.Quantity, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ItemCondID_018", Value = projectDomain.ItemCondID_018, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ReceiverID_HrmsDB", Value = projectDomain.ReceiverID_HrmsDB, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@DelMethodID_024", Value = projectDomain.DelMethodID_024, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp026invTransItemReceivedListCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_013_invNewItemEntryListDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@DocEntryId_007", Value = projectDomain.DocEntryId_007, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ItemID_011", Value = projectDomain.ItemID_011, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@UnitID_009", Value = projectDomain.UnitID_009, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@UnitPrice", Value = projectDomain.UnitPrice, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Quantity", Value = projectDomain.Quantity, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ItemConditionID_018", Value = projectDomain.ItemConditionID_018, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp013invNewItemEntryListCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_011_invRefItemsMasterListDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Code", Value = projectDomain.Code, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Tag", Value = projectDomain.Tag, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@hasAttribute", Value = projectDomain.hasAttribute, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ItemPropList", Value = JsonConvert.SerializeObject(projectDomain.Category3.Property2[0].ItemPropList), Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ItemAttribute", Value = JsonConvert.SerializeObject(projectDomain.ItemAttribute), Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ItemAttribute", Value = JsonConvert.SerializeObject(projectDomain.ItemAttribute), Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp011invRefITemsMAsterListCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_004_invRefPropertyName1Domain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Name", Value = projectDomain.Name, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp004invRefPropertyName1Command", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomainModel Command(ProjectDomainModel projectDomain, string commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ProjectName", Value = projectDomain.ProjectName, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("spProjectCommand", commandType, sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_001b_hrmRefGenderListDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@genderName", Value = projectDomain.genderName, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp001bhrmRefGenderListCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_018_invRefItemConditionDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@StatusName", Value = projectDomain.StatusName, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp018invRefItemConditionCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_010_invRefDeliveryMethodDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
//TOD:
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Name", Value = projectDomain.Name, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp010invRefDeliveryMethodCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_002e_hrmEmpAllowanceDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@empMasterID_002a", Value = projectDomain.empMasterID_002a, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@allowance", Value = projectDomain.allowance, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp002ehrmEmpAllowanceCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_001a_hrmRefPrefixListDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@prefix", Value = projectDomain.prefix, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@definition", Value = projectDomain.definition, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp001ahrmRefPrefixListCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_008_invRefDelMethodAttributeDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@DelMethodID_010", Value = projectDomain.DelMethodID_010, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@MethodAttribute", Value = projectDomain.MethodAttribute, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp008invRefDelMethodAttributeCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_009_invRefUnitsDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
//TOD:
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ShortName", Value = projectDomain.ShortName, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@FullName", Value = projectDomain.FullName, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp009invRefUnitsCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_021_invTransMasterListDomain projectDomain, Command commandType, bool isReceived)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ReferenceNumber", Value = projectDomain.ReferenceNumber, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@HardSeriesNumber", Value = projectDomain.HardSeriesNumber, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@isCancelled", Value = projectDomain.isCancelled, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@cancelReason", Value = projectDomain.cancelReason ?? "", Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Date", Value = projectDomain.Date ?? DateTime.Now, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@TransInfoOrigin", Value = JsonConvert.SerializeObject(projectDomain.TransInfoOrigin) ?? "[]", Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@TransInfoDestination", Value = JsonConvert.SerializeObject(projectDomain.TransInfoDestination) ?? "[]", Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@TransInfoDelMetAttrValue", Value = JsonConvert.SerializeObject(projectDomain.TransInfoDelMetAttrValue) ?? "[]", Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@TransItemEntryList", Value = JsonConvert.SerializeObject(projectDomain.TransItemEntryList) ?? "[]", Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@TransItemReceivedList", Value = JsonConvert.SerializeObject(projectDomain.TransItemReceivedList) ?? "[]", Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@isReceive", Value = isReceived, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp021invTransMasterListCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(PersonInformationDL projectDomain, string commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@FirstName", Value = projectDomain.FirstName, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@MiddleName", Value = projectDomain.MiddleName, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@LastName", Value = projectDomain.LastName, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp001invRefCategory1Command", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_012_invItemAttributeDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@ItemID_011", Value = projectDomain.ItemID_011, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@AttID_006", Value = projectDomain.AttID_006, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@AttributeValue", Value = projectDomain.AttributeValue, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp012invItemAttributeCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_032_LoginDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Username", Value = projectDomain.Username, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Password", Value = projectDomain.Password, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Info", Value = projectDomain.Info, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp031invRefTransferListCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_001e_hrmRefPositionRankListDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@positionID_001d", Value = projectDomain.positionID_001d, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@positionRank", Value = projectDomain.positionRank, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@baseSalary", Value = projectDomain.baseSalary, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp001ehrmRefPositionRankListCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_030_invRefFormHardCopySeriesDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@FormID_029", Value = projectDomain.FormID_029, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Series", Value = projectDomain.Series, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@isUsed", Value = projectDomain.isUsed, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp030invRefFormHardCopySeriesCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_029_invRefFormListDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@InitForm", Value = projectDomain.InitForm, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Name", Value = projectDomain.Name, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@Abbr", Value = projectDomain.Abbr, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp029invRefFormListCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_001c_hrmRefEmpNumberListDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@prefixID_001", Value = projectDomain.prefixID_001, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@empSeriesNo", Value = projectDomain.empSeriesNo, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@dateHired", Value = projectDomain.dateHired, Direction = ParameterDirection.Input
}
};
return(this.GetMessage(_dbHelper.Command("sp001chrmRefEmpNumberListCommand", commandType.ToString(), sqlParameters).Tables[0]));
}
public MessageViewDomain Command(_002a_hrmEmpMasterListDomain projectDomain, Command commandType)
{
var sqlParameters = new List <SqlParameter>()
{
new SqlParameter {
ParameterName = "@ID", Value = projectDomain.ID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@empNoID_001c", Value = projectDomain.empNoID_001c, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@firstName", Value = projectDomain.firstName, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@middleName", Value = projectDomain.middleName, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@lastName", Value = projectDomain.lastName, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@dateOfBirth", Value = projectDomain.dateOfBirth, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@genderID", Value = projectDomain.genderID, Direction = ParameterDirection.Input
},
new SqlParameter {
ParameterName = "@dateHired", Value = projectDomain.dateHired, Direction = ParameterDirection.Input
},
Helper.SqlTableParameter.DotnetPiperExtentionMethod("@001c_hrmRefEmpNumber", "t001c", projectDomain.empNumber),
Helper.SqlTableParameter.DotnetPiperExtentionMethod("@002bhrmPersonalInfo", "t002b", projectDomain.PersonalInfo),
Helper.SqlTableParameter.DotnetPiperExtentionMethod("@002chrmEmploymentInfo", "t002c", projectDomain.EmploymentInfo),
Helper.SqlTableParameter.DotnetPiperExtentionMethod("@002dhrmSpouseName", "t002d", projectDomain.SpouseNameList),
Helper.SqlTableParameter.DotnetPiperExtentionMethod("@002ehrmEmpAllowance", "t002e", projectDomain.EmpAllowance),
Helper.SqlTableParameter.DotnetPiperExtentionMethod("@002fhrmEmpPosition", "t002f", projectDomain.EmpPosition),
Helper.SqlTableParameter.DotnetPiperExtentionMethod("@002ghrmEmpSalary", "t002g", projectDomain.EmpSalary),
Helper.SqlTableParameter.DotnetPiperExtentionMethod("@002hhrmEmpSalaryAddOn", "t002h", projectDomain.EmpSalaryAddOn)
};
return(this.GetMessage(_dbHelper.Command("sp002ahrmEmpMasterListCommand", commandType.ToString(), sqlParameters).Tables[0]));
}