public static int FieldCode_InsertUpdate(string strConn, int?FieldCodeId, int FieldClassId, string FieldCodeName, string FieldCodeAlias,
string FieldCodeOrder, Guid?CompanyId)
{
const string ProcName = "FieldCode_InsertUpdate()";
SqlConnection connection = null;
SqlParameter param;
DateTime startDate = DateTime.Now;
Guid LoginID = Guid.Empty;
string strMessage = string.Empty;
DataTable dt = new DataTable();
int rowsEffected;
int returnValue;
try
{
connection = DataSource.GetConnection(strConn);
using (SqlCommand command = new SqlCommand())
{
command.CommandText = ProcName.Substring(0, ProcName.Length - 2);
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
param = command.Parameters.Add("@FieldCodeId", SqlDbType.Int);
param.Value = FieldCodeId;
param = command.Parameters.Add("@FieldClassId", SqlDbType.Int);
param.Value = FieldClassId;
param = command.Parameters.Add("@FieldCodeName", SqlDbType.VarChar);
param.Value = FieldCodeName;
param = command.Parameters.Add("@FieldCodeAlias", SqlDbType.VarChar);
param.Value = FieldCodeAlias;
param = command.Parameters.Add("@FieldCodeOrder", SqlDbType.VarChar);
param.Value = FieldCodeOrder;
param = command.Parameters.Add("@CompanyId", SqlDbType.UniqueIdentifier);
param.Value = CompanyId;
param = command.Parameters.Add("@ReturnValue", SqlDbType.Int);
param.Direction = ParameterDirection.ReturnValue;
rowsEffected = command.ExecuteNonQuery();
returnValue = (int)command.Parameters["@ReturnValue"].Value;
}
}
finally
{
DataSource.CloseConnection(connection);
TimeSpan timeSpan = DateTime.Now.Subtract(startDate);
}
return(returnValue);
}
public static int Delete_Process(string strConn, int ProcessId)
{
const string ProcName = "PROCESS_Delete()";
SqlConnection connection = null;
SqlParameter param;
DateTime startDate = DateTime.Now;
Guid LoginID = Guid.Empty;
string strMessage = string.Empty;
DataTable dt = new DataTable();
int rowsEffected;
int returnValue;
try
{
connection = DataSource.GetConnection(strConn);
using (SqlCommand command = new SqlCommand())
{
command.CommandText = ProcName.Substring(0, ProcName.Length - 2);
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
param = command.Parameters.Add("@ProcessId", SqlDbType.Int);
param.Value = ProcessId;
param = command.Parameters.Add("@ReturnValue", SqlDbType.Int);
param.Direction = ParameterDirection.ReturnValue;
rowsEffected = command.ExecuteNonQuery();
returnValue = (int)command.Parameters["@ReturnValue"].Value;
}
}
finally
{
DataSource.CloseConnection(connection);
TimeSpan timeSpan = DateTime.Now.Subtract(startDate);
}
return(returnValue);
}
private void ParseRequest(string requestMethod, string thePath, string rawUrl, string soapAction)
{
string requestPath = thePath.Substring(1);
DadSpecifiedInRequest = true;
IsFlexibleParams = false;
IsPathAlias = false;
string[] pathElements = requestPath.Split('/');
if (pathElements.Length >= 2)
{
ModuleName = pathElements[0];
DadName = pathElements[1];
if (DadName.Length == 0 || !DadConfiguration.IsValidDad(DadName))
{
DadSpecifiedInRequest = false;
DadName = DadConfiguration.DefaultDad;
}
// get dad-specific configuration settings
DadConfig = new DadConfiguration(DadName);
if (pathElements.Length >= 3)
{
ProcName = pathElements[2];
if (ProcName.Length > 0)
{
if (ProcName.Substring(0, 1) == "!")
{
IsFlexibleParams = true;
}
else if (ProcName == DadConfig.PathAlias)
{
IsPathAlias = true;
PathAliasValue = GetAliasValue(ProcName, thePath);
}
else if (ProcName == DadConfig.XdbAlias)
{
IsXdbAlias = true;
XdbAliasValue = GetAliasValue(ProcName, thePath);
}
else if (ProcName == DadConfig.DocumentPath)
{
IsDocumentPath = true;
}
}
}
else
{
// missing trailing slash in request
ProcName = "";
}
if (ProcName.Length == 0)
{
ProcName = DadConfig.DefaultPage;
}
if (DadConfig.InvocationProtocol == DadConfiguration.INVOCATION_PROTOCOL_SOAP)
{
IsSoapRequest = true;
IsWsdlRequest = requestMethod.ToUpper() == "GET" && rawUrl.ToLower().EndsWith("?wsdl");
}
if (IsSoapRequest && !IsWsdlRequest)
{
// get the procedure name from the SOAPAction header
string methodName = soapAction.Replace("\"", "");
methodName = methodName.Substring(methodName.LastIndexOf("/") + 1);
ProcName = ProcName + "." + StringUtil.ReversePrettyStr(methodName);
}
ProcName = SanitizeProcName(ProcName, DadConfig.ExclusionList);
}
else
{
ModuleName = "";
DadName = "";
ProcName = "";
}
if (DadName.Length > 0 && ProcName.Length > 0)
{
string[] urlProcElements = ProcName.Split('.');
if (urlProcElements.Length == 3)
{
// schema, package and procedure specified
OraSchema = urlProcElements[0];
OraPackage = urlProcElements[1];
OraProc = urlProcElements[2];
}
else if (urlProcElements.Length == 2)
{
// assume package and procedure specified (although it could also be schema and procedure, but there is no way to be certain)
OraSchema = "";
OraPackage = urlProcElements[0];
OraProc = urlProcElements[1];
}
else
{
// just the procedure is specified
OraSchema = "";
OraPackage = "";
OraProc = ProcName;
}
logger.Debug("Parsed module = " + ModuleName + ", dad = " + DadName + ", proc = " + ProcName);
}
}
public static int Rights_InsertUpdate(string strConn, int?RoleRightsId, int RoleId, int ModuleId, bool View, bool Edit, bool Create, bool Delete, Guid?CompanyId)
{
const string ProcName = "RoleRights_InsertUpdate()";
SqlConnection connection = null;
SqlParameter param;
DateTime startDate = DateTime.Now;
Guid LoginID = Guid.Empty;
string strMessage = string.Empty;
DataTable dt = new DataTable();
int rowsEffected;
int returnValue;
try
{
connection = DataSource.GetConnection(strConn);
using (SqlCommand command = new SqlCommand())
{
command.CommandText = ProcName.Substring(0, ProcName.Length - 2);
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
param = command.Parameters.Add("@RoleRightsId", SqlDbType.Int);
param.Value = RoleRightsId;
param = command.Parameters.Add("@RoleId", SqlDbType.Int);
param.Value = RoleId;
param = command.Parameters.Add("@ModuleId", SqlDbType.Int);
param.Value = ModuleId;
param = command.Parameters.Add("@View", SqlDbType.Bit);
param.Value = View;
param = command.Parameters.Add("@Edit", SqlDbType.Bit);
param.Value = Edit;
param = command.Parameters.Add("@Create", SqlDbType.Bit);
param.Value = Create;
param = command.Parameters.Add("@Delete", SqlDbType.Bit);
param.Value = Delete;
param = command.Parameters.Add("@CompanyId", SqlDbType.UniqueIdentifier);
param.Value = CompanyId;
param = command.Parameters.Add("@ReturnValue", SqlDbType.Int);
param.Direction = ParameterDirection.ReturnValue;
rowsEffected = command.ExecuteNonQuery();
returnValue = (int)command.Parameters["@ReturnValue"].Value;
}
}
finally
{
DataSource.CloseConnection(connection);
TimeSpan timeSpan = DateTime.Now.Subtract(startDate);
}
return(returnValue);
}
public static int ProductInsert(string strConn, int?Productid, string ProductName, int UOM,
int Colour, int Texture, Guid CreatedBy, string Processid, int BuyProductId, int BuyProductPacking, int Catagory,
Guid CompanyId)
{
const string ProcName = "ProductMaster_InsertUpdate()";
SqlConnection connection = null;
SqlParameter param;
DateTime startDate = DateTime.Now;
Guid LoginID = Guid.Empty;
string strMessage = string.Empty;
DataTable dt = new DataTable();
int rowsEffected;
int returnValue;
try
{
connection = DataSource.GetConnection(strConn);
using (SqlCommand command = new SqlCommand())
{
command.CommandText = ProcName.Substring(0, ProcName.Length - 2);
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
param = command.Parameters.Add("@Productid", SqlDbType.Int);
param.Value = Productid;
param = command.Parameters.Add("@ProductName", SqlDbType.VarChar);
param.Value = ProductName;
param = command.Parameters.Add("@UOM", SqlDbType.Int);
param.Value = UOM;
param = command.Parameters.Add("@Colour", SqlDbType.Int);
param.Value = Colour;
param = command.Parameters.Add("@Texture", SqlDbType.Int);
param.Value = Texture;
param = command.Parameters.Add("@CreatedBy", SqlDbType.UniqueIdentifier);
param.Value = CreatedBy;
param = command.Parameters.Add("@ProcessId", SqlDbType.VarChar);
param.Value = Processid;
param = command.Parameters.Add("@BuyProductId", SqlDbType.Int);
param.Value = BuyProductId;
param = command.Parameters.Add("@Catagory", SqlDbType.Int);
param.Value = Catagory;
param = command.Parameters.Add("@BuyProductPacking", SqlDbType.Int);
param.Value = BuyProductPacking;
param = command.Parameters.Add("@CompanyId", SqlDbType.UniqueIdentifier);
param.Value = CompanyId;
param = command.Parameters.Add("@ReturnValue", SqlDbType.Int);
param.Direction = ParameterDirection.ReturnValue;
rowsEffected = command.ExecuteNonQuery();
returnValue = (int)command.Parameters["@ReturnValue"].Value;
}
}
finally
{
DataSource.CloseConnection(connection);
TimeSpan timeSpan = DateTime.Now.Subtract(startDate);
}
return(returnValue);
}
public static int UOMMaster_InsertUpdate(string strConn, int UOMId, int UOMTypeId, string UOMName, string UOMCode,
int DecimalPoints, bool BaseUnit, decimal ConversionRation, Guid?CreatedBy, Guid?ModifiedBy, Guid?CompanyId)
{
const string ProcName = "UOMMaster_InsertUpdate()";
SqlConnection connection = null;
SqlParameter param;
DateTime startDate = DateTime.Now;
Guid LoginID = Guid.Empty;
string strMessage = string.Empty;
DataTable dt = new DataTable();
int rowsEffected;
int returnValue;
try
{
connection = DataSource.GetConnection(strConn);
using (SqlCommand command = new SqlCommand())
{
command.CommandText = ProcName.Substring(0, ProcName.Length - 2);
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
param = command.Parameters.Add("@UOMId", SqlDbType.Int);
param.Value = UOMId;
param = command.Parameters.Add("@UOMTypeId", SqlDbType.Int);
param.Value = UOMTypeId;
param = command.Parameters.Add("@UOMName", SqlDbType.VarChar);
param.Value = UOMName;
param = command.Parameters.Add("@UOMCode", SqlDbType.VarChar);
param.Value = UOMCode;
param = command.Parameters.Add("@DecimalPoints", SqlDbType.Int);
param.Value = DecimalPoints;
param = command.Parameters.Add("@BaseUnit", SqlDbType.Bit);
param.Value = BaseUnit;
param = command.Parameters.Add("@ConversionRation", SqlDbType.Decimal);
param.Value = ConversionRation;
param = command.Parameters.Add("@CreatedBy", SqlDbType.UniqueIdentifier);
param.Value = CreatedBy;
param = command.Parameters.Add("@ModifiedBy", SqlDbType.UniqueIdentifier);
param.Value = ModifiedBy;
param = command.Parameters.Add("@CompanyId", SqlDbType.UniqueIdentifier);
param.Value = CompanyId;
param = command.Parameters.Add("@ReturnValue", SqlDbType.Int);
param.Direction = ParameterDirection.ReturnValue;
rowsEffected = command.ExecuteNonQuery();
returnValue = (int)command.Parameters["@ReturnValue"].Value;
}
}
finally
{
DataSource.CloseConnection(connection);
TimeSpan timeSpan = DateTime.Now.Subtract(startDate);
}
return(returnValue);
}
public static int ProcessInsert(string strConn, int?ProcessId, string ProcessName, bool QuantityFlag,
bool PackingFlag, String ProcessDuration, float ProcessVolume, bool WastageFlag, int ProcessUnit, Guid?CompanyId, bool byProduct)
{
const string ProcName = "ProcessMaster_InserUpdate()";
SqlConnection connection = null;
SqlParameter param;
DateTime startDate = DateTime.Now;
Guid LoginID = Guid.Empty;
string strMessage = string.Empty;
DataTable dt = new DataTable();
int rowsEffected;
int returnValue;
try
{
connection = DataSource.GetConnection(strConn);
using (SqlCommand command = new SqlCommand())
{
command.CommandText = ProcName.Substring(0, ProcName.Length - 2);
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
param = command.Parameters.Add("@ProcessId", SqlDbType.Int);
param.Value = ProcessId;
param = command.Parameters.Add("@ProcessName", SqlDbType.VarChar);
param.Value = ProcessName;
param = command.Parameters.Add("@QuantityFlag", SqlDbType.Bit);
param.Value = QuantityFlag;
param = command.Parameters.Add("@PackingFlag", SqlDbType.Bit);
param.Value = PackingFlag;
param = command.Parameters.Add("@ProcessDuration", SqlDbType.Time);
param.Value = ProcessDuration;
param = command.Parameters.Add("@WastageFlag", SqlDbType.Bit);
param.Value = WastageFlag;
param = command.Parameters.Add("@QuantityFlag", SqlDbType.Bit);
param.Value = QuantityFlag;
param = command.Parameters.Add("@ByProduct", SqlDbType.Bit);
param.Value = byProduct;
param = command.Parameters.Add("@ProcessVolume", SqlDbType.Float);
param.Value = ProcessVolume;
param = command.Parameters.Add("@CompanyId", SqlDbType.UniqueIdentifier);
param.Value = CompanyId;
param = command.Parameters.Add("@ReturnValue", SqlDbType.Int);
param.Direction = ParameterDirection.ReturnValue;
param = command.Parameters.Add("@ProcessUnit", SqlDbType.Int);
param.Value = ProcessUnit;
rowsEffected = command.ExecuteNonQuery();
returnValue = (int)command.Parameters["@ReturnValue"].Value;
}
}
finally
{
DataSource.CloseConnection(connection);
TimeSpan timeSpan = DateTime.Now.Subtract(startDate);
}
return(returnValue);
}
