public static List <Model.mdlBranch> LoadSomeBranch(string branchid)
{
branchid = StringFacade.NormalizedBranch(branchid);
var mdlBranchList = new List <Model.mdlBranch>();
List <SqlParameter> sp = new List <SqlParameter>()
{
};
DataTable dtBranch = Manager.DataFacade.DTSQLCommand("SELECT * FROM Branch where BranchID IN (" + branchid + ") order by BranchName", sp);
foreach (DataRow drBranch in dtBranch.Rows)
{
var mdlBranch = new Model.mdlBranch();
mdlBranch.BranchID = drBranch["BranchID"].ToString();
mdlBranch.BranchName = drBranch["BranchName"].ToString();
mdlBranch.BranchDescription = drBranch["BranchDescription"].ToString();
mdlBranch.CompanyID = drBranch["CompanyID"].ToString();
mdlBranch.Latitude = drBranch["Latitude"].ToString();
mdlBranch.Longitude = drBranch["Longitude"].ToString();
mdlBranchList.Add(mdlBranch);
}
//mdlBranchListnew.BranchList = mdlBranchList;
//return mdlBranchListnew;
return(mdlBranchList);
}
public static List <Model.mdlDailyMsg> GetSearchbySomeBranch(string keyword, DateTime keyworddate, string branchid)
{
branchid = StringFacade.NormalizedBranch(branchid);
var mdlDailyMsgList = new List <Model.mdlDailyMsg>();
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@ValidDate", SqlDbType = SqlDbType.Date, Value = keyworddate
},
new SqlParameter()
{
ParameterName = "@Keyword", SqlDbType = SqlDbType.NVarChar, Value = "%" + keyword + "%"
},
new SqlParameter()
{
ParameterName = "@BranchID", SqlDbType = SqlDbType.NVarChar, Value = branchid
}
};
DataTable dtDailyMsg = DataFacade.DTSQLCommand(@"SELECT distinct(a.MessageID)
,a.MessageName
,a.Date
,a.EndDate
,a.CreatedBy
From DailyMessage a
LEFT JOIN DailyMessageDetail b on b.MessageID = a.MessageID
WHERE (a.Date <= @ValidDate AND a.EndDate >= @ValidDate) AND (a.MessageID like @Keyword OR MessageName like @Keyword)
AND a.MessageID IN (SELECT MessageID from DailyMessageDetail where BranchID IN (" + branchid + "))", sp);
foreach (DataRow row in dtDailyMsg.Rows)
{
var mdlDailyMsg = new Model.mdlDailyMsg();
mdlDailyMsg.MessageID = row["MessageID"].ToString();
mdlDailyMsg.MessageName = row["MessageName"].ToString();
mdlDailyMsg.Date = Convert.ToDateTime(row["Date"]).ToString("dd/MM/yyyy");
mdlDailyMsg.EndDate = Convert.ToDateTime(row["EndDate"]).ToString("dd/MM/yyyy");
mdlDailyMsg.CreatedBy = row["CreatedBy"].ToString();
mdlDailyMsgList.Add(mdlDailyMsg);
}
return(mdlDailyMsgList);
}
public static List <string> LoadBranchByID(string branchid)
{
//linq code
//var customerList = DataContext.Customers.Where(fld => fld.PlantID.Equals(json.BranchID)).ToList();
branchid = StringFacade.NormalizedBranch(branchid);
List <SqlParameter> sp = new List <SqlParameter>()
{
};
DataTable dtBranch = Manager.DataFacade.DTSQLCommand("SELECT * FROM Branch where BranchID LIKE '%" + branchid + "%'", sp);
var listBranch = new List <string>();
foreach (DataRow drBranch in dtBranch.Rows)
{
listBranch.Add(drBranch["BranchID"].ToString());
}
return(listBranch);
}
