public static string ManageStubNumber(NameValueCollection querystring)
{
int intParser;
bool isActive = false;
UserProfile userProfile = WebCommon.GetUserProfile();
if (querystring.Get("IsActive") == "1")
{
isActive = true;
}
var stubNumber = new StubNumber
{
StubNumberID = int.TryParse(querystring.Get("StubNumberID"), out intParser) ? intParser : 0,
BranchID = int.TryParse(querystring.Get("BranchID"), out intParser) ? intParser : 0,
Number = int.TryParse(querystring.Get("Number"), out intParser) ? intParser : 0,
From = int.TryParse(querystring.Get("From"), out intParser) ? intParser : 0,
To = int.TryParse(querystring.Get("To"), out intParser) ? intParser : 0,
EmployeeID = int.TryParse(querystring.Get("EmployeeID"), out intParser) ? intParser : 0,
IsActive = isActive,
ORTypeID = int.TryParse(querystring.Get("ORTypeID"), out intParser) ? intParser : 0,
UserID = userProfile.UserId
};
string isInsert = querystring.Get("TransType");
string param = WebCommon.ToXML(stubNumber);
return(StubNumberDAL.ManageStubNumber(param, isInsert));
}
public static List <StubNumber> GetStubNumber(string criteria, int branchID)
{
var dbUtil = new DatabaseManager();
var stubNumbers = new List <StubNumber>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spMasGetStubNumber";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@strCriteria", criteria);
cmd.Parameters.AddWithValue("@intBranchID", branchID);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var stubNumber = new StubNumber
{
StubNumberID = ReferenceEquals(reader["intStubNumberID"], DBNull.Value) ? 0 : (int)reader["intStubNumberID"],
BranchID = ReferenceEquals(reader["intBranchID"], DBNull.Value) ? 0 : (int)reader["intBranchID"],
Branch = ReferenceEquals(reader["strBranch"], DBNull.Value) ? String.Empty : (string)reader["strBranch"],
Number = ReferenceEquals(reader["intNumber"], DBNull.Value) ? 0 : (int)reader["intNumber"],
From = ReferenceEquals(reader["intFrom"], DBNull.Value) ? 0 : (int)reader["intFrom"],
To = ReferenceEquals(reader["intTo"], DBNull.Value) ? 0 : (int)reader["intTo"],
EmployeeID = ReferenceEquals(reader["intIDMasEmployee"], DBNull.Value) ? 0 : (int)reader["intIDMasEmployee"],
ORTypeID = ReferenceEquals(reader["intIDMasORType"], DBNull.Value) ? 0 : (int)reader["intIDMasORType"],
Employee = ReferenceEquals(reader["strEmployee"], DBNull.Value) ? String.Empty : (string)reader["strEmployee"],
IsActive = !ReferenceEquals(reader["blnIsActive"], DBNull.Value) && (bool)reader["blnIsActive"]
//Remarks = ReferenceEquals(reader["strRemarks"], DBNull.Value) ? String.Empty : (string)reader["strRemarks"]
};
stubNumbers.Add(stubNumber);
}
return(stubNumbers);
}
}
}
}
public static List <StubNumber> GetStubNumber(int branchid, int paymentypeid, int userid)
{
var dbUtil = new DatabaseManager();
var stubNumbers = new List <StubNumber>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spColGetStubNumber";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@intBranchID", branchid);
cmd.Parameters.AddWithValue("@intIDMasPaymentType", paymentypeid);
cmd.Parameters.AddWithValue("@intIDSecUser", userid);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var stubNumber = new StubNumber
{
StubNumberID = ReferenceEquals(reader["intStubNumberID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intStubNumberID"]),
Description = ReferenceEquals(reader["strDescription"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strDescription"]),
From = ReferenceEquals(reader["intFrom"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intFrom"]),
To = ReferenceEquals(reader["intTo"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intTo"])
};
stubNumbers.Add(stubNumber);
}
return(stubNumbers);
}
}
}
}
