public DataTable fillCompanybyUser()
{
DataTable dt = objUserMaster.GetUserMasterByUserId(Session["UserId"].ToString());
DataTable dtReturn = ObjCompanyMaster.GetCompanyMaster();
if (dt.Rows.Count != 0)
{
if (dt.Rows[0]["Company_Id"].ToString() != "0" && dt.Rows[0]["Emp_Id"].ToString() != "0")
{
dtReturn = new DataView(dtReturn, "Company_Id in('" + dt.Rows[0]["Company_Id"].ToString() + "')", "", DataViewRowState.CurrentRows).ToTable();
}
}
return(dtReturn);
}
public string GetDocumentNumber()
{
string DocumentNo = string.Empty;
DataTable Dt = objDocNo.GetDocumentNumberAll(StrCompId, "12", "44");
if (Dt.Rows.Count > 0)
{
if (Dt.Rows[0]["Prefix"].ToString() != "")
{
DocumentNo += Dt.Rows[0]["Prefix"].ToString();
}
if (Convert.ToBoolean(Dt.Rows[0]["CompId"].ToString()))
{
DocumentNo += StrCompId;
}
if (Convert.ToBoolean(Dt.Rows[0]["BrandId"].ToString()))
{
DocumentNo += StrBrandId;
}
if (Convert.ToBoolean(Dt.Rows[0]["LocationId"].ToString()))
{
DocumentNo += StrLocationId;
}
if (Convert.ToBoolean(Dt.Rows[0]["DeptId"].ToString()))
{
DocumentNo += (string)Session["SessionDepId"];
}
if (Convert.ToBoolean(Dt.Rows[0]["EmpId"].ToString()))
{
DataTable Dtuser = ObjUser.GetUserMasterByUserId(Session["UserId"].ToString());
DocumentNo += Dtuser.Rows[0]["Emp_Id"].ToString();
}
if (Convert.ToBoolean(Dt.Rows[0]["Year"].ToString()))
{
DocumentNo += DateTime.Now.Year.ToString();
}
if (Convert.ToBoolean(Dt.Rows[0]["Month"].ToString()))
{
DocumentNo += DateTime.Now.Month.ToString();
}
if (Convert.ToBoolean(Dt.Rows[0]["Day"].ToString()))
{
DocumentNo += DateTime.Now.Day.ToString();
}
if (Dt.Rows[0]["Suffix"].ToString() != "")
{
DocumentNo += Dt.Rows[0]["Suffix"].ToString();
}
if (DocumentNo != "")
{
DocumentNo += "-" + (Convert.ToInt32(ObjPurchaseReqestHeader.GetPurchaseRequestHeader(StrCompId.ToString()).Rows.Count) + 1).ToString();
}
else
{
DocumentNo += (Convert.ToInt32(ObjPurchaseReqestHeader.GetPurchaseRequestHeader(StrCompId.ToString()).Rows.Count) + 1).ToString();
}
}
else
{
DocumentNo += (Convert.ToInt32(ObjPurchaseReqestHeader.GetPurchaseRequestHeader(StrCompId.ToString()).Rows.Count) + 1).ToString();
}
return(DocumentNo);
}
