private static DistributorRequest ReaderDataDistributorRequest(MySqlDataReader reader)
{
DistributorRequest objDD = new DistributorRequest();
objDD.RequestID = DbCheck.IsValidInt(reader["RequestID"]);
objDD.NumberOfPeople = DbCheck.IsValidInt(reader["NumberOfPeople"]);
objDD.RequestDate = DbCheck.IsValidDateTime(reader["RequestDate"]);
objDD.RequestStatus = DbCheck.IsValidString(reader["RequestStatus"]);
objDD.UserID = DbCheck.IsValidInt(reader["UserId"]);
return(objDD);
}
public static List <DistributorRequest> GetDistributionRequest(string whereclause, MySqlConnection conn = null)
{
DistributorRequest ObjDD = new DistributorRequest();
List <DistributorRequest> lstDD = new List <DistributorRequest>();
try
{
bool isConnArgNull = (conn != null) ? false : true;
MySqlConnection connection = (conn != null) ? conn : PrimaryConnection();
tryOpenConnection(connection);
string sql = "select * from distributorrequest";
if (!string.IsNullOrEmpty(whereclause))
{
sql += " where " + whereclause;
}
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandText = sql;
using (MySqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
ObjDD = ReaderDataDistributorRequest(reader);
lstDD.Add(ObjDD);
}
}
else
{
}
}
if (isConnArgNull == true)
{
connection.Dispose();
}
}
}
//endtry
catch (Exception ex)
{
}
return(lstDD);
}
public static string SaveDistributionRequest(DistributorRequest ObjDD, MySqlConnection conn = null, MySqlTransaction trans = null)
{
string returnMessage = "";
string sDDID = "";
sDDID = ObjDD.RequestID.ToString();
var templstEmp = DistributorRequestManager.GetDistributionRequest("RequestID = '" + sDDID + "'", conn);
try
{
bool isConnArgNull = (conn != null) ? false : true;
MySqlConnection connection = (conn != null) ? conn : PrimaryConnection();
tryOpenConnection(connection);
using (MySqlCommand command = new MySqlCommand())
{
string sql;
bool isEdit = true;
if (templstEmp.Count <= 0)
{
isEdit = false;
sql = @"INSERT INTO DistributorRequest(
RequestDate,
NumberOfPeople,
UserId,
RequestStatus
)
VALUES(
@RequestDate,
@NumberOfPeople,
@UserId,
@RequestStatus
)";
}
else
{
sql = @"Update DistributorRequest set
RequestID=@RequestID,
RequestDate=@RequestDate,
RequestStatus=@RequestStatus,
UserId=@UserId,
NumberOfPeople=@NumberOfPeople
Where RequestID=@RequestID";
}
if (trans != null)
{
command.Transaction = trans;
}
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = sql;
if (isEdit)
{
command.Parameters.AddWithValue("@RequestID", ObjDD.RequestID);
}
command.Parameters.AddWithValue("@RequestDate", ObjDD.RequestDate);
command.Parameters.AddWithValue("@RequestStatus", ObjDD.RequestStatus);
command.Parameters.AddWithValue("@UserId", ObjDD.UserID);
command.Parameters.AddWithValue("@NumberOfPeople", ObjDD.NumberOfPeople);
int affectedRows = command.ExecuteNonQuery();
var lastInsertID = command.LastInsertedId;
if (affectedRows > 0)
{
returnMessage = "OK";
}
else
{
returnMessage = Shared.Constants.MSG_ERR_DBSAVE.Text;
}
}
if (isConnArgNull == true)
{
connection.Dispose();
}
}
catch (Exception ex)
{
}
return(returnMessage);
}
