public string FGetSaleQuotationCostCenter(int DocTypeId, DateTime DocDate, int DivisionId, int SiteId)
{
SqlParameter SqlParameterDocTypeId = new SqlParameter("@DocTypeId", DocTypeId);
SqlParameter SqlParameterDocDate = new SqlParameter("@DocDate", DocDate);
SqlParameter SqlParameterDivisionId = new SqlParameter("@DivisionId", DivisionId);
SqlParameter SqlParameterSiteId = new SqlParameter("@SiteId", SiteId);
NewDocNoViewModel NewDocNoViewModel = db.Database.SqlQuery <NewDocNoViewModel>("" + ConfigurationManager.AppSettings["DataBaseSchema"] + ".GetSaleQuotationCostCenter @DocTypeId , @DocDate , @DivisionId , @SiteId ", SqlParameterDocTypeId, SqlParameterDocDate, SqlParameterDivisionId, SqlParameterSiteId).FirstOrDefault();
if (NewDocNoViewModel != null)
{
return(NewDocNoViewModel.NewDocNo);
}
else
{
return(null);
}
}
public string FGetNewDocNo(string FieldName, string TableName, int DocTypeId, DateTime DocDate)
{
SqlParameter SqlParameterFieldName = new SqlParameter("@FieldName", FieldName);
SqlParameter SqlParameterTableName = new SqlParameter("@TableName", TableName);
SqlParameter SqlParameterDocTypeId = new SqlParameter("@DocTypeId", DocTypeId);
SqlParameter SqlParameterDocDate = new SqlParameter("@DocDate", DocDate);
NewDocNoViewModel NewDocNoViewModel = db.Database.SqlQuery <NewDocNoViewModel>("" + ConfigurationManager.AppSettings["DataBaseSchema"] + ".GetProductUidHeaderNewDocNo @FieldName , @TableName ,@DocTypeId , @DocDate ", SqlParameterFieldName, SqlParameterTableName, SqlParameterDocTypeId, SqlParameterDocDate).FirstOrDefault();
if (NewDocNoViewModel != null)
{
return(NewDocNoViewModel.NewDocNo);
}
else
{
return(null);
}
}
