public SigmaResultType AddCustomFieldWithEquipmentCustomField(TypeCustomField objCustomField)
{
TypeUserInfo userinfo = AuthMgr.GetUserInfo();
TransactionScope scope = null;
SigmaResultType result = new SigmaResultType();
SigmaResultType customField = new SigmaResultType();
SigmaResultType EquipmentCustomField = new SigmaResultType();
TypeEquipmentCustomField typeEquipmentCustomField = new TypeEquipmentCustomField();
typeEquipmentCustomField.EquipmentId = objCustomField.Parentid;
typeEquipmentCustomField.Value = objCustomField.Value;
typeEquipmentCustomField.CreatedBy = userinfo.SigmaUserId;
typeEquipmentCustomField.UpdatedBy = userinfo.SigmaUserId;
using (scope = new TransactionScope(TransactionScopeOption.Required))
{
CustomFieldMgr custom = new CustomFieldMgr();
customField = custom.AddCustomField(objCustomField);
typeEquipmentCustomField.CustomFieldId = customField.ScalarValue;
EquipmentCustomField = AddEquipmentCustomField(typeEquipmentCustomField);
scope.Complete();
}
return result;
}
public SigmaResultType UpdateEquipmentCustomField(TypeEquipmentCustomField objEquipmentCustomField)
{
TypeUserInfo userinfo = AuthMgr.GetUserInfo();
TransactionScope scope = null;
SigmaResultType result = new SigmaResultType();
// Get connection string
string connStr = ConnStrHelper.getDbConnString();
// Compose parameters
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@EquipmentId", Utilities.ToInt32(objEquipmentCustomField.EquipmentId.ToString().Trim())),
new SqlParameter("@CustomFieldId", Utilities.ToInt32(objEquipmentCustomField.CustomFieldId.ToString().Trim())),
new SqlParameter("@Value", objEquipmentCustomField.Value.Trim()),
new SqlParameter("@UpdatedBy", userinfo.SigmaUserId.Trim())
};
using (scope = new TransactionScope(TransactionScopeOption.Required))
{
result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, "usp_UpdateEquipmentCustomField", parameters);
result.IsSuccessful = true;
scope.Complete();
}
return result;
}
//public SigmaResultType GetEquipmentCustomField(string id)
//{
// SigmaResultType result = new SigmaResultType();
// // Get connection string
// string connStr = ConnStrHelper.getDbConnString();
// // Compose parameters
// SqlParameter[] parameters = new SqlParameter[] {
// new SqlParameter("@", id)
// };
// // Get Data
// DataSet ds = SqlHelper.ExecuteDataset(connStr, "usp_GetEquipmentCustomField", parameters);
// // Convert to REST/JSON String
// result.JsonDataSet = JsonHelper.convertDataTableToJson(ds.Tables[0]);
// result.AffectedRow = 1;
// result.IsSuccessful = true;
// // return
// return result;
//}
//public SigmaResultType ListEquipmentCustomField(string offset, string max, string o_option, string o_desc, string s_option1, string s_option2)
//{
// SigmaResultType result = new SigmaResultType();
// // Get connection string
// string connStr = ConnStrHelper.getDbConnString();
// // Compose parameters
// List<SqlParameter> parameters = new List<SqlParameter>();
// parameters.Add(new SqlParameter("@MaxNumRows", (max == null ? 50 : int.Parse(max))));
// parameters.Add(new SqlParameter("@RetrieveOffset", (offset == null ? 0 : int.Parse(offset))));
// parameters.Add(new SqlParameter("@SortColumn", o_option));
// parameters.Add(new SqlParameter("@SortOrder", (o_desc != null ? o_desc.ToUpper() : null)));
// // Get Data
// DataSet ds = SqlHelper.ExecuteDataset(connStr, "usp_ListCompany", parameters.ToArray());
// // Convert to REST/JSON String
// result.JsonDataSet = JsonHelper.convertDataTableToJson(ds.Tables[0]);
// result.AffectedRow = (int)ds.Tables[1].Rows[0][0];
// result.IsSuccessful = true;
// // return
// return result;
//}
public SigmaResultType AddEquipmentCustomField(TypeEquipmentCustomField objEquipmentCustomField)
{
TypeUserInfo userinfo = AuthMgr.GetUserInfo();
TransactionScope scope = null;
SigmaResultType result = new SigmaResultType();
// Get connection string
string connStr = ConnStrHelper.getDbConnString();
List<SqlParameter> paramList = new List<SqlParameter>();
paramList.Add(new SqlParameter("@EquipmentId", Utilities.ToInt32(objEquipmentCustomField.EquipmentId.ToString().Trim())));
paramList.Add(new SqlParameter("@CustomFieldId", Utilities.ToInt32(objEquipmentCustomField.CustomFieldId.ToString().Trim())));
paramList.Add(new SqlParameter("@Value", objEquipmentCustomField.Value.Trim()));
paramList.Add(new SqlParameter("@CreatedBy", userinfo.SigmaUserId.Trim()));
SqlParameter outParam = new SqlParameter("@NewId", SqlDbType.Int);
outParam.Direction = ParameterDirection.Output;
paramList.Add(outParam);
using (scope = new TransactionScope(TransactionScopeOption.Required))
{
result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, CommandType.StoredProcedure, "usp_AddEquipmentCustomField", paramList.ToArray());
result.IsSuccessful = true;
//result.ScalarValue = (int)outParam.Value;
scope.Complete();
}
return result;
}
private bool CheckEquipmentCustomField(DataTable Exceldt, string ColName, int EquipmentId, string CustomFieldValue)
{
CommonCodeMgr common = new CommonCodeMgr();
CustomFieldMgr customFieldMgr = new CustomFieldMgr();
EquipmentMgr equipmentMgr = new EquipmentMgr();
MaterialCustomFieldMgr materialCustomFieldMgr = new MaterialCustomFieldMgr();
TypeCustomField customField = new TypeCustomField();
TypeEquipmentCustomField equipmentCustomField = new TypeEquipmentCustomField();
SigmaResultType mResult = new SigmaResultType();
SigmaResultType cResult = new SigmaResultType();
DataSet CustomFiledSD = materialCustomFieldMgr.ListMaterialCustomFieldByFieldName(ColName);
DataRow CustomFiledSR = CustomFiledSD.Tables[0].Rows[0];
if (CustomFiledSD.Tables[0].Rows.Count > 0)
{
equipmentCustomField.EquipmentId = EquipmentId;
equipmentCustomField.CustomFieldId = Convert.ToInt32(CustomFiledSR["CustomFieldId"].ToString());
equipmentCustomField.Value = CustomFieldValue;
equipmentCustomField.CreatedBy = userinfo.SigmaUserId;
mResult = equipmentMgr.AddEquipmentCustomField(equipmentCustomField);
}
else
{
customField.FieldName = ColName;
customField.IsDisplayable = "Y";
customField.CreatedBy = userinfo.SigmaUserId;
cResult = customFieldMgr.AddCustomField(customField);
if (cResult.IsSuccessful)
{
equipmentCustomField.EquipmentId = EquipmentId;
equipmentCustomField.CustomFieldId = cResult.ScalarValue;
equipmentCustomField.Value = CustomFieldValue;
equipmentCustomField.CreatedBy = userinfo.SigmaUserId;
mResult = equipmentMgr.AddEquipmentCustomField(equipmentCustomField);
}
}
return mResult.IsSuccessful;
}
